You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2024/12/09 18:39:00 UTC
[jira] [Commented] (IMPALA-13544) Expose TRANSLATED_TO_EXTERNAL property in SHOW CREATE TABLE
[ https://issues.apache.org/jira/browse/IMPALA-13544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17904248#comment-17904248 ]
ASF subversion and git services commented on IMPALA-13544:
----------------------------------------------------------
Commit 79eb48e9f63a87bf240080949c11e90b47c1367f in impala's branch refs/heads/master from Mihaly Szjatinya
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=79eb48e9f ]
IMPALA-13544: Expose TRANSLATED_TO_EXTERNAL property in SHOW CREATE
TABLE
Makes TRANSLATED_TO_EXTERNAL property from HMS exposed as a result of
SHOW CREATE TABLE request by removing it from ToSqlUtils' hidden
properties list.
Change-Id: I0048a041d50f5e520f5286a613a428393397bc4d
Reviewed-on: http://gerrit.cloudera.org:8080/22108
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> Expose TRANSLATED_TO_EXTERNAL property in SHOW CREATE TABLE
> -----------------------------------------------------------
>
> Key: IMPALA-13544
> URL: https://issues.apache.org/jira/browse/IMPALA-13544
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Reporter: Gabor Kaszab
> Assignee: Mihaly Szjatinya
> Priority: Major
> Labels: ramp-up
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org