Add support for unsupported Aggregate and Analytic functions

[AnastasiiaSergienko]

Aggregate Functions

Unsupported

• GROUPING[_ID] https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/grouping[_id].htm

• PERCENTILE_CONT https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percentile_cont.htm

• PERCENTILE_DISC https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percentile_disc.htm

Partly supported without keywords and OVER clause

• AVG https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/avg.htm

• CORR https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/corr.htm

• COUNT https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/count.htm

• COVAR_POP https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/covar_pop.htm

• COVAR_SAMP https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/covar_samp.htm

• FIRST_VALUE https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/first_value.htm

• GROUP_CONCAT https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/group_concat.htm

• LAST_VALUE https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/last_value.htm

• MAX https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/max.htm

• MEDIAN https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/median.htm

• MIN https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/min.htm

• REGR_FUNCTIONS https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/regr_function.htm

• STDDEV https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/stddev.htm

• STDDEV_POP https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/stddev_pop.htm

• STDDEV_SAMP https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/stddev_samp.htm

• SUM https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/sum.htm

• VAR_POP https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/var_pop.htm

• VAR_SAMP https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/var_samp.htm

• VARIANCE https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/variance.htm

Analytic Functions

Unsupported

• CUME_DIST https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/cume_dist.htm

• DENSE_RANK https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/dense_rank.htm

• LAG https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/lag.htm

• LEAD https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/lead.htm

• NTH_VALUE https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/nth_value.htm

• NTILE https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/ntile.htm

• PERCENT_RANK https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percent_rank.htm

• PERCENTILE_CONT https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percentile_cont.htm

• PERCENTILE_DISC https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percentile_disc.htm

• RANK https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/rank.htm

• RATIO_TO_REPORT https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/ratio_to_report.htm

• ROW_NUMBER https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/row_number.htm

Partly supported without keywords and OVER clause

• ANY https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/any.htm

• EVERY https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/every.htm

• LISTAGG https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/listagg.htm

Other

• NAMED WINDOW CLAUSE https://docs.exasol.com/sql_references/functions/analyticfunctions.htm#microcontent5
• over_clause https://docs.exasol.com/sql_references/functions/analyticfunctions.htm?Highlight=over_clause