Ce contenu n'est pas disponible dans la langue sélectionnée.
11.11. Aggregate Function Options
|
Property
|
Data Type or Allowed Values
|
Description
|
|---|---|---|
|
ANALYTIC
|
'TRUE'|'FALSE'
|
indicates the aggregate function must be windowed. default false.
|
|
ALLOWS-ORDERBY
|
'TRUE'|'FALSE'
|
indicates the aggregate function supports an ORDER BY clause. default false
|
|
ALLOWS-DISTINCT
|
'TRUE'|'FALSE'
|
indicates the aggregate function supports the DISTINCT keyword. default false
|
|
DECOMPOSABLE
|
'TRUE'|'FALSE'
|
indicates the single argument aggregate function can be decomposed as agg(agg(x) ) over subsets of data. default false
|
|
USES-DISTINCT-ROWS
|
'TRUE'|'FALSE'
|
indicates the aggregate function effectively uses distinct rows rather than all rows. default false
|
Note that virtual functions defined using the Teiid procedure language cannot be aggregate functions.
Note
If you have defined a UDF (virtual) function without a Teiid procedure definition, then it must be accompanied by its implementation in Java. To configure the Java library as dependency to the VDB, see Support for User-Defined Functions in Red Hat JBoss Data Virtualization Development Guide: Server Development.
