Kudu Table Issue

wert_1311 — Fri, 16 Sep 2022 14:44:27 GMT

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

Re: Kudu Table Issue

ChethanYM — Mon, 03 Jan 2022 12:37:56 GMT

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

question Kudu Table Issue in Support Questions

Kudu Table Issue

Re: Kudu Table Issue