[jira] [Created] (IMPALA-11574) Impala won't change location of data files after using alter rename table

["Sultan .S (Jira)" <ji...@apache.org>]

Sultan .S created IMPALA-11574:
----------------------------------

             Summary: Impala won't change location of data files after using alter rename table
                 Key: IMPALA-11574
                 URL: https://issues.apache.org/jira/browse/IMPALA-11574
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 3.4.0
            Reporter: Sultan .S


Hi, I'm facing an issue where after using an alter to change the table name of a managed table the data files locations stays the same with old table name. I have a script that generate reports is running daily that uses hot swap for the past year now its not working as intended. we upgraded from impala 3.2 to 3.4 recently so I think the upgrade is related to this issue. were there some changes on the behavior of alter statement?

the problem caused by doing the following:

alter table db.main_table rename to db.main_table_flagged_del

alter table db.temp_table rename to db.main_table

drop table db.main_table_flagged_del

now after the second daily run of this script the flagged table will point to the same file directory as the main table so dropping flagged table will drop main table too.

this used to work with impala 3.2 so I wonder if there were backend changes that affected the behavior of alter statement.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)