[
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
