将MySQL的连接依赖包放到hive中的lib目录下mysql-connector-java-5.1.32-bin.jar
将hadoop文件下/share/hadoop/yarn/lib中的jline-2.12.jar包和hive中lib下的jline-2.12.jar版本一致
分发一份到客户端节点
修改环境变量
创建服务器配置 文件 hive/conf/hive-site.xml:
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.10.14:3306/hive?createDatabaseIfNotExist=true</value>
</property>
#192.168.10.14为mysql地址
<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>
#root为mysql用户名
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123</value>
</property>
</configuration>
#123为mysql密码客户端的hive-site.xml文件:
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>hive.metastore.local</name>
<value>false</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://192.168.10.11:9083</value>
</property>
#192.168.10.11为hive服务端地址,默认端口为9083
</configuration>
启动hive服务端程序(需要先启动hadoop集群)
hive --service metastore
客户端直接使用hive命令即可