[ 
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)

Reply via email to