Re: about broadcast join of base table in spark sql

2017-07-02 Thread Yong Zhang
t: Friday, June 30, 2017 6:57 AM To: d...@spark.org<mailto:d...@spark.org>; user@spark.apache.org<mailto:user@spark.apache.org>; paleyl Subject: Re: about broadcast join of base table in spark sql Hello. If you want to allow broadcast join with larger broadcasts you can set spark

Re: about broadcast join of base table in spark sql

2017-07-02 Thread paleyl
t; spark.apache.org >> Computes the numeric value of the first character of the string column, >> and returns the result as a int column. >> >> >> >> >> ---------- >> *From:* Bryan Jeffrey >> *Sent:* Friday, June 30, 2017 6:57

Re: about broadcast join of base table in spark sql

2017-07-01 Thread Xiaoye Sun
the string column, > and returns the result as a int column. > > > > > -- > *From:* Bryan Jeffrey > *Sent:* Friday, June 30, 2017 6:57 AM > *To:* d...@spark.org; user@spark.apache.org; paleyl > *Subject:* Re: about broadcast join of base table in sp

Re: about broadcast join of base table in spark sql

2017-07-01 Thread Paley Louie
; returns the result as a int column. > > > > > From: Bryan Jeffrey > Sent: Friday, June 30, 2017 6:57 AM > To: d...@spark.org; user@spark.apache.org; paleyl > Subject: Re: about broadcast join of base table in spark sql > > Hello. > > If you want to a

Re: about broadcast join of base table in spark sql

2017-07-01 Thread Paley Louie
> > From: paleyl > Sent: Wednesday, June 28, 10:42 PM > Subject: about broadcast join of base table in spark sql > To: d...@spark.org, user@spark.apache.org > > > Hi All, > > > Recently I meet a problem in broadcast join: I want to left join table A and >

Re: about broadcast join of base table in spark sql

2017-06-30 Thread Yong Zhang
Friday, June 30, 2017 6:57 AM To: d...@spark.org; user@spark.apache.org; paleyl Subject: Re: about broadcast join of base table in spark sql Hello. If you want to allow broadcast join with larger broadcasts you can set spark.sql.autoBroadcastJoinThreshold to a higher value. This will cause the p

Re: about broadcast join of base table in spark sql

2017-06-30 Thread Bryan Jeffrey
eyl Sent: Wednesday, June 28, 10:42 PM Subject: about broadcast join of base table in spark sql To: d...@spark.org, user@spark.apache.org Hi All, Recently I meet a problem in broadcast join: I want to left join table A and B, A is the smaller one and the left table, so I wrote  A =

Fwd: about broadcast join of base table in spark sql

2017-06-29 Thread paleyl
Hi All, Recently I meet a problem in broadcast join: I want to left join table A and B, A is the smaller one and the left table, so I wrote A = A.join(B,A("key1") === B("key2"),"left") but I found that A is not broadcast out, as the shuffle size is still very large. I guess this is a designed mech

about broadcast join of base table in spark sql

2017-06-28 Thread paleyl
Hi All, Recently I meet a problem in broadcast join: I want to left join table A and B, A is the smaller one and the left table, so I wrote A = A.join(B,A("key1") === B("key2"),"left") but I found that A is not broadcast out, as the shuffle size is still very large. I guess this is a designed mech