Re: How does predicate push down really help?

2016-11-17 Thread kant kodali
istic is that in most cases the time >> saved on the join would be much more than any extra time taken by the >> filter itself. >> >> >> >> BTW. You can see the differences between the original plan and the >> optimized plan by calling explain(true) on the dataf

Re: How does predicate push down really help?

2016-11-17 Thread kant kodali
t was physically > run. > > > > Assaf. > > > > *From:* kant kodali [mailto:kanth...@gmail.com] > *Sent:* Thursday, November 17, 2016 9:50 AM > *To:* Mendelson, Assaf > *Cc:* user @spark > *Subject:* Re: How does predicate push down really help? > > >

RE: How does predicate push down really help?

2016-11-16 Thread Mendelson, Assaf
: kant kodali [mailto:kanth...@gmail.com] Sent: Thursday, November 17, 2016 9:50 AM To: Mendelson, Assaf Cc: user @spark Subject: Re: How does predicate push down really help? Hi Assaf, I am still trying to understand the merits of predicate push down from the examples you pointed out. Example 1

Re: How does predicate push down really help?

2016-11-16 Thread Ashic Mahtab
ion than a join. Assaf. From: kant kodali [mailto:kanth...@gmail.com<mailto:kanth...@gmail.com>] Sent: Thursday, November 17, 2016 8:03 AM To: user @spark Subject: How does predicate push down really help? How does predicate push down really help? in the following cases val df1 = spark.sql

Re: How does predicate push down really help?

2016-11-16 Thread kant kodali
n a join. > > > > Assaf. > > > > *From:* kant kodali [mailto:kanth...@gmail.com] > *Sent:* Thursday, November 17, 2016 8:03 AM > *To:* user @spark > *Subject:* How does predicate push down really help? > > > > How does predicate push down really help? in t

RE: How does predicate push down really help?

2016-11-16 Thread Mendelson, Assaf
the join would probably make everything faster as filter is a faster operation than a join. Assaf. From: kant kodali [mailto:kanth...@gmail.com] Sent: Thursday, November 17, 2016 8:03 AM To: user @spark Subject: How does predicate push down really help? How does predicate push down really help

How does predicate push down really help?

2016-11-16 Thread kant kodali
How does predicate push down really help? in the following cases val df1 = spark.sql("select * from users where age > 30") vs val df1 = spark.sql("select * from users") df.filter("age > 30")