hadoop && hive 搭建过程
cd hive/confhive.cli.print.header#显示表头
true
Whether to print the names of the columns in query output.
hive.metastore.local
false
controls whether to connect to remove metastore server or open a new metastore server in Hive Client JVM
javax.jdo.option.ConnectionURL
jdbc:mysql://111.111.111.111:3306/hivedb?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=latin1#远程数据库 用户名及密码
JDBC connect string for a JDBC metastore
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
Driver>
javax.jdo.option.ConnectionUserName
hive
username to use against metastore database
javax.jdo.option.ConnectionPassword
hivepass
password to use against metastore database
hive.stats.dbconnectionstring
jdbc:mysql://111.111.111.111:3306/hive_stats?useUnicode=true&characterEncoding=latin1&user=hive&password=hivepass&createDatabaseIfNotExist=true
The default connection string for the database that stores temporary hive statistics.
hive.stats.dbconnectionstring
jdbc:mysql://111.111.111.111:3306/hive_stats?useUnicode=true&characterEncoding=utf8&user=hive&password=hivepass&createDatabaseIfNotExist=true
The default connection string for the database that stores temporary hive statistics.
hive.stats.dbclass
jdbc:mysql
The default database that stores temporary hive statistics.
hive.stats.jdbcdriver
com.mysql.jdbc.Driver
The JDBC driver for the database that stores temporary hive statistics.
hive.metastore.uris
thrift://127.0.0.1:9083
vim hive-env.sh
添加:
export HADOOP_HOME=$HOME/hadoop
页:
[1]