Hive中提示Expression Not In Group By Key的解决办法
Hive中提示Expression Not In Group By Key的解决办法sql:selectOrderCode,Status,max(inputDate) as inputDatefrom trade.AuditLogwhere ds={ds}group by OrderCode不在意其他字段值的情况下可使用collect_set()selectOrderCode,collect_set(Status)[0],max(inputDate) as inputDate
原创
2020-08-21 11:02:27 ·
2425 阅读 ·
0 评论