Gabor Kaszab created IMPALA-9130: ------------------------------------ Summary: Upgrade external non-ACID table to ACID from Impala Key: IMPALA-9130 URL: https://issues.apache.org/jira/browse/IMPALA-9130 Project: IMPALA Issue Type: Bug Components: Catalog, Frontend Affects Versions: Impala 3.3.0 Reporter: Gabor Kaszab
If you have an external, non-ACID table and try to upgrade it to become an ACID table you get an error message that an external table is not allowed to be promoted to ACID. This is fine, however if in the very same step you set 'EXTERNAL' = 'FALSE' in table properties you still get the same error while Hive is able to execute it. Steps to repro: 1) Create a non-ACID external table. (or a single non-ACID table if you use Hive that contains HIVE-22158) 2) Upgrade the table {code:java} alter table tbl set tblproperties ('transactional'='true', 'transactional_properties'='insert_only', 'EXTERNAL'='FALSE'); {code} Step 2) fails in Impala but succeeds in Hive -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org