Hive报错和解决办法

firstBadLink错误

报错：
Caused by: java.io.IOException: Bad connect ack with firstBadLink as 192.168.2.24:50010
解决方法：动态分区数太多，需要提高文件句柄数，
root账户下vi /etc/security/limits.conf
End of file
hadoop - nofile 65536

metastore报错

报错：
Binary logging not possible. Message: Transaction level ‘READ-COMMITTED’ in InnoDB is not safe for binlog mode ‘STATEMENT’
解决方法
因为，READ-COMMITTED需要把bin-log以mixed方式来记录，用以下命令来修改：
set global binlog_format=‘MIXED’;

TTransportException

报错：
hive (default)> use test;
FAILED: Error in metadata: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask