You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Ashok Kumar <as...@yahoo.com> on 2016/02/03 20:45:17 UTC

Hive optimizer

  Hi,
Is Hive optimizer a cost based Optimizer (CBO) or a rule based optimizer (CBO) or none of them.
thanks

Re: Hive optimizer

Posted by Ashok Kumar <as...@yahoo.com>.
Thank you for the link. 

    On Thursday, 4 February 2016, 8:07, Lefty Leverenz <le...@gmail.com> wrote:
 

 You can find Hive CBO information in Cost Based Optimizer in Hive.
-- Lefty

On Wed, Feb 3, 2016 at 11:48 AM, John Pullokkaran <jp...@hortonworks.com> wrote:

Its both.Some of the optimizations are rule based and some are cost based.
John
From: Ashok Kumar <as...@yahoo.com>
Reply-To: "user@hive.apache.org" <us...@hive.apache.org>, Ashok Kumar <as...@yahoo.com>
Date: Wednesday, February 3, 2016 at 11:45 AM
To: User <us...@hive.apache.org>
Subject: Hive optimizer

  Hi,
Is Hive optimizer a cost based Optimizer (CBO) or a rule based optimizer (CBO) or none of them.
thanks

Re: Hive optimizer

Posted by Lefty Leverenz <le...@gmail.com>.
You can find Hive CBO information in Cost Based Optimizer in Hive
<https://cwiki.apache.org/confluence/display/Hive/Cost-based+optimization+in+Hive>
.

-- Lefty


On Wed, Feb 3, 2016 at 11:48 AM, John Pullokkaran <
jpullokkaran@hortonworks.com> wrote:

> Its both.
> Some of the optimizations are rule based and some are cost based.
>
> John
>
> From: Ashok Kumar <as...@yahoo.com>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>, Ashok Kumar <
> ashok34668@yahoo.com>
> Date: Wednesday, February 3, 2016 at 11:45 AM
> To: User <us...@hive.apache.org>
> Subject: Hive optimizer
>
>   Hi,
>
> Is Hive optimizer a cost based Optimizer (CBO) or a rule based optimizer
> (CBO) or none of them.
>
> thanks
>

Re: Hive optimizer

Posted by John Pullokkaran <jp...@hortonworks.com>.
Its both.
Some of the optimizations are rule based and some are cost based.

John

From: Ashok Kumar <as...@yahoo.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, Ashok Kumar <as...@yahoo.com>>
Date: Wednesday, February 3, 2016 at 11:45 AM
To: User <us...@hive.apache.org>>
Subject: Hive optimizer

  Hi,

Is Hive optimizer a cost based Optimizer (CBO) or a rule based optimizer (CBO) or none of them.

thanks