[
https://issues.apache.org/jira/browse/HIVE-26158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17642475#comment-17642475
]
LiPenglin commented on HIVE-26158:
----------------------------------
Hi [~kgyrtkirk] and [~sanguines]! I didn't find any more information about
'TRANSLATED_TO_EXTERNAL', so I ask here.
I just want to make sure that location doesn't change when I rename a table, so
what I'm doing right now is:
1 set 'EXTERNAL'='TRUE'
2 set 'TRANSLATED_TO_EXTERNAL'='FALSE'
3 set 'external.table.purge'='false'
Does it make sense for me to do this? And how can I understand
'TRANSLATED_TO_EXTERNAL' better?
Regards!
> TRANSLATED_TO_EXTERNAL partition tables cannot query partition data after
> rename table
> --------------------------------------------------------------------------------------
>
> Key: HIVE-26158
> URL: https://issues.apache.org/jira/browse/HIVE-26158
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.0, 4.0.0-alpha-1, 4.0.0-alpha-2
> Reporter: tanghui
> Assignee: Zoltan Haindrich
> Priority: Major
> Labels: metastore_translator, pull-request-available
> Fix For: 4.0.0-alpha-2
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> After the patch is updated, the partition table location and hdfs data
> directory are displayed normally, but the partition location of the table in
> the SDS in the Hive metabase is still displayed as the location of the old
> table, resulting in no data in the query partition.
>
> in beeline:
> ------------------------------------------------------------
> set hive.create.as.external.legacy=true;
> CREATE TABLE part_test(
> c1 string
> ,c2 string
> )PARTITIONED BY (dat string)
> insert into part_test values ("11","th","20220101")
> insert into part_test values ("22","th","20220102")
> alter table part_test rename to part_test11;
> --this result is null.
> select * from part_test11 where dat="20220101";
> ||part_test.c1||part_test.c2||part_test.dat||
> | | | |
> ---------------------------------------------------------------------------------------------
> SDS in the Hive metabase:
> select SDS.LOCATION from TBLS,SDS where TBLS.TBL_NAME="part_test11" AND
> TBLS.TBL_ID=SDS.CD_ID;
> ---------------------------------------------------------------------------------------------------
> |*LOCATION*|
> |hdfs://nameservice1/warehouse/tablespace/external/hive/part_test11|
> |hdfs://nameservice1/warehouse/tablespace/external/hive/part_test/dat=20220101|
> |hdfs://nameservice1/warehouse/tablespace/external/hive/part_test/dat=20220102|
> ---------------------------------------------------------------------------------------------------
>
> We need to modify the partition location of the table in SDS to ensure that
> the query results are normal
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
