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
