You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ayush Saxena (Jira)" <ji...@apache.org> on 2023/01/18 07:29:00 UTC
[jira] [Commented] (HIVE-26959) CREATE TABLE with external.table.purge=false is ignored
[ https://issues.apache.org/jira/browse/HIVE-26959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17678103#comment-17678103 ]
Ayush Saxena commented on HIVE-26959:
-------------------------------------
Should have given create external table, rather tham just create table, without external keyword it will consider like you are trying for managed table, which will get translated to external table with purge true, which takes precedence over the one specificied in the table properties
> CREATE TABLE with external.table.purge=false is ignored
> -------------------------------------------------------
>
> Key: HIVE-26959
> URL: https://issues.apache.org/jira/browse/HIVE-26959
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.0-alpha-2
> Reporter: Li Penglin
> Priority: Major
>
> We set the default external.table.purge=true in https://issues.apache.org/jira/browse/HIVE-26064, but this property is still true when I set it to false.
>
> {code:java}
> select version();
> +----------------------------------------------------+
> | _c0 |
> +----------------------------------------------------+
> | 4.0.0-alpha-2 r36f5d91acb0fac00a5d46049bd45b744fe9aaab6 |
> 0: jdbc:hive2://localhost:11050> create table test_parq_hive (i int)
> . . . . . . . . . . . . . . . .> stored as parquet
> . . . . . . . . . . . . . . . .> tblproperties ('external.table.purge'='false');
> INFO : Compiling command(queryId=root_20230118111342_c60c0f5f-3e2f-45af-a7ab-13f099b7ead9): create table test_parq_hive (i int)
> stored as parquet
> tblproperties ('external.table.purge'='false')
> INFO : Semantic Analysis Completed (retrial = false)
> 0: jdbc:hive2://localhost:11050> describe formatted test_parq_hive;
> | | bucketing_version | 2 |
> | | external.table.purge | TRUE |
> | | transient_lastDdlTime | 1674011622 |
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)