728x90

2023/02/26 13

[spark] broadcast nested loop join

spark.conf.set("spark.sql.autoBroadcastJoinThreshold", -1) sql("select * from table_withNull where id not in (select id from tblA_NoNull)").explain(true) not exists를 사용하면 쿼리가 SortMergeJoin과 함께 실행됩니다. https://www.bigdatainrealworld.com/how-does-broadcast-nested-loop-join-work-in-spark/ How does Broadcast Nested Loop Join work in Spark? Broadcast Nested Loop join works by broadcasting one of the e..

728x90