[jira] [Updated] (HIVE-11340) Create ORC based table using like clause doesn't copy compression property
[ https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-11340: Target Version/s: 1.3.0 > Create ORC based table using like clause doesn't copy compression property > -- > > Key: HIVE-11340 > URL: https://issues.apache.org/jira/browse/HIVE-11340 > Project: Hive > Issue Type: Bug > Components: File Formats >Affects Versions: 0.14.0, 1.0.0, 1.2.0 >Reporter: Gaurav Kohli >Assignee: Yongzhi Chen >Priority: Minor > Fix For: 2.0.0 > > Attachments: HIVE-11340.1.patch, HIVE-11340.2.patch > > > I found a issue in “create table like” clause, as it is not copying the table > properties from ORC File format based table. > Steps to reproduce: > Step1 : > {code} > create table orc_table ( > time string) > stored as ORC tblproperties ("orc.compress"="SNAPPY"); > {code} > Step 2: > {code} > create table orc_table_using_like like orc_table; > {code} > Step 3: > {code} > show create table orc_table_using_like; > {code} > Result: > {code} > createtab_stmt > CREATE TABLE `orc_table_using_like`( > `time` string) > 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 > 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' > TBLPROPERTIES ( > 'transient_lastDdlTime'='1437578939') > {code} > Issue: 'orc.compress'='SNAPPY' property is missing -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11340) Create ORC based table using like clause doesn't copy compression property
[ https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-11340: Should this issue be backported to branch-1? It looks like a bug. > Create ORC based table using like clause doesn't copy compression property > -- > > Key: HIVE-11340 > URL: https://issues.apache.org/jira/browse/HIVE-11340 > Project: Hive > Issue Type: Bug > Components: File Formats >Affects Versions: 0.14.0, 1.0.0, 1.2.0 >Reporter: Gaurav Kohli >Assignee: Yongzhi Chen >Priority: Minor > Fix For: 2.0.0 > > Attachments: HIVE-11340.1.patch, HIVE-11340.2.patch > > > I found a issue in “create table like” clause, as it is not copying the table > properties from ORC File format based table. > Steps to reproduce: > Step1 : > {code} > create table orc_table ( > time string) > stored as ORC tblproperties ("orc.compress"="SNAPPY"); > {code} > Step 2: > {code} > create table orc_table_using_like like orc_table; > {code} > Step 3: > {code} > show create table orc_table_using_like; > {code} > Result: > {code} > createtab_stmt > CREATE TABLE `orc_table_using_like`( > `time` string) > 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 > 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' > TBLPROPERTIES ( > 'transient_lastDdlTime'='1437578939') > {code} > Issue: 'orc.compress'='SNAPPY' property is missing -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11340) Create ORC based table using like clause doesn't copy compression property
[ https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chao Sun updated HIVE-11340: Description: I found a issue in “create table like” clause, as it is not copying the table properties from ORC File format based table. Steps to reproduce: Step1 : {code} create table orc_table ( time string) stored as ORC tblproperties (orc.compress=SNAPPY); {code} Step 2: {code} create table orc_table_using_like like orc_table; {code} Step 3: {code} show create table orc_table_using_like; {code} Result: {code} createtab_stmt CREATE TABLE `orc_table_using_like`( `time` string) 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 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' TBLPROPERTIES ( 'transient_lastDdlTime'='1437578939') {code} Issue: 'orc.compress'='SNAPPY' property is missing was: I found a issue in “create table like” clause, as it is not copying the table properties from ORC File format based table. Steps to reproduce: Step1 : create table orc_table ( time string) stored as ORC tblproperties (orc.compress=SNAPPY); Step 2: create table orc_table_using_like like orc_table; Step 3: show create table orc_table_using_like; Result: createtab_stmt CREATE TABLE `orc_table_using_like`( `time` string) 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 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' TBLPROPERTIES ( 'transient_lastDdlTime'='1437578939') Issue: 'orc.compress'='SNAPPY' property is missing Create ORC based table using like clause doesn't copy compression property -- Key: HIVE-11340 URL: https://issues.apache.org/jira/browse/HIVE-11340 Project: Hive Issue Type: Bug Components: File Formats Affects Versions: 0.14.0, 1.0.0, 1.2.0 Reporter: Gaurav Kohli Assignee: Yongzhi Chen Priority: Minor Attachments: HIVE-11340.1.patch I found a issue in “create table like” clause, as it is not copying the table properties from ORC File format based table. Steps to reproduce: Step1 : {code} create table orc_table ( time string) stored as ORC tblproperties (orc.compress=SNAPPY); {code} Step 2: {code} create table orc_table_using_like like orc_table; {code} Step 3: {code} show create table orc_table_using_like; {code} Result: {code} createtab_stmt CREATE TABLE `orc_table_using_like`( `time` string) 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 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' TBLPROPERTIES ( 'transient_lastDdlTime'='1437578939') {code} Issue: 'orc.compress'='SNAPPY' property is missing -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11340) Create ORC based table using like clause doesn't copy compression property
[ https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yongzhi Chen updated HIVE-11340: Attachment: HIVE-11340.2.patch Create ORC based table using like clause doesn't copy compression property -- Key: HIVE-11340 URL: https://issues.apache.org/jira/browse/HIVE-11340 Project: Hive Issue Type: Bug Components: File Formats Affects Versions: 0.14.0, 1.0.0, 1.2.0 Reporter: Gaurav Kohli Assignee: Yongzhi Chen Priority: Minor Attachments: HIVE-11340.1.patch, HIVE-11340.2.patch I found a issue in “create table like” clause, as it is not copying the table properties from ORC File format based table. Steps to reproduce: Step1 : {code} create table orc_table ( time string) stored as ORC tblproperties (orc.compress=SNAPPY); {code} Step 2: {code} create table orc_table_using_like like orc_table; {code} Step 3: {code} show create table orc_table_using_like; {code} Result: {code} createtab_stmt CREATE TABLE `orc_table_using_like`( `time` string) 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 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' TBLPROPERTIES ( 'transient_lastDdlTime'='1437578939') {code} Issue: 'orc.compress'='SNAPPY' property is missing -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11340) Create ORC based table using like clause doesn't copy compression property
[ https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yongzhi Chen updated HIVE-11340: Affects Version/s: 0.14.0 1.0.0 Create ORC based table using like clause doesn't copy compression property -- Key: HIVE-11340 URL: https://issues.apache.org/jira/browse/HIVE-11340 Project: Hive Issue Type: Bug Components: File Formats Affects Versions: 0.14.0, 1.0.0 Reporter: Gaurav Kohli Assignee: Yongzhi Chen Priority: Minor Attachments: HIVE-11340.1.patch I found a issue in “create table like” clause, as it is not copying the table properties from ORC File format based table. Steps to reproduce: Step1 : create table orc_table ( time string) stored as ORC tblproperties (orc.compress=SNAPPY); Step 2: create table orc_table_using_like like orc_table; Step 3: show create table orc_table_using_like; Result: createtab_stmt CREATE TABLE `orc_table_using_like`( `time` string) 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 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' TBLPROPERTIES ( 'transient_lastDdlTime'='1437578939') Issue: 'orc.compress'='SNAPPY' property is missing -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11340) Create ORC based table using like clause doesn't copy compression property
[ https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yongzhi Chen updated HIVE-11340: Affects Version/s: 1.2.0 Create ORC based table using like clause doesn't copy compression property -- Key: HIVE-11340 URL: https://issues.apache.org/jira/browse/HIVE-11340 Project: Hive Issue Type: Bug Components: File Formats Affects Versions: 0.14.0, 1.0.0, 1.2.0 Reporter: Gaurav Kohli Assignee: Yongzhi Chen Priority: Minor Attachments: HIVE-11340.1.patch I found a issue in “create table like” clause, as it is not copying the table properties from ORC File format based table. Steps to reproduce: Step1 : create table orc_table ( time string) stored as ORC tblproperties (orc.compress=SNAPPY); Step 2: create table orc_table_using_like like orc_table; Step 3: show create table orc_table_using_like; Result: createtab_stmt CREATE TABLE `orc_table_using_like`( `time` string) 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 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' TBLPROPERTIES ( 'transient_lastDdlTime'='1437578939') Issue: 'orc.compress'='SNAPPY' property is missing -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11340) Create ORC based table using like clause doesn't copy compression property
[ https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yongzhi Chen updated HIVE-11340: Attachment: HIVE-11340.1.patch Create ORC based table using like clause doesn't copy compression property -- Key: HIVE-11340 URL: https://issues.apache.org/jira/browse/HIVE-11340 Project: Hive Issue Type: Bug Components: File Formats Reporter: Gaurav Kohli Assignee: Yongzhi Chen Priority: Minor Attachments: HIVE-11340.1.patch I found a issue in “create table like” clause, as it is not copying the table properties from ORC File format based table. Steps to reproduce: Step1 : create table orc_table ( time string) stored as ORC tblproperties (orc.compress=SNAPPY); Step 2: create table orc_table_using_like like orc_table; Step 3: show create table orc_table_using_like; Result: createtab_stmt CREATE TABLE `orc_table_using_like`( `time` string) 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 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' TBLPROPERTIES ( 'transient_lastDdlTime'='1437578939') Issue: 'orc.compress'='SNAPPY' property is missing -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11340) Create ORC based table using like clause doesn't copy compression property
[ https://issues.apache.org/jira/browse/HIVE-11340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gaurav Kohli updated HIVE-11340: Priority: Minor (was: Major) Create ORC based table using like clause doesn't copy compression property -- Key: HIVE-11340 URL: https://issues.apache.org/jira/browse/HIVE-11340 Project: Hive Issue Type: Bug Components: File Formats Reporter: Gaurav Kohli Priority: Minor I found a issue in “create table like” clause, as it is not copying the table properties from ORC File format based table. Steps to reproduce: Step1 : create table orc_table ( time string) stored as ORC tblproperties (orc.compress=SNAPPY); Step 2: create table orc_table_using_like like orc_table; Step 3: show create table orc_table_using_like; Result: createtab_stmt CREATE TABLE `orc_table_using_like`( `time` string) 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 'hdfs://nameservice1/user/hive/warehouse/gkohli.db/orc_table_using_like' TBLPROPERTIES ( 'transient_lastDdlTime'='1437578939') Issue: 'orc.compress'='SNAPPY' property is missing -- This message was sent by Atlassian JIRA (v6.3.4#6332)