Reply
New Contributor
Posts: 1
Registered: ‎04-12-2018

kudu table not found after rename

[ Edited ]

I used 

 

ALTER TABLE old_name RENAME new_name;

 

ALTER TABLE new_name SET TBLPROPERTIES('kudu.table_name', 'new_name')

 

to rename an existing table. Things seem to work fine. I was able to run queries on the new_name table

 

However, my Kafka connector was unable to see the new table. Error said cant find impala::myDB.new_name

 

via Impala command line issued 

 

describe extended new_name;

 

The kudu.table_name property displayed as 'new_name' without any of the impala or db qualifiers. Assumed that was the issue and ran 

 

ALTER TABLE new_name SET TBLPROPERTIES('kudu.table_name', 'impala::myDB.new_name')

 

The above timed out and now I am unable to run queries against new_name

 

Show tables lists the table but describe or any other query says table not found. 

 

Expert Contributor
Posts: 87
Registered: ‎07-17-2017

Re: kudu table not found after rename

Hi @rams,

Which release of CDH do you use?
Did you try to run:

INVALIDATE METADATA;

?

Good luck.

Announcements