hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhihua Deng (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-22458) Add more constraints on showing partitions
Date Sat, 09 Nov 2019 03:25:00 GMT

     [ 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)

Mime
View raw message