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)