[jira] [Commented] (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=17111809#comment-17111809 ] 

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

[~jcamachorodriguez] could you take some time to review this too, is there anything else I can do to get the patch through? thanks!

> 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
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>         Attachments: HIVE-22458.2.patch, HIVE-22458.3.patch, HIVE-22458.4.patch, HIVE-22458.5.patch, HIVE-22458.6.patch, HIVE-22458.branch-1.02.patch, HIVE-22458.branch-1.patch, HIVE-22458.patch
>
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> 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_key >= value order by partition_key desc limit n;
>  



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