hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaoyu Tang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-10307) Support to use number literals in partition column
Date Sat, 11 Apr 2015 00:46:13 GMT
Chaoyu Tang created HIVE-10307:
----------------------------------

             Summary: Support to use number literals in partition column
                 Key: HIVE-10307
                 URL: https://issues.apache.org/jira/browse/HIVE-10307
             Project: Hive
          Issue Type: Improvement
          Components: Query Processor
    Affects Versions: 1.0.0
            Reporter: Chaoyu Tang
            Assignee: Chaoyu Tang


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message