[HIVE-5686] partition column type validation doesn't quite work for dates

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Assignee: Sergey Shelukhin
• Reporter: Sergey Shelukhin
• Created: 29/Oct/13 22:20
• Updated: 06/Dec/13 15:00
• Resolved: 06/Dec/13 15:00

Description

Another interesting issue...

hive> create table zzzzz(c string) partitioned by (i date,j date);
OK
Time taken: 0.099 seconds
hive> alter table zzzzz add partition (i='2012-01-01', j='foo');          
FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date
hive> alter table zzzzz add partition (i='2012-01-01', j=date 'foo');
OK
Time taken: 0.119 seconds

The fake date is caught in normal queries:

hive> select * from zzzzz where j == date 'foo';
FAILED: SemanticException Unable to convert date literal string to date value.