spark-sql Table 'hive.PARTITIONS' doesn't exist

问题：Table 'hive.PARTITIONS' doesn't exist

19/08/21 10:56:15 ERROR ConnectionHandle: Database access problem. Killing off this connection and all remaining connections in the connection pool. SQL State = HY000
19/08/21 10:56:15 ERROR Datastore: Error thrown executing ALTER TABLE `PARTITIONS` ADD COLUMN `TBL_ID` BIGINT NULL : Table 'hive.PARTITIONS' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'hive.PARTITIONS' doesn't exist

解决方法：

删除mysql中hive表，通过命令初始化表

{HIVE_HOME}/bin/schematool -dbType mysql -initSchema