Enterprise docs

SQL server aggregation support

function

Support

approx_distinct

Emulated

approx_median

Emulated

approx_percentile

Emulated

arbitrary

Natively Supported

array_agg

Unavailable

avg

Natively Supported

bool_and

Natively Supported

bool_or

Natively Supported

checksum

Natively Supported

correlation

Emulated

count

Natively Supported

count(*)

Natively Supported

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

Emulated

stdev

Natively Supported

sum

Natively Supported

var_pop

Natively Supported

var_samp

Emulated

variance

Natively Supported

SQL Server 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

Natively Supported

coalesce

Natively Supported

concat

Natively Supported

cos

Natively Supported

cosh

Natively Supported

current_user

Emulated

date_add

Natively Supported

date_diff

Natively Supported

date_format

Emulated

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

Natively Supported

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

Emulated

regexp_extract

Emulated

replace

Natively Supported

right

Natively Supported

round

Natively Supported

rpad

Emulated

rtrim

Natively Supported

seconds

Natively Supported

sha1

Natively Supported

sha256

Natively Supported

sha384

Emulated

sha512

Natively Supported

sign

Natively Supported

sin

Natively Supported

sinh

Natively Supported

sqrt

Natively Supported

string_split

Emulated

substring

Natively Supported

tan

Natively Supported

tanh

Natively Supported

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

In this section: