我也有同样的问题。我试着按照参考链接中的建议去做，但是我仍然有同样的问题（即使我修复了运行脚本时看到的所有错误）。
最后，我在hive metastore脚本中查找了大的\u decimal \u high \u值，在下面的create语句中的每个hive-schema-0.1*.0.mysql.sql中都看到了它：

CREATE TABLE IF NOT EXISTS `TAB_COL_STATS` (
 `CS_ID` bigint(20) NOT NULL,
 `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `TBL_ID` bigint(20) NOT NULL,
 `LONG_LOW_VALUE` bigint(20),
 `LONG_HIGH_VALUE` bigint(20),
 `DOUBLE_HIGH_VALUE` double(53,4),
 `DOUBLE_LOW_VALUE` double(53,4),
 `BIG_DECIMAL_LOW_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin,
 `BIG_DECIMAL_HIGH_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin,
 `NUM_NULLS` bigint(20) NOT NULL,
 `NUM_DISTINCTS` bigint(20),
 `AVG_COL_LEN` double(53,4),
 `MAX_COL_LEN` bigint(20),
 `NUM_TRUES` bigint(20),
 `NUM_FALSES` bigint(20),
 `LAST_ANALYZED` bigint(20) NOT NULL,
  PRIMARY KEY (`CS_ID`),
  CONSTRAINT `TAB_COL_STATS_FK` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `PART_COL_STATS` (
 `CS_ID` bigint(20) NOT NULL,
 `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `PARTITION_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `PART_ID` bigint(20) NOT NULL,
 `LONG_LOW_VALUE` bigint(20),
 `LONG_HIGH_VALUE` bigint(20),
 `DOUBLE_HIGH_VALUE` double(53,4),
 `DOUBLE_LOW_VALUE` double(53,4),
 `BIG_DECIMAL_LOW_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin,
 `BIG_DECIMAL_HIGH_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin,
 `NUM_NULLS` bigint(20) NOT NULL,
 `NUM_DISTINCTS` bigint(20),
 `AVG_COL_LEN` double(53,4),
 `MAX_COL_LEN` bigint(20),
 `NUM_TRUES` bigint(20),
 `NUM_FALSES` bigint(20),
 `LAST_ANALYZED` bigint(20) NOT NULL,
  PRIMARY KEY (`CS_ID`),
  CONSTRAINT `PART_COL_STATS_FK` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

当我在配置单元元存储数据库中检查这些表时，得到了一些不同的结果：

mysql> desc TAB_COL_STATS;
+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| CS_ID             | bigint(20)   | NO   | PRI | NULL    |       |
| AVG_COL_LEN       | double       | YES  |     | NULL    |       |
| COLUMN_NAME       | varchar(128) | NO   |     | NULL    |       |
| COLUMN_TYPE       | varchar(128) | NO   |     | NULL    |       |
| DB_NAME           | varchar(128) | NO   |     | NULL    |       |
| DOUBLE_HIGH_VALUE | double       | YES  |     | NULL    |       |
| DOUBLE_LOW_VALUE  | double       | YES  |     | NULL    |       |
| LAST_ANALYZED     | bigint(20)   | NO   |     | NULL    |       |
| LONG_HIGH_VALUE   | bigint(20)   | YES  |     | NULL    |       |
| LONG_LOW_VALUE    | bigint(20)   | YES  |     | NULL    |       |
| MAX_COL_LEN       | bigint(20)   | YES  |     | NULL    |       |
| NUM_DISTINCTS     | bigint(20)   | YES  |     | NULL    |       |
| NUM_FALSES        | bigint(20)   | YES  |     | NULL    |       |
| NUM_NULLS         | bigint(20)   | NO   |     | NULL    |       |
| NUM_TRUES         | bigint(20)   | YES  |     | NULL    |       |
| TBL_ID            | bigint(20)   | YES  | MUL | NULL    |       |
| TABLE_NAME        | varchar(128) | NO   |     | NULL    |       |
+-------------------+--------------+------+-----+---------+-------+
17 rows in set (0.00 sec)

mysql> desc PART_COL_STATS;
+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| CS_ID             | bigint(20)   | NO   | PRI | NULL    |       |
| AVG_COL_LEN       | double       | YES  |     | NULL    |       |
| COLUMN_NAME       | varchar(128) | NO   |     | NULL    |       |
| COLUMN_TYPE       | varchar(128) | NO   |     | NULL    |       |
| DB_NAME           | varchar(128) | NO   |     | NULL    |       |
| DOUBLE_HIGH_VALUE | double       | YES  |     | NULL    |       |
| DOUBLE_LOW_VALUE  | double       | YES  |     | NULL    |       |
| LAST_ANALYZED     | bigint(20)   | NO   |     | NULL    |       |
| LONG_HIGH_VALUE   | bigint(20)   | YES  |     | NULL    |       |
| LONG_LOW_VALUE    | bigint(20)   | YES  |     | NULL    |       |
| MAX_COL_LEN       | bigint(20)   | YES  |     | NULL    |       |
| NUM_DISTINCTS     | bigint(20)   | YES  |     | NULL    |       |
| NUM_FALSES        | bigint(20)   | YES  |     | NULL    |       |
| NUM_NULLS         | bigint(20)   | NO   |     | NULL    |       |
| NUM_TRUES         | bigint(20)   | YES  |     | NULL    |       |
| PART_ID           | bigint(20)   | YES  | MUL | NULL    |       |
| PARTITION_NAME    | varchar(767) | NO   |     | NULL    |       |
| TABLE_NAME        | varchar(128) | NO   |     | NULL    |       |
+-------------------+--------------+------+-----+---------+-------+

因此，由于这两个表都是空的，所以我只是删除并再次创建了它们，使用hive-schema-0.13.0.mysql.sql文件中列出的create语句。
这样做之后，我可以再次放下Hive桌。