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

2)???????????? 执行Spark 2.2.1自带的Beeline工具，通过!connectjdbc:hive2://master:10001命令连接到HiveThriftServer2服务。

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

Beeline version1.2.1.spark2 by Apache Hive

beeline>!connect jdbc:hive2://master:10001

Connecting tojdbc:hive2://master:10001

Enter username forjdbc:hive2://master:10001: root

Enter password forjdbc:hive2://master:10001: ****

18/02/20 19:01:40INFO jdbc.Utils: Supplied authorities: master:10001

18/02/20 19:01:40INFO jdbc.Utils: Resolved authority: master:10001

18/02/20 19:01:40INFO jdbc.HiveConnection: Will try to open client transport with JDBC Uri:jdbc:hive2://master:10001

Connected to: SparkSQL (version 2.2.1)

Driver: Hive JDBC(version 1.2.1.spark2)

Transactionisolation: TRANSACTION_REPEATABLE_READ

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

 

3)???????????? 在BeelineShell交互式工具中查询Hive中的及表。

0:jdbc:hive2://master:10001> show databases;

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

| databaseName  |

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

| default       |

| hive          |

| hivestudy     |

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

3 rows selected(1.155 seconds)

 

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

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

| Result  |

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

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

No rows selected(0.093 seconds)

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

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

| database  | tableName  | isTemporary  |

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

| hive      | pokes       | false        |

| hive      | pokes_test  | false       |

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

2 rows selected(0.055 seconds)

 

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