Skip to main content
wert_1311
Gold ⭐️
December 2, 2021
Solved

Kudu Table Issue

Hi,
I need some assistance with Kudu, We have 2 tables that are consuming more space on our Kudu Cluster however, we could not find these tables under the database. Would need some guidance/assistance on a way to check where these tables are located under which Db.

 

I can see the table in Kudu Web UI, however, when I try to query it via Impala I get the error:

 

[My_server:21000] kwid> show create table ALARMS_COUNTERS_2021_11_01;
Query: show create table ALARMS_COUNTERS_2021_11_01
ERROR: AnalysisException: Table does not exist: kwid.ALARMS_COUNTERS_2021_11_01

 

If I run “show tables” against the DB I get a list of all the tables, but this table is not in the list.

 

Thanks 

Wert

ChethanYM
ChethanYMAnswer
Gold ⭐️
January 3, 2022

Hi,

 

-> Have you tried the same query via Hive? Does it work?

-> How this table got created via hive or impala?

-> Try "invalidate metadata" in impala and retry

 

Regards,

Chethan YM

1 reply

ChethanYM
Gold ⭐️
ChethanYMAnswer
Gold ⭐️
January 3, 2022

Hi,

 

-> Have you tried the same query via Hive? Does it work?

-> How this table got created via hive or impala?

-> Try "invalidate metadata" in impala and retry

 

Regards,

Chethan YM

Translate