配置hive使用mysql数据库
------------------------
1.下载并加压hive.tar.gz
2.配置环境变量
HIVE_HOME=...
PATH=..:$HIVE_HOME/bin:$HIVE_HOME/conf
$>source /etc/environment
3.创建配置文件
$>cd conf
$ cp hive-default.xml.template hive-site.xml
$ cp hive-env.sh.template hive-env.sh
$ cp hive-exec-log4j.properties.template hive-execlog4j.properties
$ cp hive-log4j.properties.template hive-log4j.properties
4.修改conf/hive-env.sh配置文件
export HADOOP_HOME=/soft/hadoop
export HIVE_CONF_DIR=/soft/hive/conf
5.修改conf/hive-site.xml文件
hive.metastore.warehourse.dir=/user/hive/warehouse//hdfs系统
hive.exec.scratchdir=/tmp/hive-${user.name}//hdfs系统
6.配置使用mysql数据库
0.在mysql上创建myhive数据库
create database myhive ;
1.配置hive-ste.xml
[conf/hive-site.xml]
#javax.jdo.option.ConnectionURL // the database URL
#javax.jdo.option.ConnectionDriverName // the JDBC driver name
#javax.jdo.option.ConnectionUserName // database username
#javax.jdo.option.ConnectionPassword // database password
javax.jdo.option.ConnectionURL
jdbc:mysql://myhost:3306/myhive?createDatabaseIfNotExist=true
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
hive
username to use against metastore database
javax.jdo.option.ConnectionPassword
hive
password to use against metastore database
7.复制mysql驱动程序到${hive_home}\lib下