[100% Interview Question] Broadcast Join Spark | Increase Spark Join Performance

[@amritranjannayak2705]

what is the difference between broadcast join and mapside join. What was the need of broadcast join although mapside join was available earlier.Could you please explain if you have any idea on this.?

[@anandkanawade9895]

Please make a video of oracle dba L1 L2 interview questions

[@neelamlaxman4223]

Hi bro please make a vedio on spark skew ness and salting method in spark

[@chiragdua2919]

hey Ankush I have one query like in a smaller table i have 1000 rows if I broadcast this table then each node contains 1000 rows or divide 1000 row into all nodes??

[@ritikpatil4077]

Im late to the party, but for future reference just to answer your question. Each node will contain 1000 rows, it will not divide(shuffle) 1000 rows. We are doing this so it doesn't have to shuffle your small table as well

[@negisaab74347]

@@ritikpatil4077one more question. How does big table divides into 4 clusters? Do we write the query in each cluster to get dat? I basically want to understand from mysql db point of view. Do we need to fetch data in dataframes to make a join?

[@mdshahalam3010]

Sir, Do you have any plan to create a full course on docker?

[@learnomate]

Thanks. May be in future but not right now.