Hive的常见错误

1.Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. org.apache.hadoop.hive.ql.metadata.HiveException: Unable to move source file:

解决：
退出hive，关闭namenode和datanode，删除namenode的tmp目录，再重新启动

2.多表查询有聚合函数执行mapreduce出错：

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce Jobs Launched:

待解决：
hive> set hive.exec.mode.local.auto=true;

3.启动hive后，第二次同样的select语句会出错。
FAILED: Hive Internal Error: java.lang.IllegalArgumentException(The value of property yarn.resourcemanager.zk-address must not be null) java.lang.IllegalArgumentException: The value of property yarn.resourcemanager.zk-address must not be null

解决：
把yarn-site.xml中的yarn.resourcemanager.zk-address改为hadoop.zk.address
并重启hadoop。

4.cannot recognize input near ‘date’ ‘string’ ‘,’ in column specification

解决：
date为保留关键字，当字段名与关键字重名时。要加上反引号

5.Error: Could not open client transport with JDBC Uri: jdbc:hive2://192.168.1.101:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: leon is not allowed to impersonate leon (state=08S01,code=0)

解决：
修改core-site.xml文件添加如下：

<property>
    <name>hadoop.proxyuser.leon.hosts</name>
    <value>*</value>
</property>
<property>
    <name>hadoop.proxyuser.leon.groups</name>
    <value>*</value>
</property>

注意：hadoop.proxyuser.leon.hosts和hadoop.proxyuser.leon.groups中的leon是我的用户名，你要改成你的用户名