[
https://issues.apache.org/jira/browse/HIVE-25329?focusedWorklogId=641086&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-641086
]
ASF GitHub Bot logged work on HIVE-25329:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 24/Aug/21 13:20
Start Date: 24/Aug/21 13:20
Worklog Time Spent: 10m
Work Description: ujc714 commented on a change in pull request #2477:
URL: https://github.com/apache/hive/pull/2477#discussion_r694842778
##########
File path: ql/src/test/queries/clientpositive/create_table.q
##########
@@ -0,0 +1,39 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.create.as.external.legacy=true;
+
+-- When hive.create.as.external.legacy is true, the tables created with
+-- 'managed' or 'transactional' are ACID tables but the tables create
+-- without 'managed' and 'transactional' are non-ACID tables.
+-- Note: managed non-ACID tables are allowed because tables are not
+-- transformed when hive.in.test is true.
+
+-- Create tables with 'transactional'. These tables have table property
+-- 'transactional'='true'
+create transactional table test11 as select 1;
+show create table test11;
+describe formatted test11;
+
+create transactional table test12 as select 1;
Review comment:
I'll change the test cases then rebase and submit again :)
--
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.
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 641086)
Time Spent: 1h 40m (was: 1.5h)
> CTAS creates a managed table as non-ACID table
> ----------------------------------------------
>
> Key: HIVE-25329
> URL: https://issues.apache.org/jira/browse/HIVE-25329
> Project: Hive
> Issue Type: Bug
> Reporter: Robbie Zhang
> Assignee: Robbie Zhang
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h 40m
> Remaining Estimate: 0h
>
> According to HIVE-22158, MANAGED tables should be ACID tables only. When we
> set hive.create.as.external.legacy to true, the query like 'create managed
> table as select 1' creates a non-ACID table.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
