DylanGuedes commented on issue #24881: [SPARK-23160][SQL][TEST] Port window.sql URL: https://github.com/apache/spark/pull/24881#issuecomment-514268697 @dongjoon-hyun I've been trying to make filtering works for a while but without success. For instance, in the following snippet ``` SELECT sum(salary), row_number() OVER (ORDER BY depname), sum( sum(salary) FILTER (WHERE enroll_date > '2007-01-01') ) FROM empsalary GROUP BY depname; ``` I already tried moving the filter to different places and using different syntaxes (I even used lambda), but none of them work for this case. Since I don't know If it is just me not knowing the API well enough or if Spark has any limitation in this side, I didn't created a JIRA for cases like this. What do you think?
---------------------------------------------------------------- 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]
