[ https://issues.apache.org/jira/browse/HIVE-20246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16572650#comment-16572650 ]
Hive QA commented on HIVE-20246: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12934740/HIVE-20246.1.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 14869 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13094/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13094/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13094/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12934740 - PreCommit-HIVE-Build > Configurable collecting stats by using DO_NOT_UPDATE_STATS table property > ------------------------------------------------------------------------- > > Key: HIVE-20246 > URL: https://issues.apache.org/jira/browse/HIVE-20246 > Project: Hive > Issue Type: Improvement > Components: Metastore > Reporter: Alice Fan > Assignee: Alice Fan > Priority: Minor > Fix For: 4.0.0 > > Attachments: HIVE-20246.1.patch > > > By default, Hive collects stats when running operations like alter table > partition(s), create table, and create external table. However, collecting > stats requires Metastore lists all files under the table directory and the > file listing operation can be very expensive particularly on filesystems like > S3. > HIVE-18743 made DO_NOT_UPDATE_STATS table property could be selectively > prevent stats collection. > This Jira aims at introducing DO_NOT_UPDATE_STATS table property into the > MetaStoreUtils.updatePartitionStatsFast. By adding this, user can be > selectively prevent stats collection when doing alter table partition(s) > operation at table level. For example, set 'Alter Table S3_Table set > tblproperties('DO_NOT_UPDATE_STATS'='TRUE');' MetaStore will not collect > stats for the specified S3_Table when alter table add partition(key1=val1, > key2=val2); -- This message was sent by Atlassian JIRA (v7.6.3#76005)