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

Posted to dev@hive.apache.org by "Chu Tong (JIRA)" <ji...@apache.org> on 2014/08/29 04:12:08 UTC

[jira] [Updated] (HIVE-7906) Missing Index on Hive metastore query

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

Chu Tong updated HIVE-7906:
---------------------------

    Description: When it comes to SELECT statement on a table with large number of partitions on Windows Azure DB, the query in the word document below causes major performance degradation. Adding this missing index to turn index scan into seek.  (was: When it comes to SELECT statement on a table with large number of partitions, the query in the word document below causes major performance degradation. Adding this missing index to turn index scan into seek.)

> Missing Index on Hive metastore query
> -------------------------------------
>
>                 Key: HIVE-7906
>                 URL: https://issues.apache.org/jira/browse/HIVE-7906
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.13.1
>            Reporter: Chu Tong
>         Attachments: HIVE-456.patch.txt
>
>
> When it comes to SELECT statement on a table with large number of partitions on Windows Azure DB, the query in the word document below causes major performance degradation. Adding this missing index to turn index scan into seek.



--
This message was sent by Atlassian JIRA
(v6.2#6252)