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 .
>