hive 安装，

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;