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)
