[ https://issues.apache.org/jira/browse/HIVE-26158?focusedWorklogId=768488&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-768488 ]
ASF GitHub Bot logged work on HIVE-26158: ----------------------------------------- Author: ASF GitHub Bot Created on: 10/May/22 13:09 Start Date: 10/May/22 13:09 Worklog Time Spent: 10m Work Description: kgyrtkirk commented on code in PR #3255: URL: https://github.com/apache/hive/pull/3255#discussion_r869212555 ########## ql/src/test/results/clientpositive/llap/translated_external_rename3.q.out: ########## @@ -95,15 +64,17 @@ Retention: 0 #### A masked pattern was here #### Table Type: EXTERNAL_TABLE Table Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\"}} + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} Review Comment: this is a partitioned table; and we (by mistake) have the `COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}` on the table object. stat values for for partitioned tables really matter at partition level Issue Time Tracking ------------------- Worklog Id: (was: 768488) Time Spent: 0.5h (was: 20m) > 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: 0.5h > 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)