11-02-2015 04:01 AM
I see below error,
Could some one please help.
[dayrhedpru007.enterprisenet.org:21000] > select * from events_census limit 2;
Query: select * from events_census limit 2
ERROR: AnalysisException: Failed to load metadata for table: agf_dev.events_census
CAUSED BY: TableLoadingException: Unrecognized table type for table: agf_dev.events_census
11-03-2015 01:33 PM
You may be querying an unsupported table type, or the table metadata may be corrupted. We don't support all of Hive's table storage options.
If you run "show create table table_name" in Impala, or Hive if it fails in Impala, this will have more information about how the table is stored.
11-04-2015 12:18 AM
Many thanks for the reply. I am trying to find out root cause of this issue and issue is present only for one table but for other tables.
I am trying to find out to check if the metadata is corrupted or not.
How to check the same, your help is valuable.
11-04-2015 07:13 AM
It would be useful to know how the table was created. Was it created in Impala or another tool like Hive? If you created it in Hive, can you query it from hive?
11-05-2015 10:35 PM
Here is the output from hive/impala. Table is created in hive.
11-05-2015 10:46 PM
11-06-2015 09:06 AM