HIVE hive1.2.1 安装

Hive 安装

 1). 建立数据库hive，并设定为latin1编码，否则出错

create database hive default character set latin1;

2). 创建用户hive

create user 'hive'@'localhost' identified by 'hive';

 3).创建hive用户,并授权

grant all on hive.* to hive@'localhost'  identified by 'hive';

flush privileges;

4. 修改hive-site.xml文件

<property>    

  <name>javax.jdo.option.ConnectionURL</name> 

  <value>jdbc:mysql://localhost:3306/hive?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>hive</value>    

  <description>username TOUSE against metastore database</description>    

</property>    

<property>    

  <name>javax.jdo.option.ConnectionPassword</name> 

  <value>hive</value>    

  <description>password TOUSE against metastore database</description>    

</property>

 

 

下载mysql-connector-java-5.1.32-bin.ja文件，并放到$HIVE_HOME/lib目录下

 

Hive  看看会不会报错  报错的话查看数据库有搞了没  【数据库上一张博客】

[root@master lib]# hive

 

Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-1.2.1.jar!/hive-log4j.properties

hive>

成功！！！ 收工

建几个表测试一下