错误一:jar包版本太低
解决方法:把hadoop文件下面\share\hadoop\common\lib\guava-27.0-jre.jar复制到hive的lib下面,删除老的,留下新的。
错误二:缺少驱动包
**解决方法:**将jdbc连接mysql的驱动包放到Hive的lib文件夹中mysql-connector-java-8.0.20.jar
错误三:root(用户)权限问题
解决办法:hadoop Core-site.xml文件中需要添加root(用户)权限
<property>
<name>hadoop.proxyuser.root.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.root.groups</name>
<value>*</value>
</property>
错误四:建表时错误
解决方法:当次登录有效
SET hive.support.concurrency = true;
SET hive.enforce.bucketing = true;
SET hive.exec.dynamic.partition.mode = nonstrict;
SET hive.txn.manager =org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
SET hive.compactor.initiator.on = true;
SET hive.compactor.worker.threads = 1;
(直接命令行设置当前生效)在hive的conf/hive-site.xml中配置是永久的
```powershell
<property>
<name>hive.compactor.initiator.on</name>
<value>true</value>
</property>
<property>
<name>hive.compactor.worker.threads</name>
<value>2</value>
</property>
<property>
<name>hive.support.concurrency</name>
<value>true</value>
</property>
<property>
<name>hive.enforce.bucketing</name>
<value>true</value>
</property>
<property>
<name>hive.exec.dynamic.partition.mode</name>
<value>nonstrict</value>
</property>
<property>
<name>hive.txn.manager</name>
<value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
</property>