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)
