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

Posted to dev@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2014/11/17 02:03:07 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 ]

Ashutosh Chauhan updated HIVE-7906:
-----------------------------------
    Status: Open  (was: Patch Available)

scripts responsible for metastore tables are in {{metastore/scripts/upgrade}} dir

> 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.3.4#6332)