Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive : Query not optimized by CBO

Highlighted

Hive : Query not optimized by CBO

Contributor

I am running a explain plan on a query It says "Plan not optimized by CBO" When I checked the logs it says

using 2016-03-14 00:37:12,082 INFO [HiveServer2-Handler-Pool: Thread-41]: parse.BaseSemanticAnalyzer (CalcitePlanner.java:canCBOHandleAst(392)) - Not invoking CBO because the statement has too few joins

Any idea what does this mean?

3 REPLIES 3
Highlighted

Re: Hive : Query not optimized by CBO

Mentor
Highlighted

Re: Hive : Query not optimized by CBO

Contributor

Thanks... The answer does not say what may be the reason. Do you have any idea?

Highlighted

Re: Hive : Query not optimized by CBO

Mentor

@Amit Sharma run the analyze command on each partition in your table.

Don't have an account?
Coming from Hortonworks? Activate your account here