hive安装部署
前置条件
已经安装了hadoop 详见 双节点hadoop集群安装部署
下载
我选择了 apache-hive-2.3.9-bin.tar.gz 版本
mkdir -p /home/hive cd /home/hive wget https://ftp.tsukuba.wide.ad.jp/software/apache/hive/hive-2.3.9/apache-hive-2.3.9-bin.tar.gz tar -zxvf apache-hive-2.3.9-bin.tar.gz cd apache-hive-2.3.9
配置
配置环境变量
echo 'export HIVE_HOME=/home/hive/apache-hive-2.3.9' >> /etc/profile
echo 'export PATH=$PATH:$HIVE_HOME/bin' >> /etc/profile
source /etc/profile
配置hadoop
hadoop fs -mkdir /tmp
hadoop fs -mkdir user/hive/warehouse
hadoop fs -chmod g+w /tmp
hadoop fs -chmod g+w /user/hive/warehouse
配置mysql
下载jdbc驱动 mysql-connector-java-5.1.46.jar
放到 $HIVE_HOME/lib/ 目录下
vim $HIVE_HOME/conf/hive-site.xml <configuration> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://{ip}/{dbname}?createDatabaseIfNotExist=true&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>{username}</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>{password}</value> </property> </configuration>
初始化
$HIVE_HOME/bin/schematool -dbType mysql -initSchema
启动hive
hive
#如果出现异常并且异常信息是 Name node is in safe mode. 请执行命令: hadoop dfsadmin -safemode leave