[ 
https://issues.apache.org/jira/browse/HIVE-25057?focusedWorklogId=589317&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-589317
 ]

ASF GitHub Bot logged work on HIVE-25057:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 26/Apr/21 15:57
            Start Date: 26/Apr/21 15:57
    Worklog Time Spent: 10m 
      Work Description: pvary commented on a change in pull request #2219:
URL: https://github.com/apache/hive/pull/2219#discussion_r620432398



##########
File path: 
ql/src/java/org/apache/hadoop/hive/ql/ddl/table/AbstractAlterTableOperation.java
##########
@@ -138,8 +141,32 @@ private void finalizeAlterTableWithWriteIdOp(Table table, 
Table oldTable, List<P
       
environmentContext.putToProperties(HiveMetaHook.ALTER_TABLE_OPERATION_TYPE, 
desc.getType().name());
       if (partitions == null) {
         long writeId = desc.getWriteId() != null ? desc.getWriteId() : 0;
-        context.getDb().alterTable(desc.getDbTableName(), table, 
desc.isCascade(), environmentContext, true,
-            writeId);
+        try {
+          context.getDb().alterTable(desc.getDbTableName(), table, 
desc.isCascade(), environmentContext, true, writeId);
+        } catch (HiveException ex) {
+          if 
(environmentContext.getProperties().containsKey(HiveMetaHook.INITIALIZE_ROLLBACK_ALTER)
 && Boolean
+              
.valueOf(environmentContext.getProperties().get(HiveMetaHook.INITIALIZE_ROLLBACK_ALTER)))
 {
+            // in case of rollback of alter table do the following:
+            // 1. drop the already altered table but keep the data files
+            // 2. recreate the original table
+            // 3. run msck repair to sync partitions on filesystem with 
metastore

Review comment:
       That's what I fear. We might end up adding partitions which are on the 
FS but intentionally not has not been added to the table yet. Also I seem to 
recall that we had issues with `MSCK REPAIR` if the file naming was not correct 
(wrong order of partition keys, or wrong type of values - not valid number for 
an int column etc...)




-- 
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: 589317)
    Time Spent: 5.5h  (was: 5h 20m)

> Implement rollback for hive to iceberg migration
> ------------------------------------------------
>
>                 Key: HIVE-25057
>                 URL: https://issues.apache.org/jira/browse/HIVE-25057
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: László Pintér
>            Assignee: László Pintér
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 5.5h
>  Remaining Estimate: 0h
>
> This is a follow-up Jira of HIVE-25008.
> In case of an error during hive to iceberg migration, the original hive table 
> must be restored. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to