Hive从零起步

1.上传hive安装包


2.解压
    将Mysql的jdbc驱动包放到hive的lib下

3、配置

    3.1 安装MySql

       查询以前安装的mysql相关包
        rpm -qa | grep mysql
        暴力删除这个包
        rpm -e mysql-libs-5.1.66-2.el6_3.i686 --nodeps

        rpm -ivh MySQL-server-5.1.73-1.glibc23.i386.rpm 
        rpm -ivh MySQL-client-5.1.73-1.glibc23.i386.rpm

        执行命令设置mysql
        /usr/bin/mysql_secure_installation

    设置权限
        GRANT ALL PRIVILEGES ON hive.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
        FLUSH PRIVILEGES

     执行以下命令，以防报错：（若不执行会出现com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

）

      alter database hive character set latin1;

     3.2 环境变量配置


       vim hive-env.sh

       export HADOOP_HOME=/usr/local/hadoop-2.6.0
        export HIVE_HOME=/usr/local/hive-1.2.1
        export HIVE_CONF_DIR=/usr/local/hive-1.2.1/conf

       

    vim hive-site.xml

<property>
  <name>hive.metastore.warehouse.dir</name>
  <value>/user/hive/warehouse</value>
  <description>location of default database for the warehouse</description>
 </property>


<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://192.168.1.1/hive?createDatabaseIfNotExist=true</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>
</property>


<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>123456</value>
</property>


<property>
  <name>hive.metastore.uris</name>
  <value>thrift://192.168.1.1 :9083</value>
</property>


    
  需要更换Hadoop下面的jline文件
 $HIVE_HOME/lib/jline-2.12.jar放到$HADOOP_HOME/share/hadoop/yarn/lib/jline-2.12.jar


  启动metastore，远程访问hive。
  hive --service metastore &
  

转载于:https://my.oschina.net/u/1439539/blog/657507