在$HIVE_HOME/conf下新建(或修改)hive-site.xml,内容如下:<?xml version="1.0"?>
hive.metastore.local
true
javax.jdo.option.ConnectionURL
jdbc:mysql://192.100.1.213:3306/hive_test?characterEncoding=UTF-8
hive需要使用关关系型数据库来维护元数据,这里配置的是mysql的相关连接信息
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
javax.jdo.option.ConnectionUserName
root
javax.jdo.option.ConnectionPassword
root
datanucleus.fixedDatastore
false
hive.metastore.warehouse.dir
/home/hadoop/hadoop-data/data/hive
hive.exec.scratchdir
/home/hadoop/hadoop-data/temp
datanucleus.fixedDatastore
false
hive.querylog.location
/home/hadoop/temp/hivelogs