Hive安装配置笔记

Hive元数据三种存储方式
1.Derby：hive默认的存储模式，不可以并发调用hive
2.本地MySQL
3.远程MySQL采用第二种方式，安装MySQL，启动并创建Hive用户，创建Hive元数据库insert into mysql.user（Host,User,Password） values（"localhost","hive",password（"hive"））;create database hive;grant all on hive.* to hive@"%" identified by "hive";grant all on hive.* to hive@"localhost" identified by "hive";flush privileges;配置Hive环境变量vim /etc/profile修改Hive配置修改hive-site.xml<property>name>javax.jdo.option.ConnectionURL </name>value>jdbc:mysql://localhost:3306/hive </value></property><property>name>javax.jdo.option.ConnectionDriverName </name>value>com.mysql.jdbc.Driver </value></property><property>name>javax.jdo.option.ConnectionPassword </name>value>hive </value></property><property>name>hive.hwi.listen.port </name>value>9999 </value>description>This is the port the Hive Web Interface will listen on </descript ion></property><property>name>datanucleus.autoCreateSchema </name>value>true</value></property><property>name>datanucleus.fixedDatastore </name>value>false</value></property></property>property>name>javax.jdo.option.ConnectionUserName</name>value>hive</value>description>Username to use against metastore database</description>/property>property>name>hive.exec.local.scratchdir</name>value>/home/hdpsrc/hive/iotmp</value>description>Local scratch space for Hive jobs</description>/property>property>name>hive.downloaded.resources.dir</name>value>/home/hdpsrc/hive/iotmp</value>description>Temporary local directory for added resources in the remote file system.</description>/property>property>name>hive.querylog.location</name>value>/home/hdpsrc/hive/iotmp</value>description>Location of Hive run time structured log file</description>/property>注意事项

找到mysql的jdbc驱动，比如mysql-connector-java-5.1.6-bin.jar拷贝到hive/lib目录下
hive/lib/jline-2.12.jar拷贝到/Hadoop/yarn/lib/目录下

启动Hive,测试在hive中新建表在MySQL中查看Hive编程指南 PDF 中文高清版 http://www.linuxidc.com/Linux/2015-01/111837.htm基于Hadoop集群的Hive安装 http://www.linuxidc.com/Linux/2013-07/87952.htmHive内表和外表的区别 http://www.linuxidc.com/Linux/2013-07/87313.htmHadoop + Hive + Map +reduce 集群安装部署 http://www.linuxidc.com/Linux/2013-07/86959.htmHive本地独立模式安装 http://www.linuxidc.com/Linux/2013-06/86104.htmHive学习之WordCount单词统计 http://www.linuxidc.com/Linux/2013-04/82874.htmHive运行架构及配置部署 http://www.linuxidc.com/Linux/2014-08/105508.htmHive 的详细介绍：请点这里
Hive 的下载地址：请点这里本文永久更新链接地址