[
https://issues.apache.org/jira/browse/HIVE-10307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14501025#comment-14501025
]
Lefty Leverenz commented on HIVE-10307:
---------------------------------------
That was quick! Thanks [~ctang.ma].
> 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
> Attachments: HIVE-10307.1.patch, HIVE-10307.2.patch,
> HIVE-10307.3.patch, HIVE-10307.patch
>
>
> 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)
