6.8 Catalyst Optimizer | Spark Interview questions

As part of our spark Interview question Series, we want to help you prepare for your spark interviews. We will discuss various topics about spark like Lineage, reduceby vs group by, yarn client mode vs yarn cluster mode etc.
As part of this video we are covering what is spark catalyst optimizer. Catalyst optimizer is very important in dataframe and datasets
Please subscribe to our channel.
Here is link to other spark interview questions
• 2.5 Transformations Vs...
Here is link to other Hadoop interview questions
• 1.1 Why Spark is Faste...

Пікірлер: 59

  • @prabhakaransubramaniyan6538
    @prabhakaransubramaniyan65385 жыл бұрын

    i have came across many video for catalyst optimizer. i found this is the best and well explained:)

  • @vishwanathh9848
    @vishwanathh98484 жыл бұрын

    You are precisely choosing the topics and very very accurately explaining them. Please keep it up.

  • @DataSavvy

    @DataSavvy

    3 жыл бұрын

    Thanks Vishwanath

  • @souravsinha5330
    @souravsinha5330 Жыл бұрын

    Clearly explained thanks

  • @DataSavvy

    @DataSavvy

    Жыл бұрын

    Glad it helped

  • @MrManish389
    @MrManish3893 жыл бұрын

    Your video is very nice and specific. Apart from this sir, i want to add some thing... We will get many physical plan only when cost based optimization is enabled.

  • @DataSavvy

    @DataSavvy

    3 жыл бұрын

    You are Right... Thanks for adding information

  • @pandurangbhadange25
    @pandurangbhadange254 ай бұрын

    1. Parsing - create an abstract syntax tree. 2. Analysis - Catalyst analyzer performs semantic analysis on tree. This includes resolving references, type checking, and creating a logical plan. The analyzer also infers data types. 3. Logical optimisation - Rewrite the plan into a more efficient form. This includes predicate pushdown, constant folding. 4. Physical planning - Spark stages and tasks created. 5. Physical optimisation - optimized further by considering factors like data partitioning, join order, and choosing the most efficient physical operators 6.Code Generation - generates Java bytecode for the optimized physical plan

  • @vinodmani3900
    @vinodmani39005 жыл бұрын

    Thanks for the detailed explanation. However I am slightly confused now after watching previous video. There you mentioned logical plan , dag , execution plan is the pattern. Could you please connect that in this detailed context. Is DAG is part of this catalyst optimizer?

  • @paroolsingh597
    @paroolsingh5973 жыл бұрын

    Hi sir, great video! Could you please let us know what is whole stage code generation ? Is it the RDD code which is generated after picking up the most optimized plan ?

  • @ankursrivastava2112
    @ankursrivastava21126 жыл бұрын

    Thanks for your spark explanation. Can you please make a video on serialization, deserialization? thanku

  • @arundhingra4536
    @arundhingra45365 жыл бұрын

    Good explaining of optimizer

  • @jubinsharma8441
    @jubinsharma84412 жыл бұрын

    Please try keeping volume at a higher pitch, ur videos are very educative elaborative and helpful. Please try improving the sound as well. Sometimes it is very difficult to understand and I close the video.

  • @sureshu5671
    @sureshu56713 жыл бұрын

    very good explanation

  • @telugutravellerraj
    @telugutravellerraj5 жыл бұрын

    Good info. Can you publish a video showing dataframe vs dataset difference with an example.

  • @DataSavvy

    @DataSavvy

    5 жыл бұрын

    kzread.info/dash/bejne/jJ2mxKtqY5ibcps.html

  • @31bikashdash
    @31bikashdash Жыл бұрын

    great

  • @mtamitsharma
    @mtamitsharma5 жыл бұрын

    Hi Sir, Thanks for sharing valuable spark interview questions with us. could you please tell us the difference between Tungsten and Catalyst optimizer? can we create more than one spark context for an application, I have confusion with the allowMultipleContext property while creating a spark context? Kindly share any information with us on this. Thanks

  • @rajeshwarreddyracha4655

    @rajeshwarreddyracha4655

    3 жыл бұрын

    Multiple spark contexts by setting up, Spark.driver.allowMultipleContexts to TRUE. Multiple spark contexts for single JVM is not recommended, since crashing of one spark context will affect other. Spark Context contains same ContextId, But Spark Session contains different Session id’s while creating new ones and all Spark sessions will share the same Context id.

  • @himanshusekharpaul476
    @himanshusekharpaul4766 жыл бұрын

    Add scenario based questions from Spark (Core , SQL , Streaming) . .. also add Questions for Scala

  • @DataSavvy

    @DataSavvy

    6 жыл бұрын

    Sure Hemanshu... Do u have any examples of scenario based questions? I will create video for that

  • @himanshusekharpaul476

    @himanshusekharpaul476

    6 жыл бұрын

    I don't have complet list of scenario . But it can be created ..Like . Let's say you got a file of 8 GB . How can you copy it to each executer memory . What it the meaning of add jar parameter in Spark- submit? What each parameter in Spark submit do internally? How you can do some customization with those parameter list ?? Etc

  • @koushikdas6840
    @koushikdas68404 жыл бұрын

    Great contents :)

  • @DataSavvy

    @DataSavvy

    4 жыл бұрын

    Thanks Kaushik

  • @MrVivekc
    @MrVivekc3 жыл бұрын

    also pls make a video on spark RDD vs df vs sparksql performance and which one outperforms other and in which case.

  • @DataSavvy

    @DataSavvy

    3 жыл бұрын

    This video will be helpful kzread.info/dash/bejne/jJ2mxKtqY5ibcps.html

  • @rajareddy47444
    @rajareddy474446 жыл бұрын

    Hi. Can you explain about Case classes

  • @DesireIsIrrelevant
    @DesireIsIrrelevant4 жыл бұрын

    Regardless of using any join in my code does optimizer converts it in (terms of physical plan) into most efficient join like you said map side/broadcast/hash join??

  • @DataSavvy

    @DataSavvy

    4 жыл бұрын

    yes... it does... wherever optimization is possible

  • @ankitamahadik2756
    @ankitamahadik27564 жыл бұрын

    Very nicely explained 👍

  • @DataSavvy

    @DataSavvy

    4 жыл бұрын

    Thank Ankita... I am happy that you liked it... Please share your suggestions, if any to improve content on this channel.

  • @DataSavvy

    @DataSavvy

    4 жыл бұрын

    Please subscribe to channel. It motivates to create more useful content for everyone.. Thanks :)

  • @shwetabalkawade3322
    @shwetabalkawade33222 жыл бұрын

    Great and helpful video but voice is low

  • @ashutoshranghar4113
    @ashutoshranghar41135 жыл бұрын

    REAL TIME SCENARIOSSS PLS

  • @snehaljadhav9905
    @snehaljadhav99053 жыл бұрын

    Is there any video on Spark optimization techniques ? I did not found so please help me with this. Thanks in advance.

  • @DataSavvy

    @DataSavvy

    3 жыл бұрын

    Are your looking for act specific technique?

  • @dilsha795
    @dilsha7955 жыл бұрын

    Could you please suggest a good spark tutorial?

  • @DataSavvy

    @DataSavvy

    5 жыл бұрын

    Bro, I thought my channel has good tutorial. :) Can you suggest what is missing here

  • @dilsha795

    @dilsha795

    5 жыл бұрын

    @@DataSavvy Your is channel is excellent on an interview point of view. I couldn't find proper tutorial that explains from basic level

  • @DataSavvy

    @DataSavvy

    5 жыл бұрын

    @@dilsha795 got it... :) Will start creating videos for tutorial point of view also

  • @SantoshSingh-ki8bx
    @SantoshSingh-ki8bx6 жыл бұрын

    would suggest before publishing it .plz check if it is audible or not

  • @DataSavvy

    @DataSavvy

    6 жыл бұрын

    Thanks Santosh for suggestion... I have been doing that... However as soon as I upload video on KZread, KZread decreases voice quality after processing video... In New videos I have used new microphone and changed format of video... There is some improvement in voice quality... Apologies for inconvenience

  • @DataSavvy

    @DataSavvy

    6 жыл бұрын

    Low audio is issue on mobiles majorly, I tested on laptop, it looks fine... If that helps

  • @MrVivekc
    @MrVivekc3 жыл бұрын

    logical plan is lineage and physical plan is DAG, pls confirm?

  • @DataSavvy

    @DataSavvy

    3 жыл бұрын

    Not Really...

  • @Step2learn
    @Step2learn3 жыл бұрын

    sound aa thaaan pesaan da

  • @user-fm4kz1ur1h
    @user-fm4kz1ur1h Жыл бұрын

    Volume very low sir

  • @rakeshdey1702
    @rakeshdey17024 жыл бұрын

    cost based optimizer and rule based optimizer eliminated catalyst from spark 2??

  • @DataSavvy

    @DataSavvy

    4 жыл бұрын

    That's a news... Let me check and get back

  • @rakeshdey1702

    @rakeshdey1702

    4 жыл бұрын

    @@DataSavvy Actually CBO is used to select most optimized execution plan.. so catalyst optimizer actually does from logical to execution plan. Before converting RDD, CBO actually selects most optimized execution plan. Let me know if you conclude same.. CBO comes in picture from spark 2.3 I think

  • @heenasaxena6118
    @heenasaxena61183 жыл бұрын

    Apki awaz bahut dheere hai.. Saabhi vedios mai.. Please make louder vedios. Content is awesum...

  • @DataSavvy

    @DataSavvy

    3 жыл бұрын

    Thanks Heena... I was very new jab maine ye sari video banai.. It was microphone issue.. unfortunately youtube does not give option to edit already uploaded videos... I have improved this in latest videos...

  • @heenasaxena6118

    @heenasaxena6118

    3 жыл бұрын

    @@DataSavvy I see all your vedios. Major problem I face in interview is in explaining project flow from end to end. Can you please make some vedio which teaches me how to explain project to interviewers.

  • @chaitanyag.8415
    @chaitanyag.84153 жыл бұрын

    please increase the audio.

  • @ashwenkumar
    @ashwenkumar5 жыл бұрын

    from your next video kindly speak louder

  • @bhavanatanwar1108
    @bhavanatanwar11083 жыл бұрын

    please improve audio..

  • @DataSavvy

    @DataSavvy

    3 жыл бұрын

    Hi Bhavana... I have improved this in New videos... Excuse me for inconvenience

  • @thanooj
    @thanooj3 жыл бұрын

    Would you speak a little louder, please.

  • @kishoregarimella7987
    @kishoregarimella79873 жыл бұрын

    Pathetic sound quality