You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Zhihua Deng (Jira)" <ji...@apache.org> on 2019/11/09 03:25:00 UTC

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

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

Zhihua Deng updated HIVE-22458:
-------------------------------
    Attachment: HIVE-22458.branch-1.patch

> Add more constraints on showing partitions
> ------------------------------------------
>
>                 Key: HIVE-22458
>                 URL: https://issues.apache.org/jira/browse/HIVE-22458
>             Project: Hive
>          Issue Type: New Feature
>            Reporter: Zhihua Deng
>            Priority: Major
>         Attachments: 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)