[
https://issues.apache.org/jira/browse/HIVE-20199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547691#comment-16547691
]
tartarus commented on HIVE-20199:
---------------------------------
If there are too many partition table, use the jdo query performance also is
not very good, looking forward to more optimization!!
LGTM
> Improved filtering performance for a large number of partitions in a single
> table.
> ----------------------------------------------------------------------------------
>
> Key: HIVE-20199
> URL: https://issues.apache.org/jira/browse/HIVE-20199
> Project: Hive
> Issue Type: Improvement
> Components: Metastore
> Affects Versions: 1.2.1
> Reporter: Biao Wu
> Assignee: Biao Wu
> Priority: Major
> Attachments: 021-HIVE-20199.mysql.sql
>
>
> eg:
> {code:sql}
> select * from test where dt = '20180606'
> {code}
> The filter 'dt=20180606' will be pushed down to mysql for execution, but the
> test table contains a large number of partitions, this is a poor performance.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
