Is there a difference between the following two join sub queries in Hive? A JOIN B ON (A.DUH1=B.DUH2) JOIN C ON (B.DUH2=C.DUH3)
vs. A JOIN B JOIN C ON (A.DUH1=B.DUH2) AND (B.DUH2=C.DUH3) ? And is it still necessary to keep the larger table at the very end? What if tables B and C are selection queries that obtain a very small set from table A? Thanks Vidhya
