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