[ https://issues.apache.org/jira/browse/HIVE-1609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12909930#action_12909930 ]
Paul Yang commented on HIVE-1609: --------------------------------- A couple of suggestions: 1. Update get_partitions_ps() to use get_partitions_by_filter(). By doing this, we should see some speedup when using the Hive CLI for tables with large number of partitions. (May require #2 for full benefits) 2. could we add a listPartitionNamesByFilter() as well to RawStore/ObjectStore? This would allow partition filtering for get_partition_names_ps(). This could be done in a separate JIRA, if necessary. 3. Add test cases to TestHiveMetastore for the new method(s). I'll take another look once the antlr stuff is done, but looks good. > Support partition filtering in metastore > ---------------------------------------- > > Key: HIVE-1609 > URL: https://issues.apache.org/jira/browse/HIVE-1609 > Project: Hadoop Hive > Issue Type: New Feature > Components: Metastore > Reporter: Ajay Kidave > Assignee: Ajay Kidave > Fix For: 0.7.0 > > Attachments: hive_1609.patch, hive_1609_2.patch > > > The metastore needs to have support for returning a list of partitions based > on user specified filter conditions. This will be useful for tools which need > to do partition pruning. Howl is one such use case. The way partition pruning > is done during hive query execution need not be changed. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.