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

[#1]

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

[#2 · Accepted solution]

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

set hive.cbo.enable=false;

[#3]

Thank you!