Adapter Online Help
>
TDV Drill Adapter
>
Apache Drill Function Support
>
Apache Drill Analytic Function Support
Apache Drill Analytic Function Support
TDV supports the analytic functions listed in the table below for Apache Drill.
Apache Drill Analytic Function
Notes
CUME_DIST_ANALYTIC
FIRST_VALUE
LAG
LAST_VALUE
LEAD
NTILE
PERCENT_RANK
PERCENTILE
PERCENTILE_APPROX
RANK
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
ROW_NUMBER