HiveSql里group by和order by连用的注意事项_hive group by order by-CSDN博客

网站介绍:文章浏览阅读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