[ https://issues.apache.org/jira/browse/BEAM-8317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16938980#comment-16938980 ]
Brian Hulette commented on BEAM-8317: ------------------------------------- Discussed this with [~apilloud]. He said that probably the appropriate fix is to make [BeamBasicAggregationRule|https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/java/org/apache/beam/sdk/extensions/sql/impl/rule/BeamBasicAggregationRule.java] accept any thing that's _not_ a projection, rather than the current approach that just accepts table scans. Basically it should complement [BeamAggregationRule|https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/java/org/apache/beam/sdk/extensions/sql/impl/rule/BeamAggregationRule.java] which accepts _only_ projections. > SqlTransform doesn't support aggregation over a filter node > ----------------------------------------------------------- > > Key: BEAM-8317 > URL: https://issues.apache.org/jira/browse/BEAM-8317 > Project: Beam > Issue Type: Bug > Components: dsl-sql > Affects Versions: 2.15.0 > Reporter: Brian Hulette > Priority: Major > Time Spent: 10m > Remaining Estimate: 0h > > For example, the following query fails to translate to a physical plan: > SELECT SUM(f_intValue) FROM PCOLLECTION WHERE f_intValue < 5 GROUP BY > f_intGroupingKey -- This message was sent by Atlassian Jira (v8.3.4#803005)