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?
Yes, CBO is a client side property. You can disable at the beginning of query by specifying:
View solution in original post