[IMPALA-9130] Upgrade external non-ACID table to ACID from Impala

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.3.0
• Component/s: Catalog, Frontend
• Labels: impala-acid
• Epic Color: ghx-label-3
• Assignee: Csaba Ringhofer
• Reporter: Gabor Kaszab
• Created: 06/Nov/19 12:21
• Updated: 08/Nov/19 13:23

Description

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

alter table tbl set tblproperties ('transactional'='true', 'transactional_properties'='insert_only', 'EXTERNAL'='FALSE');

Step 2) fails in Impala but succeeds in Hive