We get this error message when starting hive metastore service with MySQL as local metastore. This error message is received when MySQL database is not created properly or it is not updated with the tables correctly while configuring it as hive metastore database.
While configuring hive metastore with MySQL, some times, metastore database (say hive_metastore_db) will not be created properly with all of the required schema tables. Then we start the hive thrift server, it may run successfully with empty metastore database but hive metastore service cannot be started successfully. We will usually end up in below error message.