![e2e9770889338cfe7f9de22634c15c5d.png](https://i-blog.csdnimg.cn/blog_migrate/91058bd4eac261248c6bf210444e4162.jpeg)
1.准备jar包
apache-hive-2.3.4-bin.tar.gz mysql-connector-java-5.1.32-bin.jar
2.解压
tar -zxvf apache-hive-2.3.4-bin.tar.gz -C /opt/
3.改名方便后面配置文件写
(在opt目录下)mv apache-hive-2.3.4-bin.tar.gz hive-2.3.4
4.配置环境变量
vi /etc/profile
export HIVE_HOME=/opt/hive-2.3.4
export PATH=$PATH:$HIVE_HOME/bin
. /etc/profile
5.修改配置文件
(在conf目录)
mv hive-default.xml.temple hive-site.xml
vi hive-site.xml
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive_remote/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://node1/hive_remote?createDatabaseIfNotExist=true</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>123</value>
</property>
</configuration>
:wq(保存退出)
6.把mysql jar包放到hive的lib中
cp mysql-connector-java-5.1.32-bin.jar /opt/hive-2.3.4/lib/
7.初始化元数据
(在根目录下)schematool --dbType derby -initSchema
然后运行hive命令就可以进入命令行进行语句操作