Module sql/functions

Functions

count_min_sketch
count
hll_sketch_agg
hll_union_agg
kurtosis
last
last_value
mode
max
min_by
percentile
percentile_approx
approx_percentile
skewness
std
stddev
stddev_sample
stddev_samp
stddev_pop
sum
sum_distinct
listagg
listagg_distinct
string_agg
string_agg_distinct
variance
var_samp
var_pop
var_pop_distinct
regr_avgx
regr_avgy
regr_count
regr_intercept
regr_r2
regr_slope
regr_sxx
regr_sxy
regr_syy
any_value
count_if
histogram_numeric
every
bool_and
some
any
bool_or
bit_and
bit_or
bit_xor
cume_dist
dense_rank
nth_value
ntile
percent_rank
rank
row_number
array
map
named_struct
map_from_arrays
str_to_map
coalesce
input_file_name
isnan
isnull
monotonically_increasing_id
nanvl
negate
not
positive
rand
randn
randstr
spark_partition_id
sqrt
pow
power
pmod
rint
expr

agg_funcs

approx_count_distinct
avg
collect_list
collect_set
corr
countDistinct
count_distinct
covar_pop
covar_samp
first
first_value
grouping
grouping_id
max_by
mean
median
min
product

normal_funcs

col
column
lit
int
long

sort_funcs

asc
asc_nulls_first
asc_nulls_last
desc
desc_nulls_first
desc_nulls_last

window_funcs

lag
lead

Settings

Member Visibility

On This Page

Functions
agg_funcs
normal_funcs
sort_funcs
window_funcs