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