[jira] [Updated] (HIVE-22009) CTLV with user specified location is not honoured
[ https://issues.apache.org/jira/browse/HIVE-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] mahesh kumar behera updated HIVE-22009: --- Resolution: Fixed Status: Resolved (was: Patch Available) [^HIVE-22009.3.patch] committed to master. Thanks [~nareshpr] for fixing the issue. > CTLV with user specified location is not honoured > -- > > Key: HIVE-22009 > URL: https://issues.apache.org/jira/browse/HIVE-22009 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0, 3.1.1 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Attachments: HIVE-22009-branch-3.1.patch, > HIVE-22009.1-branch-3.1.patch, HIVE-22009.1.patch, HIVE-22009.2.patch, > HIVE-22009.3.patch, HIVE-22009.patch > > > Steps to repro : > > {code:java} > CREATE TABLE emp_table (id int, name string, salary int); > insert into emp_table values(1,'a',2); > CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>1; > CREATE EXTERNAL TABLE emp_ext_table like emp_view LOCATION > '/tmp/emp_ext_table'; > show create table emp_ext_table;{code} > > {code:java} > ++ > | createtab_stmt | > ++ > | CREATE EXTERNAL TABLE `emp_ext_table`( | > | `id` int, | > | `name` string, | > | `salary` int) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.mapred.TextInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > | LOCATION | > | 'hdfs://nn:8020/warehouse/tablespace/external/hive/emp_ext_table' | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transient_lastDdlTime'='1563467962') | > ++{code} > Table Location is not '/tmp/emp_ext_table', instead location is set to > default warehouse path. > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22009) CTLV with user specified location is not honoured
[ https://issues.apache.org/jira/browse/HIVE-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-22009: -- Attachment: HIVE-22009.3.patch > CTLV with user specified location is not honoured > -- > > Key: HIVE-22009 > URL: https://issues.apache.org/jira/browse/HIVE-22009 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0, 3.1.1 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Attachments: HIVE-22009-branch-3.1.patch, > HIVE-22009.1-branch-3.1.patch, HIVE-22009.1.patch, HIVE-22009.2.patch, > HIVE-22009.3.patch, HIVE-22009.patch > > > Steps to repro : > > {code:java} > CREATE TABLE emp_table (id int, name string, salary int); > insert into emp_table values(1,'a',2); > CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>1; > CREATE EXTERNAL TABLE emp_ext_table like emp_view LOCATION > '/tmp/emp_ext_table'; > show create table emp_ext_table;{code} > > {code:java} > ++ > | createtab_stmt | > ++ > | CREATE EXTERNAL TABLE `emp_ext_table`( | > | `id` int, | > | `name` string, | > | `salary` int) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.mapred.TextInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > | LOCATION | > | 'hdfs://nn:8020/warehouse/tablespace/external/hive/emp_ext_table' | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transient_lastDdlTime'='1563467962') | > ++{code} > Table Location is not '/tmp/emp_ext_table', instead location is set to > default warehouse path. > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22009) CTLV with user specified location is not honoured
[ https://issues.apache.org/jira/browse/HIVE-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-22009: -- Attachment: HIVE-22009.1-branch-3.1.patch > CTLV with user specified location is not honoured > -- > > Key: HIVE-22009 > URL: https://issues.apache.org/jira/browse/HIVE-22009 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0, 3.1.1 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Attachments: HIVE-22009-branch-3.1.patch, > HIVE-22009.1-branch-3.1.patch, HIVE-22009.1.patch, HIVE-22009.2.patch, > HIVE-22009.patch > > > Steps to repro : > > {code:java} > CREATE TABLE emp_table (id int, name string, salary int); > insert into emp_table values(1,'a',2); > CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>1; > CREATE EXTERNAL TABLE emp_ext_table like emp_view LOCATION > '/tmp/emp_ext_table'; > show create table emp_ext_table;{code} > > {code:java} > ++ > | createtab_stmt | > ++ > | CREATE EXTERNAL TABLE `emp_ext_table`( | > | `id` int, | > | `name` string, | > | `salary` int) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.mapred.TextInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > | LOCATION | > | 'hdfs://nn:8020/warehouse/tablespace/external/hive/emp_ext_table' | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transient_lastDdlTime'='1563467962') | > ++{code} > Table Location is not '/tmp/emp_ext_table', instead location is set to > default warehouse path. > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22009) CTLV with user specified location is not honoured
[ https://issues.apache.org/jira/browse/HIVE-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-22009: -- Attachment: HIVE-22009.2.patch > CTLV with user specified location is not honoured > -- > > Key: HIVE-22009 > URL: https://issues.apache.org/jira/browse/HIVE-22009 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0, 3.1.1 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Attachments: HIVE-22009-branch-3.1.patch, HIVE-22009.1.patch, > HIVE-22009.2.patch, HIVE-22009.patch > > > Steps to repro : > > {code:java} > CREATE TABLE emp_table (id int, name string, salary int); > insert into emp_table values(1,'a',2); > CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>1; > CREATE EXTERNAL TABLE emp_ext_table like emp_view LOCATION > '/tmp/emp_ext_table'; > show create table emp_ext_table;{code} > > {code:java} > ++ > | createtab_stmt | > ++ > | CREATE EXTERNAL TABLE `emp_ext_table`( | > | `id` int, | > | `name` string, | > | `salary` int) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.mapred.TextInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > | LOCATION | > | 'hdfs://nn:8020/warehouse/tablespace/external/hive/emp_ext_table' | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transient_lastDdlTime'='1563467962') | > ++{code} > Table Location is not '/tmp/emp_ext_table', instead location is set to > default warehouse path. > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22009) CTLV with user specified location is not honoured
[ https://issues.apache.org/jira/browse/HIVE-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-22009: -- Attachment: HIVE-22009.1.patch > CTLV with user specified location is not honoured > -- > > Key: HIVE-22009 > URL: https://issues.apache.org/jira/browse/HIVE-22009 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0, 3.1.1 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Attachments: HIVE-22009-branch-3.1.patch, HIVE-22009.1.patch, > HIVE-22009.patch > > > Steps to repro : > > {code:java} > CREATE TABLE emp_table (id int, name string, salary int); > insert into emp_table values(1,'a',2); > CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>1; > CREATE EXTERNAL TABLE emp_ext_table like emp_view LOCATION > '/tmp/emp_ext_table'; > show create table emp_ext_table;{code} > > {code:java} > ++ > | createtab_stmt | > ++ > | CREATE EXTERNAL TABLE `emp_ext_table`( | > | `id` int, | > | `name` string, | > | `salary` int) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.mapred.TextInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > | LOCATION | > | 'hdfs://nn:8020/warehouse/tablespace/external/hive/emp_ext_table' | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transient_lastDdlTime'='1563467962') | > ++{code} > Table Location is not '/tmp/emp_ext_table', instead location is set to > default warehouse path. > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22009) CTLV with user specified location is not honoured
[ https://issues.apache.org/jira/browse/HIVE-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-22009: -- Affects Version/s: 3.1.1 > CTLV with user specified location is not honoured > -- > > Key: HIVE-22009 > URL: https://issues.apache.org/jira/browse/HIVE-22009 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0, 3.1.1 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Attachments: HIVE-22009-branch-3.1.patch, HIVE-22009.patch > > > Steps to repro : > > {code:java} > CREATE TABLE emp_table (id int, name string, salary int); > insert into emp_table values(1,'a',2); > CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>1; > CREATE EXTERNAL TABLE emp_ext_table like emp_view LOCATION > '/tmp/emp_ext_table'; > show create table emp_ext_table;{code} > > {code:java} > ++ > | createtab_stmt | > ++ > | CREATE EXTERNAL TABLE `emp_ext_table`( | > | `id` int, | > | `name` string, | > | `salary` int) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.mapred.TextInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > | LOCATION | > | 'hdfs://nn:8020/warehouse/tablespace/external/hive/emp_ext_table' | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transient_lastDdlTime'='1563467962') | > ++{code} > Table Location is not '/tmp/emp_ext_table', instead location is set to > default warehouse path. > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22009) CTLV with user specified location is not honoured
[ https://issues.apache.org/jira/browse/HIVE-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-22009: -- Attachment: HIVE-22009-branch-3.1.patch > CTLV with user specified location is not honoured > -- > > Key: HIVE-22009 > URL: https://issues.apache.org/jira/browse/HIVE-22009 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Attachments: HIVE-22009-branch-3.1.patch, HIVE-22009.patch > > > Steps to repro : > > {code:java} > CREATE TABLE emp_table (id int, name string, salary int); > insert into emp_table values(1,'a',2); > CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>1; > CREATE EXTERNAL TABLE emp_ext_table like emp_view LOCATION > '/tmp/emp_ext_table'; > show create table emp_ext_table;{code} > > {code:java} > ++ > | createtab_stmt | > ++ > | CREATE EXTERNAL TABLE `emp_ext_table`( | > | `id` int, | > | `name` string, | > | `salary` int) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.mapred.TextInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > | LOCATION | > | 'hdfs://nn:8020/warehouse/tablespace/external/hive/emp_ext_table' | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transient_lastDdlTime'='1563467962') | > ++{code} > Table Location is not '/tmp/emp_ext_table', instead location is set to > default warehouse path. > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22009) CTLV with user specified location is not honoured
[ https://issues.apache.org/jira/browse/HIVE-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naresh P R updated HIVE-22009: -- Attachment: HIVE-22009.patch Status: Patch Available (was: In Progress) > CTLV with user specified location is not honoured > -- > > Key: HIVE-22009 > URL: https://issues.apache.org/jira/browse/HIVE-22009 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Attachments: HIVE-22009.patch > > > Steps to repro : > > {code:java} > CREATE TABLE emp_table (id int, name string, salary int); > insert into emp_table values(1,'a',2); > CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>1; > CREATE EXTERNAL TABLE emp_ext_table like emp_view LOCATION > '/tmp/emp_ext_table'; > show create table emp_ext_table;{code} > > {code:java} > ++ > | createtab_stmt | > ++ > | CREATE EXTERNAL TABLE `emp_ext_table`( | > | `id` int, | > | `name` string, | > | `salary` int) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.mapred.TextInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > | LOCATION | > | 'hdfs://nn:8020/warehouse/tablespace/external/hive/emp_ext_table' | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transient_lastDdlTime'='1563467962') | > ++{code} > Table Location is not '/tmp/emp_ext_table', instead location is set to > default warehouse path. > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)