[jira] [Created] (IMPALA-13544) Expose TRANSLATED_TO_EXTERNAL property

["Gabor Kaszab (Jira)" <ji...@apache.org>]

Gabor Kaszab created IMPALA-13544:
-------------------------------------

             Summary: Expose TRANSLATED_TO_EXTERNAL property
                 Key: IMPALA-13544
                 URL: https://issues.apache.org/jira/browse/IMPALA-13544
             Project: IMPALA
          Issue Type: Improvement
          Components: Frontend
            Reporter: Gabor Kaszab


When Impala creates a managed table (without the external keyword) HMS will in fact create it as an external table anyway. When doing this under the hood conversion HMS sets the TRANSLATED_TO_EXTERNAL table property to true so that it can later on see if the table was explicitly created as external or not.

There is some logic that depends on the value of this field. For instance when renaming a table the folder of the could be also renamed based on how this table property is set.

When we issue a SHOW CREATE TABLE in impala this property is not visible in the output, as a result the output is the same regardless of the table was created as external or was converted to by HMS under the hood. Hive on the other hand shows this property in the output of SHOW CREATE TABLE.

My proposal is to add an improvement to Impala to show the TRANSLATED_TO_EXTERNAL property in the SHOW CREATE TABLE output. Otherwise, creating a table based on the SHOW CREATE TABLE output wouldn't be the same table, for instance when being renamed it could have a different behaviour when it comes to renaming the folder.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)