hive使用技巧

最新推荐文章于 2025-06-13 21:36:39 发布

原创

最新推荐文章于 2025-06-13 21:36:39 发布 · 484 阅读

收录于

当前文章被以下社区和专栏收录：

1、hive常用交互命令

在这里插入图片描述

hive -e 非交互式执行SQL

[atguigu@hadoop102 conf]$ hive -e "insert into stu values(1, 'abc')"
which: no hbase in (/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/module/jdk1.8.0_241/bin:/opt/module/hadoop-3.3.4/bin:/opt/module/hadoop-3.3.4/sbin:/opt/module/apache-hive-3.1.3-bin/bin:/home/atguigu/.local/bin:/home/atguigu/bin)
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/module/apache-hive-3.1.3-bin/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/module/hadoop-3.3.4/share/hadoop/common/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Hive Session ID = b28977c0-02cb-4f86-9803-73f2268ab6a0

Logging initialized using configuration in jar:file:/opt/module/apache-hive-3.1.3-bin/lib/hive-common-3.1.3.jar!/hive-log4j2.properties Async: true
Hive Session ID = 2650a002-5e5e-43cc-95fa-5348c3aa631e
Query ID = atguigu_20240421234049_c752127d-b8a8-4ca5-a750-00b078769ceb
Total jobs = 3
Launching Job 1 out

标签