hive 创建表时候报错，Error: Error while processing statement: FAILED: Execution Error, return code 1 from or

hive 创建表时候报错

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don’t support retries at the client level.) (state=08S01,code=1)

原因：在创建mysql时使用的字符集不对，需要修改hive数据库的字符集。

解决方法

alter database metastore（hive 数据仓） character set latin1;
mysql> use metastore;

mysql> alter table PARTITIONS convert to character set latin1;

Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table PARTITION_KEYS convert to character set latin1;

Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0

然后推出 重启hive 就成功了