如何绕过ODPS不支持的笛卡尔积的限制Cartesian product is not allowed without map join

风神AI关注

0.0852018.02.14 19:23:36字数 39阅读 6,229

select * from pn_tablename a join pn_tablename b;

*ODPS-0130252 Cartesian product is not allowed without map join *的错误

select * from (select *, 1 as raoguo from pn_tablename) a join (select *,1 as raoguo from pn_tablename) b on a.raoguo = b.raoguo;