[ https://issues.apache.org/jira/browse/HIVE-21678?focusedWorklogId=237586&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-237586 ]
ASF GitHub Bot logged work on HIVE-21678: ----------------------------------------- Author: ASF GitHub Bot Created on: 06/May/19 03:01 Start Date: 06/May/19 03:01 Worklog Time Spent: 10m Work Description: maheshk114 commented on pull request #614: HIVE-21678 URL: https://github.com/apache/hive/pull/614#discussion_r281053603 ########## File path: ql/src/test/queries/clientpositive/ctas.q ########## @@ -61,11 +61,13 @@ create table nzhang_ctas6 (key string, `to` string); insert overwrite table nzhang_ctas6 select key, value from src tablesample (10 rows); create table nzhang_ctas7 as select key, `to` from nzhang_ctas6; - - - - - - - - +-- ACID CTAS +set hive.support.concurrency=true; +set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; +set hive.exec.dynamic.partition.mode=nonstrict; +set hive.stats.autogather=false; + +create table acid_ctas_part partitioned by (k) + stored as orc TBLPROPERTIES ('transactional'='true') + as select key k, value from src order by k limit 5; +select k, value from acid_ctas_part; Review comment: instead of .q file ..i think adding a replication test with CTAS for partitioned ACID table will be more meaningful. ---------------------------------------------------------------- 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: 237586) Time Spent: 20m (was: 10m) > CTAS creating a partitioned table fails because of no writeId > ------------------------------------------------------------- > > Key: HIVE-21678 > URL: https://issues.apache.org/jira/browse/HIVE-21678 > 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 > Attachments: HIVE-21678.01.patch, HIVE-21678.02.patch > > Time Spent: 20m > Remaining Estimate: 0h > > 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) -- This message was sent by Atlassian JIRA (v7.6.3#76005)