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

["Jesus Camacho Rodriguez (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-22458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez updated HIVE-22458:
-------------------------------------------
    Resolution: Fixed
        Status: Resolved  (was: Patch Available)

Pushed to master, thanks for your contribution [~dengzh].

> 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
>            Assignee: 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 20m
>  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)