Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-9130

Upgrade external non-ACID table to ACID from Impala

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 3.3.0
    • Fix Version/s: None
    • Component/s: Catalog, Frontend
    • Labels:
    • Epic Color:
      ghx-label-3

      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

        Attachments

          Activity

            People

            • Assignee:
              csringhofer Csaba Ringhofer
              Reporter:
              gaborkaszab Gabor Kaszab
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: