1.配置元数据库
(1)安装mysql
1)采用yum安装方式yum install mysql 安装mysql客户端yum install mysql-server 安装mysql服务端
2) 数据库字符集设置:mysql配置文件/etc/my.cnf中加入default-character-set=utf8
3) 启动mysql服务:service mysqld start或者/etc/init.d/mysqld start
停止:service mysqld stop
4) 开机启动:chkconfig -add mysqld或 sudo chkconfig mysqld on开机启动设置是否成功chkconfig --list | grep mysql*
5) 创建root管理员:mysqladmin -u root password 123456
6) 登录 mysql - uroot –p 密码
(2)
1)设置hive的hive-site.xml文件如果需要远程连接元数据库,还需要配置:
属性
值
javax.jdo.option.ConnectionURL
jdbc:mysql://192.168.1.109/hive?createDatabaseIfNotExist=true
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
javax.jdo.option.ConnectionUserName
root
javax.jdo.option.ConnectionPassword
123456
属性
值
默认值
hive.metastore.local
true
false
hive.metastore.uris
如thrift://192.168.1.110:9083
2)Mysql的jdbc驱动包放到hive的lib下
3)GRANT ALL PRIVILEGES ON *.* TO 'root'@‘192.168.1.101' IDENTIFIED BY '123456' WITH GRANT OPTION;