Plan not optimized by CBO

Hi,

When i am trying to get the execution plan for a simple group by query it says “plannot optimized by CBO”. Buti have done the complete gather stats for this table (means columns , table). when i checked the description with formatted i could able to see all got analyzed but not sure why i am getting this?

also can anyone let me know where i can get the hive log in cloudxlab?

Thanx
Siva

@siva,

Please post your query & screenshot about that message.