[jira] [Commented] (HIVE-7013) Partition of type int has ambiguity for path like field=01

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

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

Ashutosh Chauhan commented on HIVE-7013:
----------------------------------------

[~reno] There are number of improvements in this area in later versions of Hive. 0.9 is too old. Can you try this with 0.13 ?



> Partition of type int has ambiguity for path like field=01
> ----------------------------------------------------------
>
>                 Key: HIVE-7013
>                 URL: https://issues.apache.org/jira/browse/HIVE-7013
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Peng Zhang
>
> 1. store data in path like /hive/table/year=2014/month=01/day=01
> 2.create table with "partitioned by (year int, month int, day int)"
> 3. add partition(year=2014, month=1, day=1)
>     add partition(year=2014, month=01, day=01)
> This will create two partitions and locations are "/year=2014/month=1/day=1" and "year=2014/month=01/day=01" seperately.
> 4. select   where month=1  => no data 
>     select   where month=01 => no data
>     select   where month="01"  => OK
> I tested this scenario in 0.9, and add partition(year=2014, month=1) with select where month=1 works.



--
This message was sent by Atlassian JIRA
(v6.2#6252)