图解教程--如何用JDBC访问Hive

1. 启动hiveserver2服务

bin/hiveserver2

它是一个阻塞进程，如下图：

2. 启动beeline

新开一个窗口，执行命令：

bin/beeline

3. 连接hiveserver2

beeline> !connect jdbc:hive2://hadoop02:10000 (回车)
Connecting to jdbc:hive2://hadoop02:10000
Enter username for jdbc:hive2://hadoop02:10000: hadoop (输入你的用户名)
Enter password for jdbc:hive2://hadoop02:10000: (直接回车)
Connected to: Apache Hive (version 1.2.1)
Driver: Hive JDBC (version 1.2.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://hadoop02:10000> show databases; (测试命令)
+----------------+--+
| database_name  |
+----------------+--+
| dblab          |
| default        |
| mayi0812       |
| test0808       |
| weblog         |
+----------------+--+

到此即大工告成。。。