[HIVE-4888] listPartitionsByFilter doesn't support lt/gt/lte/gte

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Assignee: Sergey Shelukhin Assign to me
• Reporter: Sergey Shelukhin
• Created: 19/Jul/13 02:32
• Updated: 06/Oct/13 03:34
• Resolved: 05/Oct/13 09:50

Description

Filter pushdown could be improved. Based on my experiments there's no reasonable way to do it with DN 2.0, due to DN bug in substring and Collection.get(int) not being implemented.
With version as low as 2.1 we can use values.get on partition to extract values to compare to. Type compatibility is an issue, but is easy for strings and integral values.

Issue Links

• is blocked by: HIVE-4914 filtering via partition name should be done inside metastore server (implementation)
• is blocked by: HIVE-2084 Upgrade datanucleus from 2.0.3 to a more recent version (3.?)
• is related to: HIVE-2702 Enhance listPartitionsByFilter to add support for integral types both for equality and non-equality