hive本地安装

来源：互联网发布：石油钻井数据与油价编辑：程序博客网时间：2024/04/30 15:20

[所有的颠沛流离，最终都由大江流向大海]

===================

OS version: OS X 10.10

hadoop version: 2.0.0-cdh4.5.0

JAVA version: 1.7.0_79

HIVE version: apache-hive-1.0.1

====================

1.dependencies

hadoop and mysql

2.hive 安装

下载后放入指定目录
/Users/username/Library/cloudera/apache-hive-1.0.1-bin
修改zshrc，增加如下：

export HIVE_HOME="/Users/maixiaohai/Library/cloudera/apache-hive-1.0.1-bin"export PATH="/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:${HADOOP_HOME}/bin:${HADOOP_HOME}/sbin:${HBASE_HOME}/bin:${HIVE_HOME}/bin"

修改配置参数：
conf目录下，cp hive-default.xml.template 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>// 1234对应hive用户的密码<property>    <name>javax.jdo.option.ConnectionPassword </name>    <value>1234 </value> </property><property>    <name>javax.jdo.option.ConnectionUserName</name>    <value>hive</value>    <description>Username to use against metastore database</description>  </property>

以及所有带${system:java.io.tmpdir}的value都改为/Users/maixiaohai/cloudera/hive即可

3.mysql安装

mysql -u root -p
use mysql;
增加hive用户：create user ‘hive’ identified by ‘1234’;
及权限： GRANT ALL PRIVILEGES ON . TO ‘hive’@’localhost’ IDENTIFIED BY ‘1234’ WITH GRANT OPTION;
flush privileges;
exit

建立hive专用数据库：
mysql -u hive -p
create database hive;
alter database hive character set latin1;

下载mysql-connector-java-5.0.8.jar，cp到lib目录下

4.测试

启动hadoop，命令行输入hive，进入类似mysql的交互界面，输入
show databases;成功
如有错误，大概率出现在hive用户在数据库中的权限上

0 0