Naresh P R created HIVE-22009: --------------------------------- Summary: 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
Steps to repro : {code:java} CREATE TABLE emp_table (id int, name string, salary int); insert into emp_table values(1,'aaaaa',20000); CREATE VIEW emp_view AS SELECT * FROM emp_table WHERE salary>10000; 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)