[
https://issues.apache.org/jira/browse/HIVE-10307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14519810#comment-14519810
]
Sushanth Sowmyan commented on HIVE-10307:
-----------------------------------------
Added to
https://cwiki.apache.org/confluence/display/Hive/Hive+1.2+Release+Status to
reflect commit.
At this time, requests for inclusion for any new feature patches are closed -
only bugfixes are to be added on. However, since this seems to have been
in-queue for a while, I'll make an exception for this. For any other commits to
branch-1.2, please make sure that (a) They are added to that list before
committing, and (b) are bugfixes.
> 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
> Fix For: 1.2.0
>
> Attachments: HIVE-10307.1.patch, HIVE-10307.2.patch,
> HIVE-10307.3.patch, HIVE-10307.4.patch, HIVE-10307.5.patch,
> HIVE-10307.6.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)
