[ https://issues.apache.org/jira/browse/HIVE-23959?focusedWorklogId=465045&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-465045 ]
ASF GitHub Bot logged work on HIVE-23959: ----------------------------------------- Author: ASF GitHub Bot Created on: 31/Jul/20 14:18 Start Date: 31/Jul/20 14:18 Worklog Time Spent: 10m Work Description: kgyrtkirk commented on a change in pull request #1341: URL: https://github.com/apache/hive/pull/1341#discussion_r463638728 ########## File path: standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java ########## @@ -2960,4 +2977,22 @@ public void lockDbTable(String tableName) throws MetaException { throw new MetaException("Error while locking table " + tableName + ": " + sqle.getMessage()); } } + + public void deleteColumnStatsState(long tbl_id) throws MetaException { + // @formatter:off + String queryText = "" + + "delete from " + PARTITION_PARAMS + " pp" + + " using " + PARTITIONS + " p " + + " where " + + " p.\"PART_ID = pp.\"PART_ID\"" Review comment: I've changed the sql - now it works with mysql as well ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 465045) Time Spent: 1h (was: 50m) > Provide an option to wipe out column stats for partitioned tables in case of > column removal > ------------------------------------------------------------------------------------------- > > Key: HIVE-23959 > URL: https://issues.apache.org/jira/browse/HIVE-23959 > Project: Hive > Issue Type: Improvement > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > Labels: pull-request-available > Time Spent: 1h > Remaining Estimate: 0h > > in case of column removal / replacement - an update for each partition is > neccessary; which could take a while. > goal here is to provide an option to switch to the bulk removal of column > statistics instead of working hard to retain as much as possible from the old > stats. -- This message was sent by Atlassian Jira (v8.3.4#803005)