hadoop上安装hive

安装mysql

https://www.jianshu.com/p/9b0be59aefd9
一步步照着做就行了

安装hive

1. 下载hive
   https://www-eu.apache.org/dist/hive/
2. 上传安装包到服务器的 /usr/local/目录下
3. 安装

[root@master local]   tar zxvf apache-hive-1.2.2-bin.tar.gz
[root@master local]   mv apache-hive-1.2.2-bin hive
[root@master local]    cd hive
[root@master hive]    touch hive/conf/hive-site.xml
[root@master hive]    vim hive/conf/hive-site.xml
在该文件添加如下内容：
<configuration>
    <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true&amp;useSSL=false</value>
        <description>JDBC connect string for a JDBC metastore</description>    
    </property>   
    <property> 
        <name>javax.jdo.option.ConnectionDriverName</name> 
        <value>com.mysql.jdbc.Driver</value> 
        <description>Driver class name for a JDBC metastore</description>     
    </property>               

    <property> 
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>root</value>
        <description>username to use against metastore database</description>
    </property>
    <property>  
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>123456</value>
        <description>password to use against metastore database</description>  
    </property>          
</configuration>

3. 下载mysql的连接包同时上传到 /usr/local/hive/lib/ 目录下
   我使用的版本为： mysql-connector-5.1.46.jar
4. 配置环境变量

[root@master hive]    vim ~/.bashrc
在文件最末尾添加：
export JAVA_HOME=/usr/local/src/jdk1.8.0_172
export CLASSPATH=.:$CLASSPATH:$JAVA_HOME/lib
export HADOOP_HOME=/usr/local/src/hadoop-2.6.5
export HADOOP_CONF_DIR=$HADOOP_HOME/etc/hadoop
export HIVE_HOME=/usr/local/hive
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$MYSQL_HOME/bin:$HIVE_HOME/bin

[root@master hive]    source ~/.bashrc

5. 初始化hive

[root@master hive]  schematool -dbType mysql -initSchema

6. 验证hive

[root@master hive]  hive
hive> show tables;
OK
Time taken: 2.794 seconds
hive> show databases;
OK
default
Time taken: 0.273 seconds, Fetched: 1 row(s)
hive> create TABLE u_info
    > (
    >     usrid STRING,
    >     age STRING,
    >     sex STRING
    > )
    > ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
    >     LINES TERMINATED BY '\n';
OK
Time taken: 3.37 seconds
hive> desc u_info;
OK
usrid                   string                                      
age                     string                                      
sex                     string                                      
Time taken: 1.126 seconds, Fetched: 3 row(s)