Hive does look in to alternate join orders and pick the best plan that minimizes cost. It uses a greedy algorithm to enumerate plan space.
Thanks John From: Raajay <raaja...@gmail.com<mailto:raaja...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Thursday, June 25, 2015 at 2:30 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Subject: Cost based optimization Hello Everyone, A quick question on the cost-based optimization module in Hive. Does the latest version support query plan generation with alternate join orders ? Thanks Raajay
