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

??

5)???????????? 在Beeline Shell中查询及表。

0:jdbc:hive2://master:10001/default> use hive;

+---------+--+

| Result  |

+---------+--+

+---------+--+

No rows selected(0.07 seconds)

0:jdbc:hive2://master:10001/default> show tables;

+-----------+-------------+--------------+--+

| database  | tableName  | isTemporary  |

+-----------+-------------+--------------+--+

| hive      | pokes       | false        |

| hive      | pokes_test  | false       |

+-----------+-------------+--------------+--+

2 rows selected(0.094 seconds)

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

 

???????????????? ??接下来，我们停掉Spark 2.2.1的Thriftserver服务，然后启动Hive框架中的Hiveserver2服务，使用Spark的Beeline工具直接连接Hive的Hiveserver2服务。测试HIVE框架的Hiveserver2服务。

???????????????????????????????????? 停掉Spark 2.2.1的Thriftserver服务。

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

stopping org.apache.spark.sql.hive.thriftserver.HiveThriftServer2

                   这时在Beeline工具中查询会报错。

0:jdbc:hive2://master:10001/default> show tables;

Error:org.apache.thrift.transport.TTransportException:org.apache.http.conn.HttpHostConnectException: Connect to master:10001[master/192.168.189.1] failed: Connection refused (state=08S01,code=0)

 

???????????????? 接下来的步骤将启动Hive框架中的Hiveserver2服务。

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

 

#!/bin/sh

nohup /usr/local/apache-hive-1.2.1/bin/hiveserver2>> hiveserver2.log 2>&1 &

echo $! > hive-server2.pid

                   修改start-hiveserver2.sh的执行权限。

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

 

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