hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Biao Wu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20199) Improved filtering performance for a large number of partitions in a single table.
Date Wed, 18 Jul 2018 10:39:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-20199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Biao Wu updated HIVE-20199:
---------------------------
    Attachment: 021-HIVE-20199.mysql.sql
        Status: Patch Available  (was: Open)

create an index on field PART_KEY_VAL of table PARTITION_KEY_VALS

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

Mime
View raw message