Hive报错--Both left and right aliases encountered in JOIN ‘列名‘
原因两个表join的时候,不支持两个表的字段 非相等 操作。解决可以把不相等条件拿到 where语句中。举例例如:select *from aleft join b on a.month=b.month and a.day<=b.day出现不等连接了,会报错,我们需要改写select *from aleft join b on a.month=b.month where a.day<=b.day...