Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Fo

hive建表失败：

hive> create table t(name string,age int)
    > row format delimited fields terminated by ',';

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.)

解决办法：

进入mysql修改hive数据库的编码：

mysql> alter database hive character set latin1;

Query OK, 1 row affected (0.00 sec)

之后重建表成功

hive> create table t(name string,age int)
    > row format delimited fields terminated by ',';
OK
Time taken: 0.337 seconds
hive> show tables;
OK
t

Time taken: 0.049 seconds, Fetched: 1 row(s)

参考johnmay--Blog