[ https://issues.apache.org/jira/browse/IMPALA-9130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16968324#comment-16968324 ]
Gabor Kaszab commented on IMPALA-9130: -------------------------------------- [~csringhofer] > 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 > Priority: Major > Labels: impala-acid > > 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