https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152934#M52970 <P><A rel="user" href="https://community.cloudera.com/users/15223/pmohan.html" nodeid="15223">@Prabhu M</A> Prior to Hive 0.13, Hive relied on rule-based optimization and in Hive 0.14 we introduced CBO with Calcite. Please see slide 5</P><P><A href="http://www.slideshare.net/julianhyde/w-435phyde-3" target="_blank">http://www.slideshare.net/julianhyde/w-435phyde-3</A></P> Tue, 31 Jan 2017 02:21:20 GMT aervits 2017-01-31T02:21:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152931#M52967 <P>Hive is using Apache Calcite's cost based optimizer (CBO).. similarly i am wondering if there is a rule based optimizer for hive ?</P> Fri, 16 Sep 2022 10:59:09 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152931#M52967 pmohan 2022-09-16T10:59:09Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152932#M52968 <A rel="user" href="https://community.cloudera.com/users/15223/pmohan.html" nodeid="15223">@Prabhu M</A><P>we have CBO for hive as well. here is the link <A href="https://cwiki.apache.org/confluence/display/Hive/Cost-based+optimization+in+Hive" target="_blank">https://cwiki.apache.org/confluence/display/Hive/Cost-based+optimization+in+Hive</A></P> Tue, 31 Jan 2017 01:40:53 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152932#M52968 divakarreddy_a 2017-01-31T01:40:53Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152933#M52969 <P><A rel="user" href="https://community.cloudera.com/users/2348/divakarreddya.html" nodeid="2348">@Divakar Annapureddy</A> thanks for the response., i was wondering if hive has a Rule Based Optimizer (RBO) ?</P> Tue, 31 Jan 2017 01:43:14 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152933#M52969 pmohan 2017-01-31T01:43:14Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152934#M52970 <P><A rel="user" href="https://community.cloudera.com/users/15223/pmohan.html" nodeid="15223">@Prabhu M</A> Prior to Hive 0.13, Hive relied on rule-based optimization and in Hive 0.14 we introduced CBO with Calcite. Please see slide 5</P><P><A href="http://www.slideshare.net/julianhyde/w-435phyde-3" target="_blank">http://www.slideshare.net/julianhyde/w-435phyde-3</A></P> Tue, 31 Jan 2017 02:21:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152934#M52970 aervits 2017-01-31T02:21:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152935#M52971 <P>thx this helps</P> Tue, 31 Jan 2017 02:33:59 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Is-there-a-rule-based-optimizer-in-Hive/m-p/152935#M52971 pmohan 2017-01-31T02:33:59Z