[
https://issues.apache.org/jira/browse/HIVE-10307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14521757#comment-14521757
]
Chaoyu Tang commented on HIVE-10307:
------------------------------------
Thanks [~leftylev] for reminding this. IMO, we should document the
hive.typecheck.on.insert in following sections:
Configuration Properties – Query and DDL Execution
DDL – Partitioned Tables
This property name "hive.typecheck.on.insert" is a little confusing since it
controls the column type check to in all static partition operations but not
just insert. But considering the backward compatibility, I continue using this
name in this release and hope in future it will be replace with the name like
"hive.partition.check.column.type".
Note, currently this property only controls the type
check/conversion/normalization to columns specified in partition specification
in static partitions, but it does not apply to dynamic partitions which I am
looking into (see HIVE-10362)
> 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)
