Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

kudu table not found after rename

kudu table not found after rename

Explorer

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. 

 

1 REPLY 1
Highlighted

Re: kudu table not found after rename

Expert Contributor

Hi @rams,

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

INVALIDATE METADATA;

?

Good luck.