HiveSql里group by和order by连用的注意事项
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
