在hadoop帳戶下 一、下載hive-0.8.1.tar.gz wget mirrors.cnnic.cn/apache/hive/stable/hive-0.11.0.tar.gz 二、解壓到/opt/modules目錄下 tar -zxvf?hive-0.11.0.tar.gz cd hive-0.11.0 三、配置Hive的環境變量（該步在root帳戶下） vi /etc/profile.d/java.sh export HIVE_HOME=/opt/modules/hive-0.11.0 export PATH=$HIVE_HOME/bin:$PATH 手動立即生效 source /etc/profile 四、拷貝hive的配置模板文件 cd conf/ cp hive-env.sh.template hive-env.sh cp hive-default.xml.template hive-site.xml 五、修改hive-env.sh文件 指定HADOOP_HOME及HIVE_CONF_DIR的路徑如下： HADOOP_HOME=/opt/modules/hadoop/hadoop-1.0.3 export HIVE_CONF_DIR=/opt/modules/hive-0.11.0/conf 六、修改hive-site.xml文件 指定mysql數據庫驅動、數據庫名、用戶名和密碼，修改的內容如下所示： <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&characterEncoding=latin1</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>654321</value> <description>password to use against metastore database</description> </property> 七、拷貝mysql的驅動mysql-connector-java-5.1.18.jar到hive-0.11.0/lib目錄下 八、在HDFS中創建/tmp和/user/hive/warehouse并設置權限 ./hadoop fs -mkdir /tmp ./hadoop fs -mkdir /user/hive/warehouse ./hadoop fs -chmod g+w /tmp ./hadoop fs -chmod g+w /user/hive/warehouse 九、測試Hive是否安裝成功，如下所示 [root@hadoop1 bin]#?hive WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files. Logging initialized using configuration in jar:file:/work/hive/hive-0.8.1/lib/hive-common-0.8.1.jar!/hive-log4j.properties Hive history file=/tmp/root/hive_job_log_root_201302171656_1326720941.txt hive>?create table user(id int,name string); OK Time taken: 3.242 seconds hive> select * from user; OK Time taken: 0.275 seconds hive> exit; [root@hadoop1 bin]# 十、報錯 FAILED: Error in metadata: 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 修改方法（mysql中）： alter database hive character set latin1;

轉載于:https://www.cnblogs.com/jingyunyb/p/3401300.html

總結

以上是生活随笔為你收集整理的Hive的安装和配置的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。