Forgot to mentionthe 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
To: 'user@hive.apache.org'
Sent: Mon May 02 00:21:57 2011
Subject:
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: Sun May 01 22:50:34 2011
Subject: Cross join
Hi,
I am getting below error when I try to run the HIVE queries.
Any idea what may be going wrong? The query was working fine until I restarted
the HDFS & MapReduce services.
hive> select geo_name from its_geo_code ;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is s
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
The design goal of CapacityScheduler is maximizing the utilization of cluster
resources but it does not fairly allocate the share amongst the total number of
users present in the system.
The user limit states the number of concurrent users who can use the slots in
the queue. But then these lim
