[
https://issues.apache.org/jira/browse/HIVE-21075?focusedWorklogId=688020&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-688020
]
ASF GitHub Bot logged work on HIVE-21075:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 30/Nov/21 13:47
Start Date: 30/Nov/21 13:47
Worklog Time Spent: 10m
Work Description: pvary commented on a change in pull request #2826:
URL: https://github.com/apache/hive/pull/2826#discussion_r759293972
##########
File path:
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/ObjectStore.java
##########
@@ -5275,38 +5275,67 @@ private void
removeUnusedColumnDescriptor(MColumnDescriptor oldCD) {
return;
}
- boolean success = false;
Query query = null;
+ Query query2 = null;
+ boolean success = false;
+ LOG.debug("execute removeUnusedColumnDescriptor");
+ DatabaseProduct dbProduct =
DatabaseProduct.determineDatabaseProduct(MetaStoreDirectSql.getProductName(pm),
conf);
+ /**
+ * 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 .
+ */
try {
openTransaction();
- LOG.debug("execute removeUnusedColumnDescriptor");
-
- query = pm.newQuery("select count(1) from " +
- "org.apache.hadoop.hive.metastore.model.MStorageDescriptor where
(this.cd == inCD)");
- query.declareParameters("MColumnDescriptor inCD");
- long count = ((Long)query.execute(oldCD)).longValue();
-
- //if no other SD references this CD, we can throw it out.
- if (count == 0) {
- // First remove any constraints that may be associated with this CD
- query = pm.newQuery(MConstraint.class, "parentColumn == inCD ||
childColumn == inCD");
+ // Fix performance regression for postgres caused by HIVE-9447
+ if (dbProduct.isPOSTGRES() || dbProduct.isMYSQL()) {
+ query = pm.newQuery(MStorageDescriptor.class, "this.cd == inCD");
+ query.declareParameters("MColumnDescriptor inCD");
+ List<MStorageDescriptor> referencedSDs =
listStorageDescriptorsWithCD(oldCD, query);
+ //if no other SD references this CD, we can throw it out.
+ if (referencedSDs != null && referencedSDs.isEmpty()) {
+ query2 = removeConstraintsAndCd(oldCD);
+ }
+ } else {
+ query = pm.newQuery(
+ "select count(1) from
org.apache.hadoop.hive.metastore.model.MStorageDescriptor where (this.cd ==
inCD)");
query.declareParameters("MColumnDescriptor inCD");
- List<MConstraint> mConstraintsList = (List<MConstraint>)
query.execute(oldCD);
- if (CollectionUtils.isNotEmpty(mConstraintsList)) {
- pm.deletePersistentAll(mConstraintsList);
+ long count = (Long) query.execute(oldCD);
+ //if no other SD references this CD, we can throw it out.
+ if (count == 0) {
+ query2 = removeConstraintsAndCd(oldCD);
}
- // Finally remove CD
- pm.retrieve(oldCD);
- pm.deletePersistent(oldCD);
}
success = commitTransaction();
- LOG.debug("successfully deleted a CD in removeUnusedColumnDescriptor");
} finally {
rollbackAndCleanup(success, query);
+ if (query2 != null) {
+ query2.closeAll();
+ }
}
}
+ private Query removeConstraintsAndCd(MColumnDescriptor oldCD) {
+ Query query = null;
Review comment:
We added QueryWrapper lately, and started to use it extensively:
https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/ObjectStore.java#L3379
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 688020)
Time Spent: 5.5h (was: 5h 20m)
> Metastore: Drop partition performance downgrade with Postgres DB
> ----------------------------------------------------------------
>
> Key: HIVE-21075
> URL: https://issues.apache.org/jira/browse/HIVE-21075
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 3.0.0
> Reporter: Yongzhi Chen
> Assignee: Oleksiy Sayankin
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-21075.2.patch
>
> Time Spent: 5.5h
> Remaining Estimate: 0h
>
> 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
(v8.20.1#820001)
