[
https://issues.apache.org/jira/browse/HIVE-23765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-23765:
----------------------------------
Labels: pull-request-available (was: )
> 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
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
