Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-10307

Support to use number literals in partition column

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.0
    • Fix Version/s: 1.2.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      Data types like TinyInt, SmallInt, BigInt or Decimal can be expressed as literals with postfix like Y, S, L, or BD appended to the number. These literals work in most Hive queries, but do not when they are used as partition column value. For a partitioned table like:
      create table partcoltypenum (key int, value string) partitioned by (tint tinyint, sint smallint, bint bigint);
      insert into partcoltypenum partition (tint=100Y, sint=10000S, bint=100000000000L) select key, value from src limit 30;

      Queries like select, describe and drop partition do not work. For an example
      select * from partcoltypenum where tint=100Y and sint=10000S and bint=100000000000L;
      does not return any rows.

        Attachments

        1. HIVE-10307.1.patch
          122 kB
          Chaoyu Tang
        2. HIVE-10307.2.patch
          122 kB
          Chaoyu Tang
        3. HIVE-10307.3.patch
          122 kB
          Chaoyu Tang
        4. HIVE-10307.4.patch
          120 kB
          Chaoyu Tang
        5. HIVE-10307.5.patch
          82 kB
          Chaoyu Tang
        6. HIVE-10307.6.patch
          122 kB
          Chaoyu Tang
        7. HIVE-10307.patch
          63 kB
          Chaoyu Tang

          Issue Links

            Activity

              People

              • Assignee:
                ctang.ma Chaoyu Tang
                Reporter:
                ctang.ma Chaoyu Tang
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: