[HIVE-24271] Create managed table relies on hive.create.as.acid settings.

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: HiveServer2
• Labels: pull-request-available
• Assignee: Naveen Gangam
• Reporter: Naveen Gangam
• Created: 14/Oct/20 05:36
• Updated: 17/Nov/22 08:48
• Resolved: 16/Oct/20 01:06

Description

0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si> set hive.create.as.acid;
----------------------------

set

----------------------------

hive.create.as.acid=false

----------------------------
1 row selected (0.018 seconds)
0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si> set hive.create.as.insert.only;
-----------------------------------

set

-----------------------------------

hive.create.as.insert.only=false

-----------------------------------
1 row selected (0.013 seconds)
0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si> create managed table mgd_table(a int);
INFO : Compiling command(queryId=hive_20201014053526_9ba1ffa3-3aa2-47c3-8514-1fe58fe4f140): create managed table mgd_table(a int)
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null)
INFO : Completed compiling command(queryId=hive_20201014053526_9ba1ffa3-3aa2-47c3-8514-1fe58fe4f140); Time taken: 0.021 seconds
INFO : Executing command(queryId=hive_20201014053526_9ba1ffa3-3aa2-47c3-8514-1fe58fe4f140): create managed table mgd_table(a int)
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing command(queryId=hive_20201014053526_9ba1ffa3-3aa2-47c3-8514-1fe58fe4f140); Time taken: 0.048 seconds
INFO : OK
No rows affected (0.107 seconds)
0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si> describe formatted mgd_table;
INFO : Compiling command(queryId=hive_20201014053533_8919be7d-41b0-41e5-b9eb-847801a9d8c5): describe formatted mgd_table
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null)
INFO : Completed compiling command(queryId=hive_20201014053533_8919be7d-41b0-41e5-b9eb-847801a9d8c5); Time taken: 0.037 seconds
INFO : Executing command(queryId=hive_20201014053533_8919be7d-41b0-41e5-b9eb-847801a9d8c5): describe formatted mgd_table
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing command(queryId=hive_20201014053533_8919be7d-41b0-41e5-b9eb-847801a9d8c5); Time taken: 0.03 seconds
INFO : OK
-----------------------------------------------------------------------------------------------------------------------------------

col_name

data_type

comment

-----------------------------------------------------------------------------------------------------------------------------------

a	int
	NULL	NULL
Detailed Table Information	NULL	NULL
Database:	bothfalseonhs2	NULL
OwnerType:	USER	NULL
Owner:	hive	NULL
CreateTime:	Wed Oct 14 05:35:26 UTC 2020	NULL
LastAccessTime:	UNKNOWN	NULL
Retention:	0	NULL
Location:	hdfs://ngangam-3.ngangam.root.hwx.site:8020/warehouse/tablespace/external/hive/bothfalseonhs2.db/mgd_table	NULL
Table Type:	EXTERNAL_TABLE	NULL
Table Parameters:	NULL	NULL
	COLUMN_STATS_ACCURATE	{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\"}}
	EXTERNAL	TRUE
	TRANSLATED_TO_EXTERNAL	TRUE
	bucketing_version	2
	external.table.purge	TRUE
	numFiles	0
	numRows	0
	rawDataSize	0
	totalSize	0
	transient_lastDdlTime	1602653726
	NULL	NULL
Storage Information	NULL	NULL
SerDe Library:	org.apache.hadoop.hive.ql.io.orc.OrcSerde	NULL
InputFormat:	org.apache.hadoop.hive.ql.io.orc.OrcInputFormat	NULL
OutputFormat:	org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat	NULL
Compressed:	No	NULL
Num Buckets:	-1	NULL
Bucket Columns:	[]	NULL
Sort Columns:	[]	NULL
Storage Desc Params:	NULL	NULL
	serialization.format	1

-----------------------------------------------------------------------------------------------------------------------------------
33 rows selected (0.116 seconds)
0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si>

Issue Links

• links to: GitHub Pull Request #1578