网站介绍:文章浏览阅读3.9k次。hive的语句执行顺序是group by ... select ... order byorder by是对前面查询到的结果进行排序,两者连用的语法顺序即 select ... group by ... order by注意事项有两点:1. order by的字段必须是在group by中,或者是聚合函数1. select file1,file2 from tableName group by file1,file2 order by file1;2. select file1, cou_hive group by order by
- 链接地址:https://blog.csdn.net/wx1528159409/article/details/122883438
- 链接标题:HiveSql里group by和order by连用的注意事项_hive group by order by-CSDN博客
- 所属网站:blog.csdn.net
- 被收藏次数:8122
- 网站标签:hive group by order by