#启动，也可以让它在后台启动

[root@hadoop-senior hive-0.13.1]# bin/hiveserver2

#连接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)

HiveServer2 JDBC

    将分析的结果存储在hive表（result），前端通过DAo代码，进行数据的查询。