Hive运行方式&GUI接口

最新推荐文章于 2022-10-18 20:17:59 发布

A6-母婴小店-第6分店

最新推荐文章于 2022-10-18 20:17:59 发布

阅读量311

点赞数

分类专栏： HIVE 文章标签：大数据

本文链接：https://blog.csdn.net/chooser007/article/details/118345971

版权

Hive运行方式：

1、命令行方式cli(控制台模式)

2、脚本运行方式（生产环境主要使用这种模式）

3、JDBC方式：hiveserver2

4、Web Gui 接口(hwi、hue等)

命令行（控制台模式），可以与hdfs交互--通过执行dfs 命令、与Linux交互 -- 使用！开头

1、与hdfs交互
hive> dfs -cat /user/hive/warehouse/bucket_sample/000001_0;
7,alice,77
3,dog,33

hive> dfs -ls /;
Found 3 items
drwxr-xr-x   - root supergroup          0 2021-06-02 21:41 /mycluster
drwx------   - root supergroup          0 2021-06-13 17:41 /tmp
drwxr-xr-x   - root supergroup          0 2021-06-26 12:01 /user
hive> 

2、与Linux交互
hive> !pwd;
/root
hive> !date;
Tue Jun 29 23:13:06 CST 2021
hive> 

3、提交SQL语句
 hive> select * from student;
OK
student.id	student.name	student.likes	student.address
1	小红1	["王者","book","movie"]	{"modu":"renminglu","shenzheng":"futian"}
2	小红2	["王者","book","movie"]	{"modu":"renminglu","xizhang":"lasha"}
3	小红3	["吃鸡","book","movie"]	{"chongqing":"renminglu","shenzheng":"futian"}
4	小红4	["王者","book","movie"]	{"modu":"renminglu","dongguang":"changan"}
5	小红5	["walking","book","movie"]	{"modu":"renminglu","shenzheng":"futian"}
6	小红6	["王者","book","movie"]	{"nanchang":"renminglu","shenzheng":"futian"}
7	小红7	["王者","book","movie"]	{"modu":"renminglu","shenzheng":"futian"}
8	小红8	["walking","book","movie"]	{"nanchang":"renminglu","guangzhou":"niwan"}
9	小红9	["王者","book","movie"]	{"modu":"renminglu","shenzheng":"futian"}
10	小红10	["王者","book","movie"]	{"shanghai":"renminglu","shenzheng":"futian"}
Time taken: 1.995 seconds, Fetched: 10 row(s)
hive>

脚本方式运行

1、查询hive客户端如何使用
[root@node04 ~]# hive --service cli -help
which: no hbase in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/java/jdk1.8.0_291-amd64/bin:/opt/software/hadoop-2.10.1/bin:/opt/software/hadoop-2.10.1/sbin:/opt/software/apache-zookeeper
-3.6.2-bin/bin:/opt/software/hive/bin:/root/bin)usage: hive
 -d,--define <key=value>          Variable substitution to apply to Hive
                                  commands. e.g. -d A=B or --define A=B
    --database <databasename>     Specify the database to use
 -e <quoted-query-string>         SQL from command line
 -f <filename>                    SQL from files
 -H,--help                        Print help information
    --hiveconf <property=value>   Use value for given property
    --hivevar <key=value>