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)