[
https://issues.apache.org/jira/browse/HIVE-22458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhihua Deng updated HIVE-22458:
-------------------------------
Description:
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;
was:
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;
> 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_key >= value
> order by partition_key desc limit n;
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
