Naveen Gangam created HIVE-24271:
Summary: Create managed table relies on hive.create.as.acid
settings.
Key: HIVE-24271
URL: https://issues.apache.org/jira/browse/HIVE-24271
Project: Hive
Issue Type: Sub-task
Components: HiveServer2
Affects Versions: 4.0.0
Reporter: Naveen Gangam
Assignee: Naveen Gangam
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 |
|