Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Is there a rule based optimizer in Hive ?

Solved Go to solution

Is there a rule based optimizer in Hive ?

Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Is there a rule based optimizer in Hive ?

Mentor

@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

4 REPLIES 4

Re: Is there a rule based optimizer in Hive ?

Re: Is there a rule based optimizer in Hive ?

Contributor

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

Re: Is there a rule based optimizer in Hive ?

Mentor

@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

Highlighted

Re: Is there a rule based optimizer in Hive ?

Contributor

thx this helps