[ 
https://issues.apache.org/jira/browse/FLINK-13562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kurt Young updated FLINK-13562:
-------------------------------
    Fix Version/s: 1.10.0

> throws exception when FlinkRelMdColumnInterval meets two stage stream group 
> aggregate
> -------------------------------------------------------------------------------------
>
>                 Key: FLINK-13562
>                 URL: https://issues.apache.org/jira/browse/FLINK-13562
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Planner
>            Reporter: godfrey he
>            Assignee: godfrey he
>            Priority: Critical
>              Labels: pull-request-available
>             Fix For: 1.10.0, 1.9.1
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> test case:
> {code:scala}
>   @Test
>   def testTwoDistinctAggregateWithNonDistinctAgg(): Unit = {
>     util.addTableSource[(Int, Long, String)]("MyTable", 'a, 'b, 'c)
>     util.verifyPlan("SELECT c, SUM(DISTINCT a), SUM(a), COUNT(DISTINCT b) 
> FROM MyTable GROUP BY c")
>   }
> {code}
> org.apache.flink.table.api.TableException: Sum aggregate function does not 
> support type: ''VARCHAR''.
> Please re-check the data type.
>       at 
> org.apache.flink.table.planner.plan.utils.AggFunctionFactory.createSumAggFunction(AggFunctionFactory.scala:191)
>       at 
> org.apache.flink.table.planner.plan.utils.AggFunctionFactory.createAggFunction(AggFunctionFactory.scala:74)
>       at 
> org.apache.flink.table.planner.plan.utils.AggregateUtil$$anonfun$9.apply(AggregateUtil.scala:285)
>       at 
> org.apache.flink.table.planner.plan.utils.AggregateUtil$$anonfun$9.apply(AggregateUtil.scala:279)
>       at 
> scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
>       at 
> scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
>       at 
> scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)
>       at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:48)
>       at scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
>       at scala.collection.AbstractTraversable.map(Traversable.scala:104)
>       at 
> org.apache.flink.table.planner.plan.utils.AggregateUtil$.transformToAggregateInfoList(AggregateUtil.scala:279)
>       at 
> org.apache.flink.table.planner.plan.utils.AggregateUtil$.getOutputIndexToAggCallIndexMap(AggregateUtil.scala:154)
>       at 
> org.apache.flink.table.planner.plan.metadata.FlinkRelMdColumnInterval.getAggCallIndexInLocalAgg$1(FlinkRelMdColumnInterval.scala:504)
>       at 
> org.apache.flink.table.planner.plan.metadata.FlinkRelMdColumnInterval.estimateColumnIntervalOfAggregate(FlinkRelMdColumnInterval.scala:526)
>       at 
> org.apache.flink.table.planner.plan.metadata.FlinkRelMdColumnInterval.getColumnInterval(FlinkRelMdColumnInterval.scala:417)
>       at GeneratedMetadataHandler_ColumnInterval.getColumnInterval_$(Unknown 
> Source)
>       at GeneratedMetadataHandler_ColumnInterval.getColumnInterval(Unknown 
> Source)
>       at 
> org.apache.flink.table.planner.plan.metadata.FlinkRelMetadataQuery.getColumnInterval(FlinkRelMetadataQuery.java:122)



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Reply via email to