Hive安装

1. 下载：wget http://archive.cloudera.com/cdh5/cdh/5/hive-1.1.0-cdh5.7.0.tar.gz
2. 解压：tar -zxvf hive-1.1.0-cdh5.7.0.tar.gz -C ../app/
3. 配置：

系统环境变量(~/.bahs_profile)

export HIVE_HOME=/home/hadoop/app/hive-1.1.0-cdh5.7.0

export PATH=$HIVE_HOME/bin:$PATH

 

cd /home/yliang/app/hive-1.1.0-cdh5.7.0/conf

cp hive-env.sh.template hive-env.sh

vi hive-env.sh

新增配置：HADOOP_HOME=/home/yliang/app/hadoop-2.6.0-cdh5.7.0

 

vi hive-site.xml

<?xml version="1.0"?>

<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>

 

    <property>

   <name>javax.jdo.option.ConnectionURL</name>

     <value>jdbc:mysql://localhost:3306/sparksql?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>root</value>

    </property>

 

</configuration>

 

4、下载mysql连接报mysql-connector-java-5.1.27.jar，放到hive安装路径lib文件夹下

 

5、启动hive

启动mysql、hdfs、yarn

cd /home/yliang/app/hive-1.1.0-cdh5.7.0/bin

./hive