hive配置安装mysql_Hive2.1.0安装及配置mysql

安装Hive2.1.0

1.准备工作：安装JDK、Hadoop

2.下载并解压Hive

wget https://mirrors.tuna.tsinghua.edu.cn/apache/hive/hive-2.1.0/apache-hive-2.1.0-bin.tar.gz

cp apache-hive-2.1.0-bin.tar.gz /usr/local

tar -zxvf apache-hive-2.1.0-bin.tar.gz

mv apache-hive-2.1.0-bin.tar.gz hive

sudo chown -R hadoop:hadoop hive

3. 设置Hive环境变量

vi ~/.bashrc

export HIVE_HOME=/usr/local/hive

export PATH=$JAVA_HOME/bin:$PATH:$HADOOP_HOME/bin:$HIVE_HOME/bin

source ~/.bashrc

4. 修改Hive的配置文件

cp conf/hive-default.xml.template hive-site.xml

cp conf/hive-log4j.properties.template hive-log4j.properties

cp conf/hive-exec-log4j.properties.template hive-exec-log4j.properties

5.  修改 hive-site.xml

javax.jdo.option.ConnectionURL

jdbc:mysql://192.168.53.94:3306/hive_db?createDatabaseIfNotExist=true&useUnicode=true&am