1.问题描述

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

2.解决方法

删除mysql 中的hive数据库

执行${HIVE_HOME}/bin/schematool -dbType mysql -initSchema 命令