Support Questions

Find answers, ask questions, and share your expertise

Difference between two Hive "Cost Based Optimizer" settings in Ambari?

Explorer

Hello,

I'm working with a customer who is running Ambari 2.2.0.0 and HDP 2.3.4.0. We are wondering, what is the difference between these two Hive CBO settings:

Hive / Configs / Settings / Optimization / "Enable Cost Based Optimizer"

Hive / Configs / Advanced / Advanced hive-env / "Cost Based Optimizer"

Any ideas?

3 REPLIES 3

Master Collaborator

The first one as the name suggests is to enable/disable cost based optimizer, translates to setting the property hive.cbo.enable=[true|false]. I don't see the other one, can you mouse over to see the corresponding property value or attach a screenshot.

Explorer

Hi @Deepesh - mouse over doesn't provide any information. This is in Ambari under Advanced hive-env, so it is not a custom value. I see this in both of the customer's clusters, plus in a cleanly installed lab environment matching their versions. I also don't see any evidence of this setting in any of the hive-env.sh files. Any thoughts?

Master Collaborator

Can you attach a screenshot?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.