You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by pseudo oduesp <ps...@gmail.com> on 2016/03/24 13:12:16 UTC
multiple tables for join
hi , i spent two months of my times to make 10 joins whith folowin tables :
1go tbal1
3go table 2
500mo table 3
400 mo table 4
20 mo table 5
100 mo table 6
30 mo table 7
40 mo table 8
700 mo table 9
800 mo table 10
i use hivecontext.sql("select * from table1 left join table 2 on
c1==c2")......
table 1 with 2000 columns
table 2 with 18500 columns
tables 3 with 10 columns
all other tbales under 10 columns
please help me .
Re: multiple tables for join
Posted by Bijay Pathak <bi...@cloudwick.com>.
Hi,
Can you elaborate what's the issues you are facing, I am doing the similar
kind of join so I may be able to provide you with some suggestions and
pointers.
Thanks,
BIjay
On Thu, Mar 24, 2016 at 5:12 AM, pseudo oduesp <ps...@gmail.com>
wrote:
> hi , i spent two months of my times to make 10 joins whith folowin tables :
>
> 1go tbal1
> 3go table 2
> 500mo table 3
> 400 mo table 4
> 20 mo table 5
> 100 mo table 6
> 30 mo table 7
> 40 mo table 8
> 700 mo table 9
> 800 mo table 10
>
> i use hivecontext.sql("select * from table1 left join table 2 on
> c1==c2")......
>
> table 1 with 2000 columns
> table 2 with 18500 columns
> tables 3 with 10 columns
> all other tbales under 10 columns
>
> please help me .
>