[ https://issues.apache.org/jira/browse/HIVE-19605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vihang Karajgaonkar updated HIVE-19605: --------------------------------------- Resolution: Fixed Fix Version/s: 4.0.0 3.1.0 Status: Resolved (was: Patch Available) Patch merged to master and branch-3. Thanks for the review [~ychena] > TAB_COL_STATS table has no index on db/table name > ------------------------------------------------- > > Key: HIVE-19605 > URL: https://issues.apache.org/jira/browse/HIVE-19605 > Project: Hive > Issue Type: Bug > Components: Metastore > Reporter: Todd Lipcon > Assignee: Vihang Karajgaonkar > Priority: Major > Fix For: 3.1.0, 4.0.0 > > Attachments: HIVE-19605.01.patch, HIVE-19605.02.patch > > > The TAB_COL_STATS table is missing an index on (CAT_NAME, DB_NAME, > TABLE_NAME). The getTableColumnStatistics call queries based on this tuple. > This makes those queries take a significant amount of time in large > metastores since they do a full table scan. -- This message was sent by Atlassian JIRA (v7.6.3#76005)