[ https://issues.apache.org/jira/browse/HIVE-22396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-22396: ------------------------------------------- Description: create materialized view acid_cmv_part disable rewrite partitioned on (k) stored as orc TBLPROPERTIES ('transactional'='true') as select key k, value from src order by k limit 5; ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in the config by open txn task for migration Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in the config by open txn task for migration (state=08S01,code=1) was: create table t1(a int, b int); insert into t1 values (1, 2), (3, 4); create table t6_part partitioned by (a) stored as orc tblproperties ("transactional"="true") as select * from t1; ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in the config by open txn task for migration Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in the config by open txn task for migration (state=08S01,code=1) > CMV creating a Full ACID partitioned table fails because of no writeId > ---------------------------------------------------------------------- > > Key: HIVE-22396 > URL: https://issues.apache.org/jira/browse/HIVE-22396 > Project: Hive > Issue Type: Sub-task > Components: HiveServer2, repl > Affects Versions: 4.0.0 > Reporter: Ashutosh Bapat > Assignee: Ashutosh Bapat > Priority: Major > Labels: pull-request-available > > create materialized view acid_cmv_part disable rewrite partitioned on (k) > stored as orc TBLPROPERTIES ('transactional'='true') > as select key k, value from src order by k limit 5; > ERROR : FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not set in > the config by open txn task for migration > Error: Error while processing statement: FAILED: Execution Error, return code > 1 from org.apache.hadoop.hive.ql.exec.MoveTask. MoveTask : Write id is not > set in the config by open txn task for migration (state=08S01,code=1) -- This message was sent by Atlassian Jira (v8.3.4#803005)