Fang-Yu Rao created IMPALA-14875:
------------------------------------

             Summary: CREATE TABLE AS SELECT could fail a Preconditions check 
added in IMPALA-14507
                 Key: IMPALA-14875
                 URL: https://issues.apache.org/jira/browse/IMPALA-14875
             Project: IMPALA
          Issue Type: Bug
            Reporter: Fang-Yu Rao
            Assignee: Fang-Yu Rao


We found that CREATE TABLE AS SELECT could fail a Preconditions check added in 
IMPALA-14507. We could reproduce the issue by executing the following in 
impala-shell.

- create database test_db_100.
- create database config_ueeevc.
- CREATE EXTERNAL TABLE config_ueeevc.employee (emp_id INT, name STRING, 
start_date DATE, quit_date DATE, quit_flag STRING) STORED AS PARQUET 
TBLPROPERTIES ('OBJCAPABILITIES'='EXTREAD,EXTWRITE', 
'TRANSLATED_TO_EXTERNAL'='TRUE', 'external.table.purge'='TRUE').
- CREATE TABLE test_db_100.employee_A STORED AS PARQUET 
TBLPROPERTIES('transactional'='false') AS SELECT * FROM config_ueeevc.employee;
Query: CREATE TABLE test_db_100.employee_A STORED AS PARQUET 
TBLPROPERTIES('transactional'='false') AS SELECT * FROM config_ueeevc.employee.




--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to