Cross join in Hive.

[Abhinov Agarwal]

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