[HIVE-5864] Hive Table filter Not working (ERROR:SemanticException MetaException)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.12.0
• Component/s: CLI
• Assignee: Unassigned
• Reporter: ashok Kumar
• Created: 21/Nov/13 10:34
• Updated: 21/Oct/22 07:20

Description

hive -e "select * from xxxx where year=2013 and month=11 and day=05 and hour=22"
Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-0.12.0.jar!/hive-log4j.properties
FAILED: SemanticException MetaException(message:Filtering is supported only on partition keys of type string)

and I able to execute the hive -e "select * from xxxx limit 3"

I'm upgraded the Hive from 0.10 to 0.12 and it works in Hive 0.10 .