[ https://issues.apache.org/jira/browse/HIVE-18599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16352492#comment-16352492 ]
Zoltan Haindrich commented on HIVE-18599: ----------------------------------------- [~steveyeom2017] mm_cttas was failing on master; because there was no q.out for the standard cli version ; and the llap version have missed some posthook change... I've added an addendum to your patch. > Transactions: Fix CTAS on Micromanaged tables > --------------------------------------------- > > Key: HIVE-18599 > URL: https://issues.apache.org/jira/browse/HIVE-18599 > Project: Hive > Issue Type: Bug > Components: Transactions > Affects Versions: 3.0.0 > Reporter: Steve Yeom > Assignee: Steve Yeom > Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18599.01.patch, HIVE-18599.02.patch, > HIVE-18599.03.patch, HIVE-18599.04.patch > > > CTTAS on temporary micromanaged table does not write data. > I.e., "SELECT * FROM ctas0_mm;" does not return any rows from the below > script: > > set hive.mapred.mode=nonstrict; > set hive.explain.user=false; > set hive.fetch.task.conversion=none; > set tez.grouping.min-size=1; > set tez.grouping.max-size=2; > set hive.exec.dynamic.partition.mode=nonstrict; > set hive.support.concurrency=true; > set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; > > drop table intermediate; > create table intermediate(key int) partitioned by (p int) stored as orc; > insert into table intermediate partition(p='455') select distinct key from > src where key >= 0 order by key desc limit 2; > insert into table intermediate partition(p='456') select distinct key from > src where key is not null order by key asc limit 2; > insert into table intermediate partition(p='457') select distinct key from > src where key >= 100 order by key asc limit 2; > > drop table ctas0_mm; > explain create temporary table ctas0_mm tblproperties > ("transactional"="true", "transactional_properties"="insert_only") as select > * from intermediate; > create temporary table ctas0_mm tblproperties ("transactional"="true", > "transactional_properties"="insert_only") as select * from intermediate; > > select * from ctas0_mm; > drop table ctas0_mm; > drop table intermediate; -- This message was sent by Atlassian JIRA (v7.6.3#76005)