question Can Cost Based Optimization be configured per session or query in Hive? in Archives of Support Questions (Read Only)

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

dmcarba — Fri, 16 Sep 2022 11:31:51 GMT

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

deepesh1 — Sat, 29 Apr 2017 04:36:06 GMT

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

set hive.cbo.enable=false;

dmcarba — Wed, 03 May 2017 15:22:05 GMT

Thank you!