Hive命令行中 往分区表中插入数据报错,报错如下:
Loading data to table db_hive.dept_partition partition (month=202104) Failed with exception MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
Failed with exception MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
原因是hive元数据库的编码导致,打开hive的配置文件,找到hive存储元数据的数据库,然后进入MySQL ,修改编码为latin1 即可。