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;