[ 
https://issues.apache.org/jira/browse/HIVE-22458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16970708#comment-16970708
 ] 

Zhihua Deng commented on HIVE-22458:
------------------------------------

A patch for branch-1 has been submited.  As when partitions ordered by 
values.get(i),  a npe will throw on datanucleus version 3. So the getJdoResult 
method in ObjectStore will not implement until datanucleus upgrades to version 
4.

> Add more constraints on showing partitions
> ------------------------------------------
>
>                 Key: HIVE-22458
>                 URL: https://issues.apache.org/jira/browse/HIVE-22458
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Zhihua Deng
>            Priority: Major
>         Attachments: HIVE-22458.2.branch-1.patch, HIVE-22458.branch-1.patch
>
>
> When we showing partitions of a table with thousands of partitions,  all the 
> partitions will be returned and it's not easy to catch the specified one from 
> them, this make showing partitions hard to use. We can add where/limit/order 
> by constraints to show partitions like:
>  show partitions table_name [partition_specs] where partition_field >= value 
> order by partition_field desc limit n;
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to