Very cool. What is the non strict option for?
Thanks,
Ranjith
From: Ashish Thusoo
To:
Sent: Mon May 02 16:00:39 2011
Subject: Re: Cross join in Hive.
you could probably just say (1 = 1) in the on clause for the join.
set hive.mapred.mode=nonstrict;
select
first table to be equal to the same column in the other table.
Thanks,
Ranjith
From: Raghunath, Ranjith
mailto:ranjith.raghuna...@usaa.com>>
To: 'user@hive.apache.org'
mailto:user@hive.apache.org>>
Sent: Mon May 02 00:21:57 2011
Subject: Re:
11
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
To: user@hive.apache.org
Sent: S
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
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 ob
