分布式部署 Spark 2.2.1 集成Hive数据仓库的案例与解读(8)

7)????????????通过start-hiveserver2.sh脚本启动Hive框架的的Hive2server服务。脚本执行以后会生成日志文件hiveserver2.log和PID查询文件Hive-server2.pid。

?? ?? ?? ?? ?? ?? ?? ?? JPS查询显示增加了一个RunJar的进程。同Hive-server2.pid记录的进程号是一致的。

root@master:/usr/local/apache-hive-1.2.1/bin#./start-hiveserver2.sh

root@master:/usr/local/apache-hive-1.2.1/bin# ls

beeline  ext  hive hive-config.sh  hiveserver2  hiveserver2.log  hive-server2.pid  metatool schematool  start-hiveserver2.sh

 

查询Hive-server2.pid获得Hive2server的PID是10591。

root@master:/usr/local/apache-hive-1.2.1/bin# cathive-server2.pid

10591

 

                   查询JPS进程。

root@master:/usr/local/apache-hive-1.2.1/bin#jps

10704 BeeLine

9969 Master

8801ResourceManager

8451 NameNode

8633SecondaryNameNode

10762 Jps

10591 RunJar

 

   

??

8)???????????? 启动Http模式下的Beeline，直接连接Hive框架的Hive2server服务。

root@master:/usr/local/spark-2.2.1-bin-hadoop2.6/sbin#../bin/beeline

Beeline version1.2.1.spark2 by Apache Hive

beeline>!connect jdbc:hive2://master:10001/default?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice

Connecting tojdbc:hive2://master:10001/default?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice

Enter username forjdbc:hive2://master:10001/default?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice:root

Enter password forjdbc:hive2://master:10001/default?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice:****

18/02/20 21:26:34INFO jdbc.Utils: Supplied authorities: master:10001

18/02/20 21:26:34WARN jdbc.Utils: ***** JDBC param deprecation *****

18/02/20 21:26:34WARN jdbc.Utils: The use of hive.server2.transport.mode is deprecated.

18/02/20 21:26:34WARN jdbc.Utils: Please use transportMode like so:jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value>

18/02/20 21:26:34WARN jdbc.Utils: ***** JDBC param deprecation *****

18/02/20 21:26:34WARN jdbc.Utils: The use of hive.server2.thrift.http.path is deprecated.

18/02/20 21:26:34WARN jdbc.Utils: Please use httpPath like so:jdbc:hive2://<host>:<port>/dbName;httpPath=<http_path_value>

18/02/20 21:26:34INFO jdbc.Utils: Resolved authority: master:10001

Connected to:Apache Hive (version 1.2.1)

Driver: Hive JDBC(version 1.2.1.spark2)

Transactionisolation: TRANSACTION_REPEATABLE_READ

0:jdbc:hive2://master:10001/default>

这里的10001为刚才设置属性hive.server2.thrift.http.port，default为默认的，连接成功。

 

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-86251-8.html