如何绕过ODPS不支持的笛卡尔积的限制
select * from pn_tablename a join pn_tablename b;
odps不支持无 on 的 join 会报
*ODPS-0130252 Cartesian product is not allowed without map join *的错误
可以往select里增加字段来绕过这个限制
select * from (select *, 1 as raoguo from pn_tablename) a join (select *,1 as raoguo from pn_tablename) b on a.raoguo = b.raoguo;