Naresh P R created HIVE-22478: --------------------------------- Summary: Import command fails from lower version to higher version when hive.strict.managed.tables enabled Key: HIVE-22478 URL: https://issues.apache.org/jira/browse/HIVE-22478 Project: Hive Issue Type: Bug Reporter: Naresh P R Assignee: Naresh P R
Created non-acid managed orc table in lower version, after inserting some records, exported the table. In higher version where hive.strict.managed.enabled=true, 1) on first attempt, ACID Table is getting created, but LoadTable is failing with below exception {code:java} Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: MoveTask : Write id is not set in the config by open txn task for migration at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:400) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:212) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:103) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2712) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:2383) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:2055) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1753) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1747) at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:157) at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:226){code} 2) On second attempt, as the table is already exist as ACID, ImportSemanticAnalyzer is creating writeId for the ACID table & LoadTable command is successful. -- This message was sent by Atlassian Jira (v8.3.4#803005)