Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
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

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
2 REPLIES 2

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
New Contributor

Thank you!