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