[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated HIVE-18983: --- Fix Version/s: (was: 3.2.0) I cleared the fixVersion field since this ticket is not resolved. Please review this ticket and if the fix is already committed to a specific version please set the version accordingly and mark the ticket as RESOLVED. According to the JIRA guidelines (https://cwiki.apache.org/confluence/display/Hive/HowToContribute) the fixVersion should be set only when the issue is resolved/closed. > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Major > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch, > HIVE-18983.09.patch, HIVE-18983.10.patch, HIVE-18983.11.patch, > HIVE-18983.12.patch > > > 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 (v8.20.10#820010)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18983: --- Fix Version/s: (was: 3.1.0) 3.2.0 Deferring this to 3.2.0 since the branch for 3.1.0 has been cut off. > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Major > Fix For: 3.2.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch, > HIVE-18983.09.patch, HIVE-18983.10.patch, HIVE-18983.11.patch, > HIVE-18983.12.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Igor Kryvenko updated HIVE-18983: - Priority: Major (was: Minor) > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch, > HIVE-18983.09.patch, HIVE-18983.10.patch, HIVE-18983.11.patch, > HIVE-18983.12.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Igor Kryvenko updated HIVE-18983: - Attachment: HIVE-18983.12.patch > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Minor > Fix For: 3.1.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch, > HIVE-18983.09.patch, HIVE-18983.10.patch, HIVE-18983.11.patch, > HIVE-18983.12.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Igor Kryvenko updated HIVE-18983: - Attachment: HIVE-18983.11.patch > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Minor > Fix For: 3.1.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch, > HIVE-18983.09.patch, HIVE-18983.10.patch, HIVE-18983.11.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18983: --- Fix Version/s: (was: 3.0.0) 3.1.0 Deferring this to 3.1.0 since the branch for 3.0.0 has been cut off. Please update the JIRA if you would like to get your patch in 3.0.0. > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Minor > Fix For: 3.1.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch, > HIVE-18983.09.patch, HIVE-18983.10.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Igor Kryvenko updated HIVE-18983: - Attachment: HIVE-18983.10.patch > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch, > HIVE-18983.09.patch, HIVE-18983.10.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Igor Kryvenko updated HIVE-18983: - Attachment: HIVE-18983.09.patch > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch, > HIVE-18983.09.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Igor Kryvenko updated HIVE-18983: - Attachment: HIVE-18983.08.patch > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch, HIVE-18983.08.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Igor Kryvenko updated HIVE-18983: - Attachment: HIVE-18983.07.patch > 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: Igor Kryvenko >Assignee: Igor Kryvenko >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch, HIVE-18983.07.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Attachment: HIVE-18983.06.patch > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch, > HIVE-18983.06.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Attachment: HIVE-18983.05.patch > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch, HIVE-18983.05.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Attachment: HIVE-18983.04.patch > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch, HIVE-18983.04.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Attachment: HIVE-18983.03.patch > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch, > HIVE-18983.03.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Attachment: HIVE-18983.02.patch > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch, HIVE-18983.02.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Attachment: (was: HIVE-18983.02.patch) > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Attachment: HIVE-18983.02.patch > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Attachment: HIVE-18983.01.patch > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch > > > 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)
[jira] [Updated] (HIVE-18983) Add support for table properties inheritance in Create table like
[ https://issues.apache.org/jira/browse/HIVE-18983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kryvenko Igor updated HIVE-18983: - Status: Patch Available (was: Open) > 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 >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18983.01.patch > > > 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)