[HIVE-2702] Enhance listPartitionsByFilter to add support for integral types both for equality and non-equality

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.1
• Fix Version/s: 0.12.0
• Labels: TODOC12
• Assignee: Sergey Shelukhin
• Reporter: Aniket Namadeo Mokashi
• Created: 10/Jan/12 07:18
• Updated: 26/Feb/15 02:42
• Resolved: 30/Jul/13 17:33

Description

listPartitionsByFilter supports only non-string partitions. This is because its explicitly specified in generateJDOFilterOverPartitions in ExpressionTree.java.

//Can only support partitions whose types are string
if( ! table.getPartitionKeys().get(partitionColumnIndex).
getType().equals(org.apache.hadoop.hive.serde.Constants.STRING_TYPE_NAME) )

{ throw new MetaException ("Filtering is supported only on partition keys of type string"); }

Issue Links

• is blocked by: HIVE-4929 the type of all numeric constants is changed to double in the plan
• is duplicated by: HIVE-7164 Support non-string partition types in HCatalog
• is related to: HIVE-2048 Expedite Partition Pruning
• relates to: HCATALOG-347 Pig loads all partitions when it is specifically told not to load all
• relates to: HCATALOG-23 hcat client does not support partition keys other than string, when creating tables
• relates to: HIVE-4888 listPartitionsByFilter doesn't support lt/gt/lte/gte