Hive-0.13.1本地独立模式安装 元数据存储到MariaDB-10.1.0 Hadoop-2.4.0

http://xiejianglei163.blog.163.com/blog/static/1247276201462491813826/

使用的Hadoop版本:2.4.0

离线安装MariaDB:

http://xiejianglei163.blog.163.com/blog/static/124727620144541845753/

安装完后查看mariadb状态:

service mysql status

service mysql start

修改root密码:

mysqladmin -u root password 'root'

登录:

mysql -u root -p

创建用户 :

1. MariaDB [(none)]>insert into mysql.user(Host,User,Password) values("localhost","hadoop",password("hadoop"));
2. MariaDB [(none)]>flush privileges;

创建数据库:

MariaDB [(none)]>create database hive;

授权:

MariaDB [(none)]>grant all on hive.* to hadoop@'%' identified by "hadoop";

MariaDB [(none)]> flush  privileges ;

安装Hive,解压:

tar -zxvf apache-hive-0.13.1-bin.tar.gz

解压后,编辑java.sh(java.sh为自己创建的脚本): vim /etc/profile.d/java.sh

export HIVE_HOME=/opt/modules/hive/apache-hive-0.13.1-bin

export HIVE_CONF_DIR=$HIVE_HOME/conf

export CLASSPATH=$CLASSPATH:$HIVE_HOME/lib

并将$HIVE_HOME/bin加入到PATH中

下载java的驱动包:

mariadb-java-client-1.1.7.jar

放到$HIVE_HOME/lib下面

复制hive-default.xml.template为hive-site.xml并编辑:

<property>

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

<value>jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true</value>

<description>JDBC connect string for a JDBC metastore</description>

 </property>

<property>

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

<value>org.mariadb.jdbc.Driver</value>

<description>Driver class name for a JDBC metastore</description>

</property>

<property>

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

<value>hadoop</value>

<description>username to use against metastore database</description>

</property>

<property>

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

<value>hadoop</value>

<description>username to use against metastore database</description>

</property>

<property>

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

<value>hadoop</value>

<description>password to use against metastore database</description>

</property>

<property>

<name>hive.metastore.warehouse.dir</name>

<value>hdfs://master:9000/user/hive/warehouse</value>

<description>location of default database for the warehouse</description>

</property>

命令:hive

hive>show tables;

create table xjl(id int);

drop table xjl;

查看MariaDB中的hive可以看到出现了许多张表

Hive的数据存放在hdfs中/user/hive/warehouse中