如果hive不能正常使用
1.进入apps/hive/conf
2.vi hive-site.xml-------------重新配置，全部删除内容重新复制，注意修改密码
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExsit=true;characterEncoding=utf8&useSSL=false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>111111</value>
</property>
<property>
<name>datanucleus.schema.autoCreateAll</name>
<value>true</value>
</property>
</configuration>
3.进入MySQL
mysql -u root -p
show databases;
drop database hive;
exit;
4.退出MySQL
schematool -initSchema -dbType mysql
mysql -u root -p
create database hive;
exit;
schematool -initSchema -dbType mysql
5.再次测试
hive
show tables;
