Hive执行goup by / left join 等聚合操作时报如下错:
"Failed to recognize predicate 'group'. Failed rule: 'identifier' in subquery source"
"Failed to recognize predicate 'left'. Failed rule: 'identifier' in table or column identifier"
解决方法:检查group by / left join前面子句是否有别名,如果没有,需加别名。