09. Databricks | PySpark Join Types

[@parameshgosula5510]

Quite clean and neat...
Pls keep covering the other to topics as well .

[@rajasdataengineering7585]

Sure Paramesh, will cover more topics in upcoming videos

[@naturalraver4151]

Nyz!!! Thanks for covering the topics clearly ❤❤

[@rajasdataengineering7585]

My pleasure 😊
Thanks for your comment

[@gulsahtanay2341]

Thanks for the detailed explanation.

[@rajasdataengineering7585]

Glad it was helpful! You are welcome

[@divyasreeperumal3364]

Thanks for your detailed video right from the basic..

[@rajasdataengineering7585]

Glad it was helpful!

[@chaitanyakelaskar5106]

gud information...

[@rajasdataengineering7585]

Thanks Chaitanya

[@Kohlian]

Thanks for your clear and concise, informative videos.
Can you please provide us the text and csv files which you've used in the video.
Thank you

[@sandeepkundu8912]

quite good explanation . wants to see more coverage on others topics

[@rajasdataengineering7585]

Thanks Sandeep. Sure, will post more videos on other topics

[@venkatraomm1017]

Thanks for your detailed video right from the basic. can you please explain for joining multiple data frames

[@shanhuahuang3063]

I have a question, if you create a table with int type and a sting comes, what could you do?copy into?

[@ashamaheshk7306]

Can you please tell what's outer apply in databricks sql

[@akshatapatil4874]

video is pretty helpful, please could you share the notebooks used for demo it will be helpful as well

[@jagadeeswaran330]

Nice!

[@rajasdataengineering7585]

Thank you! Cheers!

[@jyothim2266]

thank you so much Sir, great work, well explained. Can you tell me how to retrieve only the columns of left table with 1 associated column from right, eg in your case the result df should have all columns of employeedf and dept name of departmentdf?

[@rajasdataengineering7585]

You can do something like this - df1.join(df2, df1.key=df2.key).select(df1["*"],df2.column1,df2.column2)

[@srini-data-engineering]

🙏

[@rajasdataengineering7585]

👍

[@maheshkurva6885]

Explained clearly along with can u share the notes.,please

[@battulasuresh9306]

What if we need one column deptName from right table
Not all columns from right table

[@rajasdataengineering7585]

Within select function, use * to select all columns from left table and only df2.colname from right table

[@jalindarvapre3760]

Hello sir, How to join two Dataframe with different schema??

[@rajasdataengineering7585]

Hi, we just need a common key between 2 tables. Schema can be different, no problem

[@tanushreenagar3116]

Nice

[@rajasdataengineering7585]

Thanks

[@Umerkhange]

How we can specify compound join Condition. For Example, a table joins with other table based on two keys

[@rajasdataengineering7585]

& operator to be used for multiple joining conditions
df1.join(df2, (df1.key1 == df2.key1) & (df1.key2 == df2.key2))

[@bharatsehgal5767]

very useful

[@rajasdataengineering7585]

Thank you

[@vigneshgaming6286]

How to join if you have more than 2 data frames with in same statement

[@rajasdataengineering7585]

You can use df.join().join() etc.
Basically use join multiple times

[@rajeshwarreddyracha4655]

Please provide code and datasets as well in each video

[@birendrarawat7778]

Explained each concept of Databrick in detail and easy to understand for the newcomers, if you can share the Dataset used for the demo it would be great and time-saving

[@rajasdataengineering7585]

Thank you. Sure, will share dataset for your reference

[@abhinavsingh1173]

Your course it best. But problem with you course is that you are not attching the github link for your sample data and code. Irequest you as your audience please do this. Thanks

[@joyo2122]

The default is inner

[@battulasuresh9306]

Please prove the syntaxe Raja sir

[@rajasdataengineering7585]

Sure will add syntax

[@Kshiru_princess]

Font is not properly visible

[@rajasdataengineering7585]

Sure, will check and fix it

[@TK-ht9ky]

Hello Raja,unable to see the commands clearly...this is causing so much effort to understand.

[@rajasdataengineering7585]

Apologies, in later videos it's sorted out

[@sowjanyagvs7780]

screeen isnt clear