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] [Issue Comment Deleted] (HIVE-22458) Add more constraints on showing partitions
Date Tue, 07 Apr 2020 03:18:00 GMT

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

Zhihua Deng updated HIVE-22458:
-------------------------------
    Comment: was deleted

(was: Would anyone have any ideas about this improvement?   similar implement can be seen
here: [https://teradata.github.io/presto/docs/0.167-t/sql/show-partitions.html])

> 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
>         Attachments: HIVE-22458.branch-1.02.patch, 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