Adapter Online Help > TDV Greenplum Adapter > Greenplum Function Support > Greenplum Analytic Function Support
 
Greenplum Analytic Function Support
TDV supports the analytic functions listed in the table below for Greenplum.
The following functions can not be pushed:
• EXP_WEIGHTED_AVG
• FIRST_VALUE_IGNORE_NULLS
• LAST_VALUE_IGNORE_NULLS
• NTH_VALUE_FROM_LAST
• NTH_VALUE_FROM_LAST_IGNORE_NULLS
• NTH_VALUE
• NTH_VALUE_IGNORE_NULLS
• RATIO_TO_REPORT
• TIMESERIES
Greenplum Analytic Function
Notes
AVG
Push supported.
CORR
Push supported.
COUNT
Push supported.
COVAR_POP
Push supported.
COVAR_SAMP
Push supported.
CUME_DIST
Push supported.
DENSE_RANK
Push supported.
FIRST_VALUE
Push supported.
LAG
Push supported.
LAST_VALUE
Push supported.
LEAD
Push supported.
MAX
Push supported.
MIN
Push supported.
NTILE
Push supported.
PERCENT_RANK
Push supported.
RANK
Push supported.
ROW_NUMBER
 
STDDEV
DISTINCT supported. Push supported.
TDV’s implementation of STDDEV upcasts 32 bit float to 64 bit double. The result is a double
STDDEV_POP
Push supported.
STDDEV_SAMP
Push supported.
VAR_POP
Push supported.
VAR_SAMP
Push supported.
VARIANCE
DISTINCT supported. Push supported.
VARIANCE_POP
Push supported.
VARIANCE_SAMP
Push supported.