TDVがサポートする集計関数 |
コメント |
ANY_VALUE |
|
APPROX COUNT DISTINCT |
|
APPROX QUANTILES |
|
ARRAG_AGG |
|
AVG |
AVG. |
BIT_AND |
|
BIT_OR |
|
BIT_XOR |
|
CORR |
CORR. |
CORR_SPEARMAN |
|
COUNT |
|
COVAR_POP |
|
COVAR_SAMP |
|
FIRST |
|
GROUP CONCAT |
|
GROUP CONCAT UNQUOTED |
|
LAST |
|
JSON ARRAYAGG |
|
JSON OBJECTAGG |
|
LISTAGG |
|
MAX |
|
MEDIAN |
|
MIN |
MIN. |
NEST |
|
NTH |
|
PERCENTILE |
|
PERCENTILE_APPROX |
|
PERCENTILE_CONT |
|
PERCENTILE_DISC |
|
QUANTILES |
|
REGR_AVGX |
|
REGR_AVGY |
|
REGR_COUNT |
|
REGR_INTERCEPT |
|
REGR_R2 |
|
REGR_SLOPE |
|
REGR_SXX |
|
REGR_SXY |
|
REGR_SYY |
|
STDDEV |
|
STDDEV_POP |
|
STDDEV_SAMP |
|
SUM |
SUM. |
SUM_FLOAT |
|
VARIANCE |
|
VARIANCE_POP |
|
VARIANCE_SAMP |
|
XMLAGG |