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 .