Hive

Hive:数据仓库

Hive:解释器,编译器,优化器等

Hive理解为hadoop的客户端

1.解压,2建立软连

3.conf目录下 cp -a hive-default.xml.template hive-site.xml

4.bin目录下启动 ./hive

Hive运行时一定有元数据,存储在关系型数据库里面

安装关系型数据库 yum install mysql-server

启动mysql service mysqld start

mysql 驱动包 cp -a mysql-connector-java-5.1.32-bin.jar /home/hive/lib/

使用mysql 命令登录到mysql

mysql> grant all on . to root@‘%’ identified by ‘zl’;

vi hive-site.xml

修改

javax.jdo.option.ConnectionURL
jdbc:mysql://mini1:3306/hive
JDBC connect string for a JDBC metastore

javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
Driver class name for a JDBC metastore

javax.jdo.option.ConnectionUserName
root
password to use against metastore database

javax.jdo.option.ConnectionPassword
zl
password to use against metastore database