hive 安装

hive-0.13.1-cdh5.2.0

---

路径：/opt/dev/hive/hive-0.13.1-cdh5.2.0

启动：hive

停止：quit;

环境变量

    export HIVE_HOME= /opt/dev/hive/hive-0.13.1-cdh5.2.0

    export PATH=$PATH:$HIVE_HOME/bin

    source /etc/profile

配置文件

    1.hive-env.sh

           HADOOP_HOME=/opt/dev/hadoop/hadoop-2.5.0-cdh5.2.0

    2.hive-site.sh     

        <property>

          <name>hive.metastore.warehouse.dir</name>

          <value>/opt/dev/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.0.100:3306/hive_hdp?

                    characterEncoding=UTF-8&amp;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>

          <description>username to use against metastore database</description>

        </property>

        <property>

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

          <value>root</value>

          <description>password to use against metastore database</description>

        </property>

JDBC驱动

    上传数据库驱动到lib目录

启动

    先启动hadoop

    后启动hive

异常

    解决方案：ALTER DATABASE hive_hdp CHARACTER SET latin1

    异常信息：FAILED: Error in metadata: MetaException(message:Got exception: javax.jdo.JDODataStoreException An exception was thrown while adding/validating class(es) : Specified key was too long; max key length is 767 bytes
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

使用：

create table student(classNo string, stuNo string, score int) row format delimited fields terminated by ',';

load data local inpath '/home/user/input/student.txt' overwrite into table student;

select * from student;

Select classNo,count(score) fromstudent where score>=60 group by classNo;