Gourav, I wish that was case, but I have done a select count on each of the two tables individually and they return back different number of rows:
dps.registerTempTable("dps_pin_promo_lt") swig.registerTempTable("swig_pin_promo_lt") dps.count() RESULT: 42632 swig.count() RESULT: 42034 On Mon, May 2, 2016 at 11:55 AM, Gourav Sengupta <gourav.sengu...@gmail.com> wrote: > This shows that both the tables have matching records and no mismatches. > Therefore obviously you have the same results irrespective of whether you > use right or left join. > > I think that there is no problem here, unless I am missing something. > > Regards, > Gourav > > On Mon, May 2, 2016 at 7:48 PM, kpeng1 <kpe...@gmail.com> wrote: > >> Also, the results of the inner query produced the same results: >> sqlContext.sql("SELECT s.date AS edate , s.account AS s_acc , d.account >> AS >> d_acc , s.ad as s_ad , d.ad as d_ad , s.spend AS s_spend , >> d.spend_in_dollar AS d_spend FROM swig_pin_promo_lt s INNER JOIN >> dps_pin_promo_lt d ON (s.date = d.date AND s.account = d.account AND >> s.ad = >> d.ad) WHERE s.date >= '2016-01-03' AND d.date >= >> '2016-01-03'").count() >> RESULT:23747 >> >> >> >> -- >> View this message in context: >> http://apache-spark-user-list.1001560.n3.nabble.com/Weird-results-with-Spark-SQL-Outer-joins-tp26861p26863.html >> Sent from the Apache Spark User List mailing list archive at Nabble.com. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >> For additional commands, e-mail: user-h...@spark.apache.org >> >> >