Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'xxxxxx' doesn't exist

FAILED: Error in metadata: MetaException(message:Got exception: javax.jdo.JDODataStoreException Exception thrown obtaining schema column information from datastore)
org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got exception: javax.jdo.JDODataStoreException Exception thrown obtaining schema column information from datastore

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'xxxxxx' doesn't exist

Follow following to solve this problem.

Have you ever encountered this error while working in Hive, Lately i have encountered it and was stuck for long time to decide what i need to do.

What is did and it has solved the problem

i have just deleted the table name specified in the single quote which its saying that is not found.

this may happen when hive is trying to write in metadata and link breaks inbetween or something unexpected happens.

so just create backup of the table and delete it, or delete the table and create the table with the same name and same structure.