Community docs

Denodo aggregation support

Aggregation

Support

approx_distinct

Emulated

approx_median

Emulated

approx_percentile

Emulated

arbitrary

Emulated

array_agg

Unavailable

avg

Natively Supported

bool_and

Natively Supported

bool_or

Natively Supported

checksum

Emulated

correlation

Emulated

count

Natively Supported

count(*)

Emulated

count_if

Natively Supported

covar_pop

Emulated

covar_samp

Emulated

group_concat

Emulated

kurtosis

Emulated

max

Natively Supported

max_by

Emulated

min

Natively Supported

min_by

Emulated

regr_avgx

Natively Supported (DISTINCT emulated)

regr_avgy

Natively Supported (DISTINCT emulated)

regr_count

Natively Supported (DISTINCT emulated)

regr_intercept

Natively Supported (DISTINCT emulated)

regr_r2

Natively Supported (DISTINCT emulated)

regr_slope

Natively Supported (DISTINCT emulated)

regr_sxx

Natively Supported (DISTINCT emulated)

regr_sxy

Natively Supported (DISTINCT emulated)

regr_syy

Natively Supported (DISTINCT emulated)

skewness

Emulated

std_pop

Natively Supported

std_samp

Natively Supported

stdev

Natively Supported

sum

Natively Supported

var_pop

Natively Supported

var_samp

Natively Supported

variance

Natively Supported

Denodo function support

Function

Support

abs

Natively Supported

acos

Natively Supported

array

Unavailable

array_append

Unavailable

array_concat

Unavailable

array_contains

Unavailable

array_join

Unavailable

array_length

Unavailable

array_prepend

Unavailable

asin

Natively Supported

at_time_zone

Emulated

atan

Natively Supported

atan2

Natively Supported

attr_of

Emulated

ceiling

Natively Supported

char

Emulated

coalesce

Natively Supported

concat

Natively Supported

cos

Natively Supported

cosh

Emulated

current_user

Emulated

date_add

Natively Supported

date_diff

Emulated

date_format

Natively Supported

date_parse

Emulated

date_part

Natively Supported

date_sub

Natively Supported

date_trunc

Natively Supported

day

Natively Supported

degrees

Natively Supported

element_at

Unavailable

exp

Natively Supported

exp10

Natively Supported

floor

Natively Supported

get_path

Emulated

greatest

Natively Supported

hours

Natively Supported

iri_of

Emulated

json_extract_scalar

Emulated

label_of

Emulated

least

Natively Supported

left

Natively Supported

length

Natively Supported

like

Natively Supported

log

Natively Supported

log10

Natively Supported

lower

Natively Supported

lpad

Emulated

ltrim

Natively Supported

md5

Emulated

mid

Natively Supported

minutes

Natively Supported

mod

Natively Supported

month

Natively Supported

now

Natively Supported

pi

Natively Supported

position

Natively Supported

pow

Natively Supported

radians

Natively Supported

rand

Natively Supported

random

Natively Supported

regex

Natively Supported

regexp_extract

Emulated

replace

Natively Supported

right

Natively Supported

round

Natively Supported

rpad

Emulated

rtrim

Natively Supported

seconds

Natively Supported

sha1

Emulated

sha256

Emulated

sha384

Emulated

sha512

Emulated

sign

Natively Supported

sin

Natively Supported

sinh

Emulated

sqrt

Natively Supported

string_split

Emulated

substring

Natively Supported

tan

Natively Supported

tanh

Emulated

trim

Natively Supported

upper

Natively Supported

url_extract_fragment

Emulated

url_extract_host

Emulated

url_extract_parameter

Emulated

url_extract_path

Emulated

url_extract_port

Emulated

url_extract_protocol

Emulated

url_extract_query

Emulated

year

Natively Supported