You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Peng Zhang (JIRA)" <ji...@apache.org> on 2014/05/05 12:11:15 UTC

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

Peng Zhang created HIVE-7013:
--------------------------------

             Summary: 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)