hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karthik Manamcheri (JIRA)" <>
Subject [jira] [Commented] (HIVE-21075) Metastore: Drop partition performance downgrade with Postgres DB
Date Fri, 28 Dec 2018 17:08:00 GMT


Karthik Manamcheri commented on HIVE-21075:

Could we add the index on CD_ID column? Any reason why we don't have an index on that? [~pvary]

> Metastore: Drop partition performance downgrade with Postgres DB
> ----------------------------------------------------------------
>                 Key: HIVE-21075
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 3.0.0
>            Reporter: Yongzhi Chen
>            Priority: Major
> In order to workaround oracle not supporting limit statement caused performance issue,
HIVE-9447 makes all the backend DB run select count(1) from SDS where SDS.CD_ID=? to check
if the specific CD_ID is referenced in SDS table before drop a partition. This select count(1)
statement does not scale well in Postgres, and there is no index for CD_ID column in SDS table.
> For a SDS table with with 1.5 million rows, select count(1) has average 700ms without
index, while in 10-20ms with index. But the statement before HIVE-9447( SELECT * FROM "SDS"
"A0" WHERE "A0"."CD_ID" = $1 limit 1) uses less than 10ms .

This message was sent by Atlassian JIRA

View raw message