Todd Lipcon created HIVE-21487:
----------------------------------
Summary: COMPLETED_COMPACTIONS table missing appropriate indexes
Key: HIVE-21487
URL: https://issues.apache.org/jira/browse/HIVE-21487
Project: Hive
Issue Type: Bug
Affects Versions: 3.1.1
Reporter: Todd Lipcon
Looking at a MySQL install where HMS is pointed on Hive 3.1, I see a constant
stream of queries of the form:
{code}
select CC_STATE from COMPLETED_COMPACTIONS where CC_DATABASE =
'tpcds_orc_exact_1000' and CC_TABLE = 'catalog_returns' and CC_PARTITION =
'cr_returned_date_sk=2452851' and CC_STATE != 'a' order by CC_ID desc;
{code}
but the COMPLETED_COMPACTIONS table has no index. In this case it's resulting
in a full table scan over 115k rows, which takes around 100ms.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
