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

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

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

Zhihua Deng created HIVE-22458:
----------------------------------

             Summary: 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


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)