(1)创建、配置hive-site.xml文件
$cd /usr/local/hive/conf
$cp hive-default.xml.template ./hive-site.xml $gedit ./hive-site.xml
(2)将配置文件中的内容替换为如下配置
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&characterEncoding=UTF-8&useSSL=false</value> </property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
</property>
<property>
<name>hive.server2.logging.operation.enabled</name>
<value>false</value>
</property>
</configuration>
(3)创建、配置hive-env.sh 文件
$cd /usr/local/hive/conf
$ cp hive-env.sh.template hive-env.sh
$gedit hive-env.sh
(4)在hive-env.sh文件中加入下列配置信息:
export JAVA_HOME=/usr/lib/jvm/jdk1.8.0_231
export HIVE_HOME=/usr/local/hive
export HADOOP_HOME=/usr/local/hadoop
(5)修改Hadoop集群配置core-site.xml,添加如下配置并重启集群
<property>
<name>hadoop.proxyuser.hadoop.groups</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.hadoop.hosts</name>
<value>*</value>
</property>
$stop-all.sh
$start-all.sh
(6)Hive初始化
$ schematool -initSchema -dbType mysql -verbose
(7)启动远程服务HiveServer 2
$hiveserver2 &
(8)打开控制台命令行工具
$hive
$beeline -u jdbc:hive2://master:10000 -n hadoop -p hadoop