一、安装
1、 下载安装hive
hive-0.11.0.tar.gz(稳定版)
目录:/data
tar –zxvfhive-0.11.0.tar.gz
2、 配置
把所有的模板文件copy一份
cd /opt/hive-0.11.0/conf
cp hive-default.xml.template hive-site.xml
cp hive-env.sh.template hive-env.sh
cp hive-log4j.properties.template hive-log4j.properties
cp hive-exec-log4j.properties.template hive-exec-log4j.properties
3、 修改hive-site.xml
<property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://192.168.0.6:3306/hive?createDatabaseIfNotExist=true</value> <description>JDBC connect string for aJDBCmetastore</description> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> <description>Driver class name for aJDBCmetastore</description> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>hive</value> <description>username to use againstmetastoredatabase</description> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>hive</value> <description>password to use againstmetastoredatabase</description> </property> <property> <name>hive.metastore.schema.verification</name> <value>false</value> <description>
Enforce metastore schema version consistency.
True: Verify that version information stored in metastore matcheswithone from Hive jars. Alsodisableautomatic
schema migration attempt. Users are required to manully migrateschemaafter Hive upgrade which ensures
proper metastore schema migration. (Default)
False: Warn if the version information stored in metastore doesn'tmatchwith one from in Hive jars.
</description>
</property>
4、 修改hive-env.sh
# Set HADOOP_HOME to pointto a specific hadoop install directory
export HADOOP_HOME=/usr/local/hadoop
#HiveConfiguration Directory can be controlled by:
export HIVE_CONF_DIR=/usr/local/hive/conf
5、 安装mysql jdbc
hadoop@james-ubuntu32:~/tmp/tools$cp mysql-connector-java-5.1.28-bin.jar /usr/local/hive/lib
6、较验hive
1、启动hive:
Bin/hive
nohup hive --service hiveserver
2、测试sql:
show tables;
create table shark_test01(id int, namestring);
select * from shark_test01;
exit;
查看hive创建的文件：hadoop fs -ls -R /user/hive
7、 各项配置详解
http://blog.csdn.net/w13770269691/article/details/17232947
8、错误及解决
错误3：
MetaException(message:file:/user/hive/warehouse/xxxxis not a directory or unable to create one)
解决：
CLASSPATH中加入HADOOP_CONF_DIR
错误2：
Error in metadata:MetaException(message:Got exception:org.apache.hadoop.hive.metastore.api.MetaExceptionjavax.jdo.JDODataStoreException: An exception was thrown whileadding/validating class(es) : Specified key was too long; max key length is 767bytes
解决：
只要修改MySQL中Hive元数据库MetaStore的字符集便可。
alter database dbname character set latin1;
错误1：
java.lang.RuntimeException: Unable toinstantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient。
解决：
在CLASSPATH中要有mysql的jdbc驱动。