Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Can Cost Based Optimization be configured per session or query in Hive?

New Contributor

Hello

I was wondering if we can use different settings for different types of queries in Hive regarding the cost based optimization.

For light interactive queries, CBO can be slower because the time of calculating the execution plan may be longer than the execution time itself.

For complex analytical queries is better to enable CBO.

Can CBO be enabled/disabled per query o Hive session basis?

Thanks

1 ACCEPTED SOLUTION

Master Collaborator

Yes, CBO is a client side property. You can disable at the beginning of query by specifying:

set hive.cbo.enable=false;

View solution in original post

2 REPLIES 2

Master Collaborator

Yes, CBO is a client side property. You can disable at the beginning of query by specifying:

set hive.cbo.enable=false;

New Contributor

Thank you!