[
https://issues.apache.org/jira/browse/HIVE-10307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14521083#comment-14521083
]
Lefty Leverenz commented on HIVE-10307:
---------------------------------------
Doc note: This extends the use of *hive.typecheck.on.insert* and adds a
parameter description. The parameter was introduced in 0.12.0 but isn't
documented in the wiki yet.
The use of number literals in partition columns also needs to be documented.
Does it belong in the create and alter sections of the DDL doc or in the insert
section(s) of the DML doc? Or how about the Select doc? Or Data Types?
* [Configuration Properties -- Query and DDL Execution |
https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-QueryandDDLExecution]
* [DDL -- Partitioned Tables |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-PartitionedTables]
* [DDL -- Alter Partition |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterPartition]
* [DML -- Inserting data into Hive Tables from queries |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries]
* [DML -- Inserting values into tables from SQL |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingvaluesintotablesfromSQL]
* [Select -- Partition Based Queries |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-PartitionBasedQueries]
* [Data Types -- Column Types |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-ColumnTypes]
* [Data Types -- Literals |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Literals]
> 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)
