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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
