You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2021/08/23 09:18:00 UTC
[jira] [Work logged] (HIVE-25329) CTAS creates a managed table as
non-ACID table
[ https://issues.apache.org/jira/browse/HIVE-25329?focusedWorklogId=640639&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-640639 ]
ASF GitHub Bot logged work on HIVE-25329:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 23/Aug/21 09:17
Start Date: 23/Aug/21 09:17
Worklog Time Spent: 10m
Work Description: abstractdog commented on a change in pull request #2477:
URL: https://github.com/apache/hive/pull/2477#discussion_r693802859
##########
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:
why are all the test cases duplicated here?
--
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-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 640639)
Time Spent: 1h 10m (was: 1h)
> 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 10m
> 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)