[jira] [Issue Comment Deleted] (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:
-------------------------------------------
    Comment: was deleted

(was: [~dengzh], patch is not applying cleanly on top of master. Can you rebase it? 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
>            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 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)