[CALCITE-1833] User-defined aggregate functions with more than one parameter

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: 1.14.0
• Component/s: core
• Assignee: yuemeng
• Reporter: yuemeng
• Created: 08/Jun/17 12:48
• Updated: 02/Oct/17 14:31
• Resolved: 06/Jul/17 23:09

Description

Currently user-defined aggregate functions must have one parameter.

SqlAggFunction need new constructor to set paramTypes to allow user-defined aggregate function to have more than one parameter.

If a class(A) implement interface of AggregateFunction,that instance of class will be transformed to instance of SqlUserDefinedAggFunction by call toOp method in CalciteCatalogReader.
when construct the SqlUserDefinedAggFunction instance will set paramTypes to null for super class sqlFunction indirectly.
The problem is:
we will get SqlUserDefinedAggFunction paramTypes to sql validatefilte,but it will be filter nothing

Issue Links

• relates to: CALCITE-1882 Can't obtain the user defined aggregate function such as sum,avg by calcite