Forgot to mention....the condition for the inner join should be the column set to 1 in the first table to be equal to the same column in the other table.
Thanks, Ranjith ________________________________ From: Raghunath, Ranjith <ranjith.raghuna...@usaa.com> To: 'user@hive.apache.org' <user@hive.apache.org> Sent: Mon May 02 00:21:57 2011 Subject: Re: Cross join in Hive. I haven't tested this out but plan to in 6 hours. Add an extra column and set it to 1 in both tables. Perform an inner join between the two tables. Thanks, Ranjith ________________________________ From: Abhinov Agarwal <abhinov.agar...@gmail.com> To: user@hive.apache.org <user@hive.apache.org> Sent: Sun May 01 22:50:34 2011 Subject: Cross join in Hive. Hi, I need to take a cross join of a big table with itself, is it possible to do it using Hive ? E.g. Set : 1 2 3 Result : 1,1 1,2 1,3 2,1 2,2 2,3 3,1 3,2 3,3 This would also do : 1,2 1,3 2,3 In fact the second one is what I want. I know cross join is not supported in Hive, any other way to obtain this. Regards, Abhinav Agarwal
