[HIVE-18983] Add support for table properties inheritance in Create table like

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Assignee: Igor Kryvenko
• Reporter: Igor Kryvenko
• Created: 16/Mar/18 20:57
• Updated: 21/Oct/22 07:31

Description

Currently, Create table like support table properties.
But it doesn't inherit table properties from original table.

create table T1(a int, b int) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('comment'='comm');
create table T like T1;
show create table T;
 

Output:

CREATE TABLE `T`(
  `a` int, 
  `b` int)
CLUSTERED BY ( 
  a) 
INTO 2 BUCKETS
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.ql.io.orc.OrcSerde' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
LOCATION
  'maprfs:/user/hive/warehouse/t'
TBLPROPERTIES (
  'COLUMN_STATS_ACCURATE'='{\"BASIC_STATS\":\"true\"}', 
  'numFiles'='0', 
  'numRows'='0', 
  'rawDataSize'='0', 
  'totalSize'='0', 
  'transient_lastDdlTime'='1521230300')

It uses just default table properties and doesn't inherit properties from original table.
It would be great if create table like will inherit origin table properties and will override them if they are specified in query .

Issue Links

• is related to: HIVE-22098 Data loss occurs when multiple tables are join with different bucket_version
• relates to: HIVE-18736 Create Table Like doc needs to be updated
• relates to: HIVE-18735 Create table like loses transactional attribute
• links to: Review board