Hive中不走MapReduce的查询

最新推荐文章于 2021-04-20 16:19:45 发布

lzm1340458776

最新推荐文章于 2021-04-20 16:19:45 发布

阅读量2.9k

点赞数

分类专栏： Hive 文章标签： Hive查询语句 Hive语句不经过MapReduce 不经过MapReduce的Hive语句

本文链接：https://blog.csdn.net/lzm1340458776/article/details/43085289

版权

本文介绍了Hive中两种不触发MapReduce作业的查询情况：查询整个表的数据和抽样查询。这些操作在执行时跳过了MapReduce阶段，提供了更高效的查询方式。

摘要由CSDN通过智能技术生成

在Hive中查询语句往往都要被解析成MapReduce的job进行计算，但是有两个查询语句是不走MapReduce的，如下：

1.查询某张表的所有数据

select * from employees;

结果显示如下：

hive> select * from employees;
OK
lavimer	15000.0	["li","lu","wang"]	{"k1":1.0,"k2":2.0,"k3":3.0}	{"street":"dingnan","city":"ganzhou","num":101}
liao	18000.0	["liu","li","huang"]	{"k4":2.0,"k5":3.0,"k6":6.0}	{"street":"dingnan","city":"ganzhou","num":102}
zhang	19000.0	["xiao","wen","tian"]	{"k7":7.0,"k8":8.0,"k8":8.0}	{"street":"dingnan","city":"ganzhou","num":103}
Time taken: 0.176