hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaoyu Tang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10307) Support to use number literals in partition column
Date Fri, 01 May 2015 02:50:05 GMT

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

Mime
View raw message