https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients
一、HiveServer2、Beeline
1、HiveServer2
HiveServer2是作为hive的一个服务启动的;
#启动,也可以让它在后台启动
[root@hadoop-senior hive-0.13.1]# bin/hiveserver2
2、beeline
#连接hiveserver2
[root@hadoop-senior hive-0.13.1]# bin/beeline
beeline> !connect jdbc:hive2://hadoop-senior.ibeifeng.com:10000 root 123456 org.apache.hive.jdbc.HiveDriver
#root 123456 :系统的用户名、密码
#连接后,如下所示,就可以执行命令了,和在hive client一样
beeline> !connect jdbc:hive2://hadoop-senior.ibeifeng.com:10000 root 123456 org.apache.hive.jdbc.HiveDriver
Connecting to jdbc:hive2://hadoop-senior.ibeifeng.com:10000
Connected to: Apache Hive (version 0.13.1)
Driver: Hive JDBC (version 0.13.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://hadoop-senior.ibeifeng.com:10>
##这个里面输出结果的格式化效果稍微好一点
0: jdbc:hive2://hadoop-senior.ibeifeng.com:10> show databases;
+----------------+
| database_name |
+----------------+
| db_hive |
| default |
+----------------+
2 rows selected (0.702 seconds)
0: jdbc:hive2://hadoop-senior.ibeifeng.com:10> use default;
No rows affected (0.027 seconds)
0: jdbc:hive2://hadoop-senior.ibeifeng.com:10> show tables;
+---------------------+
| tab_name |
+---------------------+
| bf_1og_20150913 |
| bf_1og_20150913_sa |
| bf_log |
| bf_log_20150914 |
| dept |
| dept_cats |
| dept_part |
| emp |
| emp_ci |
| emp_ext |
| emp_ext2 |
| emp_partition |
+---------------------+
12 rows selected (0.039 seconds)
#第二种连接方式。-u参数
[root@hadoop-senior hive-0.13.1]# bin/beeline -u jdbc:hive2://hadoop-senior.ibeifeng.com:10000/default
scan complete in 3ms
Connecting to jdbc:hive2://hadoop-senior.ibeifeng.com:10000/default
Connected to: Apache Hive (version 0.13.1)
Driver: Hive JDBC (version 0.13.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 0.13.1 by Apache Hive
0: jdbc:hive2://hadoop-senior.ibeifeng.com:10> show tables;
+---------------------+
| tab_name |
+---------------------+
| bf_1og_20150913 |
| bf_1og_20150913_sa |
| bf_log |
| bf_log_20150914 |
| dept |
| dept_cats |
| dept_part |
| emp |
| emp_ci |
| emp_ext |
| emp_ext2 |
| emp_partition |
+---------------------+
12 rows selected (0.12 seconds)
二、JDBC
HiveServer2 JDBC
将分析的结果存储在hive表(result),前端通过DAo代码,进行数据的查询。