Xiaomeng Zhang created HIVE-23765:
-------------------------------------
Summary: Use ORC file format by default when creating
transactional table
Key: HIVE-23765
URL: https://issues.apache.org/jira/browse/HIVE-23765
Project: Hive
Issue Type: New Feature
Components: HiveServer2
Affects Versions: 4.0.0
Reporter: Xiaomeng Zhang
Assignee: Xiaomeng Zhang
Currently we support "transactional" keyword in CREATE TABLE command. But if
not add "stored as ORC", the table created is insert_only.
We want to add a feature that when table is transactional (either using
"transanctional" keyword or adding tblproperties ('transactional'='true'), the
table created by default will be ORC, and 'transactional_properties'='default'.
{code:java}
0: jdbc:hive2://localhost:10000> create transactional table xm_tran(id int);
+-------------------------------+----------------------------------------------------+----------------------------------------------------+
| col_name | data_type
| comment |
+-------------------------------+----------------------------------------------------+----------------------------------------------------+
| id | int
| |
| | NULL
| NULL |
| # Detailed Table Information | NULL
| NULL |
| Database: | default
| NULL |
| OwnerType: | USER
| NULL |
| Owner: | hive
| NULL |
| CreateTime: | Thu Jun 18 14:01:45 PDT 2020
| NULL |
| LastAccessTime: | UNKNOWN
| NULL |
| Retention: | 0
| NULL |
| Location: | file:/tmp/warehouse/managed/xm_tran
| NULL |
| Table Type: | MANAGED_TABLE
| NULL |
| Table Parameters: | NULL
| NULL |
| | COLUMN_STATS_ACCURATE
| {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"id\":\"true\"}} |
| | bucketing_version
| 2 |
| | numFiles
| 0 |
| | numRows
| 0 |
| | rawDataSize
| 0 |
| | totalSize
| 0 |
| | transactional
| true |
| | transactional_properties
| insert_only |
| | transient_lastDdlTime
| 1592514105 |
| | NULL
| NULL |
| # Storage Information | NULL
| NULL |
| SerDe Library: |
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | NULL
|
| InputFormat: | org.apache.hadoop.mapred.TextInputFormat
| NULL |
| OutputFormat: |
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL
|
| Compressed: | No
| NULL |
| Num Buckets: | -1
| NULL |
| Bucket Columns: | []
| NULL |
| Sort Columns: | []
| NULL |
+-------------------------------+----------------------------------------------------+----------------------------------------------------+
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
