[jira] [Created] (HIVE-18983) Add support for table properties inheritance in Create table like

["Kryvenko Igor (JIRA)" <ji...@apache.org>]

Kryvenko Igor created HIVE-18983:
------------------------------------

             Summary: Add support for table properties inheritance in Create table like
                 Key: HIVE-18983
                 URL: https://issues.apache.org/jira/browse/HIVE-18983
             Project: Hive
          Issue Type: Improvement
            Reporter: Kryvenko Igor
            Assignee: Kryvenko Igor
             Fix For: 3.0.0


Currently, Create table like support table properties.
But it doesn't inherit table properties from original table.
{code}
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;
 {code}
*Output:*
{code}
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')
{code}
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 .



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)