问题:FAILED: SemanticException [Error 10025]: Line 104:25 Expression not in GROUP BY key 'day'
其实这个日志已经告诉你问题出在哪里了,line104对应的那个SQL语句select * from where * group by key1,key2;
group by key需加上缺失的key(day)才行;
当用1,2,3,4等位置来表示对应的key时,常常会遗忘。
问题:FAILED: SemanticException [Error 10025]: Line 104:25 Expression not in GROUP BY key 'day'
其实这个日志已经告诉你问题出在哪里了,line104对应的那个SQL语句select * from where * group by key1,key2;
group by key需加上缺失的key(day)才行;
当用1,2,3,4等位置来表示对应的key时,常常会遗忘。