https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Explain-Plan/m-p/229549#M64126 <P> Hi <A rel="user" href="https://community.cloudera.com/users/16142/rdevprasad1.html" nodeid="16142">@Ramesh Prasad</A>,</P><P>You may want to start looking at <A href="https://calcite.apache.org/">Apache Calcite</A>. Calcite is the primary CBO behind Hive execution. </P> Sun, 02 Jul 2017 20:25:51 GMT SQLShaw 2017-07-02T20:25:51Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Explain-Plan/m-p/229548#M64125 <P>I am trying to understand how the EXPLAIN PLAN statement generates the plan for a given query.</P><P>I have checked out the code from apache/github.</P><P>I am unable to find any document/link that atleast points me where do I start looking in the code or atleast what steps does the explain plan perform to arrive at the query plan.</P><P>Any pointers will be helpful.</P> Sat, 01 Jul 2017 03:53:09 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Explain-Plan/m-p/229548#M64125 rdevprasad1 2017-07-01T03:53:09Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Explain-Plan/m-p/229549#M64126 <P> Hi <A rel="user" href="https://community.cloudera.com/users/16142/rdevprasad1.html" nodeid="16142">@Ramesh Prasad</A>,</P><P>You may want to start looking at <A href="https://calcite.apache.org/">Apache Calcite</A>. Calcite is the primary CBO behind Hive execution. </P> Sun, 02 Jul 2017 20:25:51 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Explain-Plan/m-p/229549#M64126 SQLShaw 2017-07-02T20:25:51Z