You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Naresh P R (Jira)" <ji...@apache.org> on 2019/11/11 14:31:00 UTC

[jira] [Created] (HIVE-22478) Import command fails from lower version to higher version when hive.strict.managed.tables enabled

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)