Hive部署

1、下载hive-1.1.0-cdh5.15.1.tar.gz到本地

（1）依据hadoop版本5.15.1，从而下载Hive的版本5.15.1

 [hadoop@hadoop000 software]$ ls

 hadoop-2.6.0-cdh5.15.1.tar.gz

（2）下载地址：https://archive.cloudera.com/p/cdh5/cdh5

压缩包保存的路径：D:\Hadoop

（3）从本地上传至服务器

输入：scp hive-1.1.0-cdh5.15.1.tar.gz [email protected]:~/software/

然后输入密码：123456

（4）解压

在进入到software/：cd software/

查看文件内存大小：ll -lh

解压到服务器~/app/：

[hadoop@hadoop000 software]$ tar -zxvf hive-1.1.0-cdh5.15.1.tar.gz -C ~/app/      

在app文件中显示hive-1.1.0-cdh5.15.1，即ok

2、将解压后的路径/home/hadoop/app/hive-1.1.0-cdh5.15.1拷贝到系统变量里

[hadoop@hadoop000 app]$ cd hive-1.1.0-cdh5.15.1
[hadoop@hadoop000 hive-1.1.0-cdh5.15.1]$ ls
auxlib  conf  docs      hcatalog  LICENSE  README.txt         scripts
bin     data  examples  lib       NOTICE   RELEASE_NOTES.txt
[hadoop@hadoop000 hive-1.1.0-cdh5.15.1]$ pwd
/home/hadoop/app/hive-1.1.0-cdh5.15.1
[hadoop@hadoop000 hive-1.1.0-cdh5.15.1]$ vi ~/.bash_profile      

在vi ~/.bash_profile中，添加导出Hive的路径

export HIVE_HOME=/home/hadoop/app/hive-1.1.0-cdh5.15.1
export PATH=$HIVE_HOME/bin:$PATH      

生效

[hadoop@hadoop000 hive-1.1.0-cdh5.15.1]$ source ~/.bash_profile      

查看Hive的home

[hadoop@hadoop000 hive-1.1.0-cdh5.15.1]$ echo $HIVE_HOME
/home/hadoop/app/hive-1.1.0-cdh5.15.1      

 查看目录结构

[hadoop@hadoop000 hive-1.1.0-cdh5.15.1]$ ll
total 416
drwxr-xr-x 2 hadoop hadoop     48 Aug  9  2018 auxlib
drwxr-xr-x 3 hadoop hadoop    119 Aug  9  2018 bin  //存放脚本
drwxr-xr-x 2 hadoop hadoop    219 Nov 25  2018 conf //配置信息
drwxr-xr-x 3 hadoop hadoop     21 Aug  9  2018 data  //sql脚本数据信息
drwxr-xr-x 6 hadoop hadoop    110 Aug  9  2018 docs
drwxr-xr-x 4 hadoop hadoop     34 Aug  9  2018 examples
drwxr-xr-x 7 hadoop hadoop     68 Aug  9  2018 hcatalog
drwxr-xr-x 4 hadoop hadoop   8192 Nov 25  2018 lib  //hive所依赖的jar包
-rw-r--r-- 1 hadoop hadoop  24754 Aug  9  2018 LICENSE
-rw-r--r-- 1 hadoop hadoop    397 Aug  9  2018 NOTICE
-rw-r--r-- 1 hadoop hadoop   4048 Aug  9  2018 README.txt
-rw-r--r-- 1 hadoop hadoop 376416 Aug  9  2018 RELEASE_NOTES.txt
drwxr-xr-x 3 hadoop hadoop     23 Aug  9  2018 scripts      

3、开始配置，添加HIVE_HOME到系统环境变量

[hadoop@hadoop000 hive-1.1.0-cdh5.15.1]$ cd conf/      

（1）修改hive-env.sh

[hadoop@hadoop000 conf]$ ls
beeline-log4j.properties.template  hive-exec-log4j.properties.template  ivysettings.xml
hive-log4j.properties.template
hive-env.sh.template               hive-site.xml      

[hadoop@hadoop000 conf]$ cp hive-env.sh.template hive-env.sh      

 [hadoop@hadoop000 ~]$ echo $HADOOP_HOME

 /home/hadoop/app/hadoop-2.6.0-cdh5.15.1

 [hadoop@hadoop000 conf]$ vi hive-env.sh

# Set HADOOP_HOME to point to a specific hadoop install directory
# HADOOP_HOME=${bin}/../../hadoop

HADOOP_HOME=/home/hadoop/app/hadoop-2.6.0-cdh5.15.1      

（2）修改hive-site.xml

在这里面配置mysql的信息

[hadoop@hadoop000 conf]$ 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://hadoop000:3306/hadoop_hive?createDatabaseIfNotExist=true</value>
</property>
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>
<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://hadoop000:3306/hadoop_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>root</value>
</property>
</configuration>      

4、MySQL驱动jar包

使用MySQL，则需要驱动jar包

[hadoop@hadoop000 software]$ ls
mysql-connector-java-5.1.27-bin.jar      

将驱动拷贝到以下路径：/home/hadoop/app/hive-1.1.0-cdh5.15.1/lib

[hadoop@hadoop000 software]$ cp mysql-connector-java-5.1.27-bin.jar /home/hadoop/app/hive-1.1.0-cdh5.15.1/lib
      

　[hadoop@hadoop000 lib]$ ll mysql-connector-java-5.1.27-bin.jar

  -rw-r--r-- 1 hadoop hadoop 872303 Nov 25 2018 mysql-connector-java-5.1.27-bin.jar