Oracle和spark sql的对比
Oracle:select * from A,B where A.id=B.id
spark sql : A inner join B on(A.id=B.id)
Oracle:select * from A,B where A.id=B.id(+)
spark sql : A left join B on(A.id=B.id)
Oracle:select * from A where exists(select 1 from B where A.id=B.id)
spark sql ..
原创
2021-03-31 16:48:33 ·
1031 阅读 ·
0 评论