[GitHub] [incubator-doris] EmmyMiao87 commented on issue #2095: 【predicate push down】When there is an operation, predicate push down fails

[GitBox <gi...@apache.org>]

EmmyMiao87 commented on issue #2095: 【predicate push down】When there is an operation, predicate push down fails
URL: https://github.com/apache/incubator-doris/issues/2095#issuecomment-547728169
 
 
   Answer1: 
   The predicate in query 1 `s.k1 + s.k2 > 10 ` could not be pushed down. The slot k2 of predicate is not a group by slot. 
   The predicate in query 2 `s.k1 + s.k2 > 10 ` do not need to be pushed down. The predicate in where is in front of the window function according to sql grammar.
   
   Answer2:
   Only the predicate which slot is related to group by could be push down. 
   For the query1: the group by slot is k3 in window function. So the predicates `s2.k3 > 8` and `s.k3 > 1` could be pushed down to the tuple named ss.
   For the query2: the group by slot is k1 in window function. So the predicate `s2.k1 > 10` could be pushed down to the tuple hamed ss while the predicates `s2.k3 > 8` and `s.k3 > 1` belongs to the tuple named s
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org