🚩𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻 𝗔 𝗗𝗲𝗲𝗽 𝗗𝗶𝘃𝗲 𝗶𝗻𝘁𝗼 𝗤𝘂𝗲𝗿𝘆 𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗘𝗻𝗴𝗶𝗻𝗲 𝗼𝗳 𝗦𝗽𝗮𝗿𝗸 𝗦𝗤𝗟 🚀𝗨𝗻𝗿𝗲𝘀𝗼𝗹𝘃𝗲𝗱 𝗟𝗼𝗴𝗶𝗰𝗮𝗹 𝗣𝗹𝗮𝗻 👉🏻Syntactic (syntax check) 👉🏻Symantic verification (object should be proven) 👉🏻Parsing activity should be checked. 🚀𝗦𝗰𝗵𝗲𝗺𝗮/𝗠𝗲𝘁𝗮𝗱𝗮𝘁𝗮 𝗖𝗮𝘁𝗮𝗹𝗼𝗴𝘂𝗲 👉🏻Datatype, schema details should be taken. 🚀𝗟𝗼𝗴𝗶𝗰𝗮𝗹 𝗣𝗹𝗮𝗻 👉🏻Catalyst optimizer written in Scala in the form of a tree. 👉🏻Each tree will contain nodes. Each node has a child node. Each node contains rules based on the form of a tree. 👉🏻Each node has a role-based optimization there. 👉🏻Number of logical plans to be executed 🚀𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗲𝗱 𝗟𝗼𝗴𝗶𝗰𝗮𝗹 𝗣𝗹𝗮𝗻 👉🏻Related activities to be grouped as a micro batch 👉🏻Predicate pushdown 👉🏻Projection pushdown 👉🏻Rearrange the filter 👉🏻Conversion of decimal operations to integer operations 👉🏻Replacement of some regex expressions by Java's methods 👉🏻If-else clause simplif...