Hive的安装
（确保安装mysql和hadoop）
- 上传hive至opt hive-1.1.0-cdh5.14.2.tar.gz
- Soft下创建文件夹
- 解压hive
tar -zxf hive-1.1.0-cdh5.14.2.tar.gz -C /opt/soft/hive110 --strip-components 1
- 切换至conf文件下
cd hive110/conf
- 创建并编辑文件
touch hive-site.xml
vim hive-site.xml
hive.metastore.warehouse.dir
/hive110/warehouse
hive.metastore.local
false
javax.jdo.option.ConnectionURL
jdbc:mysql://192.168.100.162:3306/hive?useSSL=false&createDatabaseIfNotExist=true
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
javax.jdo.option.ConnectionUserName
root
javax.jdo.option.ConnectionPassword
okok
hive.server2.authentication
NONE
hive.server2.thrift.client.user
root
hive.server2.thrift.client.password
root
- 找本地maven下jar包mysql ，上传至/opt/soft/hive110/lib
- 配置hive环境
vim /etc/profile
#hive environment
export HIVE_HOME=/opt/soft/hive110
export PATH=$PATH:$HIVE_HOME/bin
source /etc/profile
- 启动hadoop
start-all.sh
- 初始化hive
schematool -dbType mysql -initSchema
-
工具验证hive是否安装成功
①[root@hadoop101 conf]# hive
②show database;
- Beeline 连接
beeline -u jdbc:hive2://192.168.56.160:10000/mydemo
- Zeppelin 连接
- 上传zeppelin-0.8.1-bin-all.tgz
- 创建本地文件夹：mkdir zeppelin081
- 解压：tar -zxf zeppelin-0.8.1-bin-all.tgz -C /opt/soft/zeppelin081 --strip-components 1
- 切换至conf文件夹：cd conf/
- 修改文件名：cp zeppelin-site.xml.template zeppelin-site.xml
- 进入编辑：vim zeppelin-site.xml
添加内容
zeppelin.helium.registry
helium
- 改名：cp zeppelin-env.sh.template zeppelin-env.sh
- 编辑：vim zeppelin-env.sh
export JAVA_HOME=/opt/soft/jdk180
export HADOOP_CONF_DIR=/opt/soft/hadoop260/etc/hadoop
- 添加 /etc/profile文件
#zeppelin environment
export ZEPPELIN_HOME=/opt/soft/zeppelin081
export PATH=$PATH:$ZEPPELIN_HOME/bin
- 重启配置文件：cource /etc/profile
- 拷贝hive的hive-site.xml 文件到zeppelin081
cp /opt/soft/hive110/conf/hive-site.xml /opt/soft/zeppelin081/conf/ - 拷贝 hadoop-common-2.6.0-cdh5.14.2.jar 到 zeppelin081
cp /opt/soft/hadoop260/share/hadoop/common/hadoop-common-2.6.0-cdh5.14.2.jar /opt/soft/zeppelin081/interpreter/jdbc/
- 拷贝 hive-jdbc-1.1.0-cdh5.14.2-standalone.jar 到zeppelin081
cp /opt/soft/hive110/lib/hive-jdbc-1.1.0-cdh5.14.2-standalone.jar /opt/soft/zeppelin081/interpreter/jdbc/
- 启动 zeppelin
zeppelin-daemon.sh start
- 网页开启
192.168.56.160:8080
- 在web界面配置集成hive
（1）右上角anonymous --> interpreter --> +Create新建一个叫做hive的集成环境
其他连接软件的使用：https://blog.csdn.net/qq_28266137/article/details/115049127
