[ 
https://issues.apache.org/jira/browse/HIVE-26158?focusedWorklogId=768490&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-768490
 ]

ASF GitHub Bot logged work on HIVE-26158:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 10/May/22 13:10
            Start Date: 10/May/22 13:10
    Worklog Time Spent: 10m 
      Work Description: kgyrtkirk commented on code in PR #3255:
URL: https://github.com/apache/hive/pull/3255#discussion_r869215853


##########
ql/src/test/queries/clientpositive/translated_external_rename3.q:
##########
@@ -1,26 +1,25 @@
 set 
metastore.metadata.transformer.class=org.apache.hadoop.hive.metastore.MetastoreDefaultTransformer;
-set metastore.metadata.transformer.location.mode=force;

Review Comment:
   this was a mistake - I've clobbered this existing test too much; I've moved 
the new testcase into a new qfile.
   
   the location mode shouldn't matter for this test at all.





Issue Time Tracking
-------------------

    Worklog Id:     (was: 768490)
    Time Spent: 40m  (was: 0.5h)

> 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
>          Time Spent: 40m
>  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.7#820007)

Reply via email to