hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Todd Lipcon (JIRA)" <>
Subject [jira] [Commented] (HIVE-19605) TAB_COL_STATS table has no index on db/table name
Date Tue, 22 May 2018 21:37:00 GMT


Todd Lipcon commented on HIVE-19605:

It seems like this table can also be called from a get_table call. Oddly, the query being
generated is:


(note the empty db_name).

Given the lack of index, this takes 450ms on the HMS instance I am testing (if the mysql query
cache is disabled)

> TAB_COL_STATS table has no index on db/table name
> -------------------------------------------------
>                 Key: HIVE-19605
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>            Reporter: Todd Lipcon
>            Priority: Major
> 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

View raw message