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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
