[HIVE-24193] Select query on renamed hive acid table does not produce any output

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Rajkumar Singh
• Reporter: Rajkumar Singh
• Created: 23/Sep/20 18:01
• Updated: 17/Nov/22 08:48
• Resolved: 05/Oct/20 08:03

Description

During onRename, HMS update COMPLETED_TXN_COMPONENTS which fail with CTC_DATABASE column does not exist, upon investigation I found that enclosing quotes are missing for columns thats db query fail with this exception

Steps to repro:
1. create table test(id int);
2. insert into table test values(1);
3. alter table test rename to test1;
3. select * from test1 produce no output

Issue Links

• links to: GitHub Pull Request #1520