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
