hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7013) Partition of type int has ambiguity for path like field=01
Date Mon, 12 May 2014 18:16:17 GMT

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

Mime
View raw message