Is there a rule based optimizer in Hive ?

[#1]

Hive is using Apache Calcite's cost based optimizer (CBO).. similarly i am wondering if there is a rule based optimizer for hive ?

[#2]

@Prabhu M

we have CBO for hive as well. here is the link https://cwiki.apache.org/confluence/display/Hive/Cost-based+optimization+in+Hive

[#3]

@Divakar Annapureddy thanks for the response., i was wondering if hive has a Rule Based Optimizer (RBO) ?

[#4 · Accepted solution]

@Prabhu M 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

http://www.slideshare.net/julianhyde/w-435phyde-3

[#5]

thx this helps