[jira] [Commented] (HIVE-10307) Support to use number literals in partition column

["Lefty Leverenz (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-10307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14576764#comment-14576764 ] 

Lefty Leverenz commented on HIVE-10307:
---------------------------------------

Good docs, thanks [~ctang.ma]!  I'm removing the TODOC1.2 label.

Here are the doc links:

# [Configuration Properties – hive.typecheck.on.insert | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.typecheck.on.insert]
# [DDL – Alter Partition | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterPartition]
# [DDL – Rename Partition | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-RenamePartition]
# [DDL – Describe Partition | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribePartition]
# [DML – Inserting data into Hive Tables from queries | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries]

By the way, links in JIRA comments are enclosed in square brackets, with "|" separating the link text from the URL.  The configuration parameter's URL has this format:  https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.typecheck.on.insert .

> 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)