[
https://issues.apache.org/jira/browse/HIVE-22458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17084701#comment-17084701
]
Zhihua Deng edited comment on HIVE-22458 at 4/16/20, 9:26 AM:
--------------------------------------------------------------
Changes made to fix null returned when a numeric column compares with the
default partition, type mismatch between the column and the constant, and check
the possible invalid input in where clause. [~mgergely] [~jcamachorodriguez]
would you please review the latest changes to see if there anything still
missing or wrong? Thanks~
was (Author: dengzh):
Changes made to fix null returned when a numeric column compares with the
default partition, type mismatch between column and the constant, and check the
possible invalid input in where clause. [~mgergely] [~jcamachorodriguez]
would you please review the latest changes to see if there anything still
missing or wrong? Thanks~
> 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
> Labels: pull-request-available
> Attachments: HIVE-22458.2.patch, HIVE-22458.3.patch,
> HIVE-22458.4.patch, HIVE-22458.5.patch, HIVE-22458.branch-1.02.patch,
> HIVE-22458.branch-1.patch, HIVE-22458.patch
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> 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)
