Join ordering is not yet part of the Hive optimizer. There is integration work
being done with the Optiq framework that will address this, but it is not
complete yet. Hopefully at least an initial integration will be available in
the next Hive release.
Alan.
On May 2, 2014, at 5:36 AM,
Hi,
If we have one big table joining with a small table and MAPJOIN hint is
specified on the Smaller table, still the ordering will be required?
We can always forcefully set the auto convert join property to false and enable
mapjoin hints.
Please let me know if I am off base on this topic.
