[jira] [Comment Edited] (HIVE-22458) Add more constraints on showing partitions

["Zhihua Deng (Jira)" <ji...@apache.org>]

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

Zhihua Deng edited comment on HIVE-22458 at 4/3/20, 11:48 AM:
--------------------------------------------------------------

Add a workaround for the hive default partition and more tests on branch-1.


was (Author: dengzh):
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.branch-1.02.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)