Spark SQL supports very basic join reordering optimization, based on the raw table data size, this was added couple major releases back.
And the “EXPLAIN EXTENDED query” command is a very informative tool to verify whether the optimization taking effect. From: Raajay [mailto:raaja...@gmail.com] Sent: Sunday, October 11, 2015 9:22 AM To: user@spark.apache.org Subject: Join Order Optimization Hello, Does Spark-SQL support join order optimization as of the 1.5.1 release ? From the release notes, I did not see support for this feature, but figured will ask the users-list to be sure. Thanks Raajay