[
https://issues.apache.org/jira/browse/HIVE-10307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14522691#comment-14522691
]
Chaoyu Tang commented on HIVE-10307:
------------------------------------
[~leftylev] I updated wiki for the hive.typecheck.on.insert property and the
use of number liberals as partition value in following related sections (sorry,
I have not figured out how to link these sections to their website in JIRA as
you did):
1. Configuration Properties – Query and DDL Execution
2. DDL – Alter Partition
3. DDL – Describe Partition
4. DML – Inserting data into Hive Tables from queries
Please review them and feel free to revise if necessary. Thanks
> 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
> Labels: TODOC1.2
> 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)
