3.配置hive,现场演示配置结果和回答相关问题,并写出详细配置流程说明及相应的截图。
①在user目录下新建Hive、进入该目录:cd /usr/hive
②把hive-3.1.2解压到该目录下、运行命令:tar -zxvf apache-hive-3.1.2-bin.tar.gz
③解缩后,在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>/usr/hive/warehouse</value>
</property>
<property>
<name>hive.metastore.local</name>
<value>true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost/hive?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>123456</value>
</property>
</configuration>
④环境变量:vi /etc/profile
export HIVE_HOME=/usr/hive/apache-hive-3.1.2-bin
export PATH=$PATH:$HIVE_HOME/bin
⑤将mysql-connector-java-5.1.7-bin.jar复制到/usr/hive/apache-hive-3.1.2-bin/lib下面
⑥将guava-27.0.jre.jar复制到/usr/hive/apache-hive-3.1.2-bin/lib/下面,
删除原来的guava-19.0.jre.jar
⑦启动start-dfs.sh(要先启动hadoop)
⑧始化hive:schematool -dbType mysql -initSchema
⑨输入hive shell //进入hive
⑩输入show databases; //(显示Ok则成功)