TIBCO Data Virtualization® Adapter Online Help > TDV Greenplum Adapter > Greenplum Function Support > Greenplum Analytic Aggregate Function Support
 
Greenplum Analytic Aggregate Function Support
TDV supports the analytic aggregate functions listed in the table below for Greenplum.
The following functions can not be pushed:
CORR_SPEARMAN
LISTAGG
MEDIAN
PERCENTILE_CONT
PERCENTILE_DISC
XMLAGG
Greenplum Analytic Aggregate Function
Notes
CORR
Push supported.
COVAR_POP
Push supported.
COVAR_SAMP
Push supported.
REGR_AVGX
Push supported.
REGR_AVGY
Push supported.
REGR_COUNT
Push supported.
REGR_INTERCEPT
Push supported.
REGR_R2
Push supported.
REGR_SLOPE
Push supported.
REGR_SXX
Push supported.
REGR_SXY
Push supported.
REGR_SYY
Push supported.
STDDEV
Push supported.
STDDEV_POP
Push supported.
STDDEV_SAMP
Push supported.
VAR_POP
Push supported.
VAR_SAMP
Push supported.
VARIANCE
Push supported.
VARIANCE_POP
Push supported.
VARIANCE_SAMP
Push supported.