hive入门二（将hive发布为服务）

hive发布为服务

• 进入hive的bin目录

[hadoop@langzi01 bin]$ cd /usr/soft/hive/bin/

• 查看列表

[hadoop@langzi01 bin]$ ll

内容如下：

-rwxr-xr-x 1 hadoop hadoop 1031 Apr  1  2017 beeline
drwxr-xr-x 3 hadoop hadoop 4096 Sep  3 13:47 ext
-rwxr-xr-x 1 hadoop hadoop 7844 Apr  1  2017 hive
-rwxr-xr-x 1 hadoop hadoop 1900 Jan  8  2016 hive-config.sh
-rwxr-xr-x 1 hadoop hadoop  885 Jan  8  2016 hiveserver2
-rwxr-xr-x 1 hadoop hadoop  832 Jan  8  2016 metatool
-rwxr-xr-x 1 hadoop hadoop  884 Jan  8  2016 schematool

其中hiveserver2为可以将hive发布为服务，通过beeline客户端访问服务

• 启动hiveserver2

[hadoop@langzi01 bin]$ ../bin/hiveserver2

• 客户端访问，执行beeline

[hadoop@langzi01 bin]$ ./beeline 
Beeline version 1.2.2 by Apache Hive

• 链接服务

beeline> !connect  jdbc:hive2://localhost:10000
Connecting to jdbc:hive2://localhost:10000
Enter username for jdbc:hive2://localhost:10000: hadoop
Enter password for jdbc:hive2://localhost:10000: 
Connected to: Apache Hive (version 1.2.2)
Driver: Hive JDBC (version 1.2.2)
Transaction isolation: TRANSACTION_REPEATABLE_READ

这里的用户名和密码：没有配置，默认是使用启动hive服务的用户名，这里为：hadoop，没有密码。

出现：

0: jdbc:hive2://localhost:10000>

链接成功。

体验一下：

0: jdbc:hive2://localhost:10000> show databases;
+----------------+--+
| database_name  |
+----------------+--+
| default        |
| shizhan03      |
+----------------+--+
2 rows selected (1.668 seconds)

0: jdbc:hive2://localhost:10000> use shizhan03;
No rows affected (0.079 seconds)
0: jdbc:hive2://localhost:10000> show tables;
+-----------+--+
| tab_name  |
+-----------+--+
| t_sz01    |
+-----------+--+
1 row selected (0.102 seconds)
0: jdbc:hive2://localhost:10000> select * from t_sz01;
+------------+--------------+--+
| t_sz01.id  | t_sz01.name  |
+------------+--------------+--+
| 1          | zhangsan     |
| 2          | lisi         |
| 3          | wangwu       |
| 4          | zhaoliu      |
| 5          | zhouqi       |
+------------+--------------+--+
5 rows selected (0.855 seconds)

ok!!