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
> Regards,
> Bejoy KS
>
> ------
> *From:* Vidhya Venkataraman
> *To:* user@hive.apache.org
> *Sent:* Friday, July 27, 2012 10:21 PM
> *Subject:* Create external table like.
>
> Hi
> I am using Hive 0.7.x on my dev machine (yeah we will be upgr
Hi
I am using Hive 0.7.x on my dev machine (yeah we will be upgrading soon
:) )
I used the statement indicated in the subject to create an external table:
*create external table ext_sample_v1 like sample_v1 location
'/hive/warehouse/sample_v1/';*
*
*
Since sample_v1 had partitions, I added so
