Presto FunctionsΒΆ

Here is a list of all scalar and aggregate Presto functions available in Velox. Function names link to function descriptions. Check out coverage maps for all and most used functions for broader context.

Scalar Functions

Aggregate Functions

Window Functions

$internal$split_to_map()

format_datetime()

plus()

any_value()

cume_dist()

abs()

from_base()

poisson_cdf()

approx_distinct()

dense_rank()

acos()

from_base64()

pow()

approx_most_frequent()

first_value()

all_keys_match()

from_base64url()

power()

approx_percentile()

lag()

all_match()

from_big_endian_32()

quarter()

approx_set()

last_value()

any_keys_match()

from_big_endian_64()

radians()

arbitrary()

lead()

any_match()

from_hex()

rand()

array_agg()

nth_value()

any_values_match()

from_ieee754_32()

random()

avg()

ntile()

array_average()

from_ieee754_64()

reduce()

bitwise_and_agg()

percent_rank()

array_constructor()

from_iso8601_date()

regexp_extract()

bitwise_or_agg()

rank()

array_cum_sum()

from_iso8601_timestamp()

regexp_extract_all()

bitwise_xor_agg()

row_number()

array_distinct()

from_unixtime()

regexp_like()

bool_and()

array_duplicates()

from_utf8()

regexp_replace()

bool_or()

array_except()

gamma_cdf()

regexp_split()

checksum()

array_frequency()

greatest()

remove_nulls()

classification_fall_out()

array_has_duplicates()

gt()

repeat()

classification_miss_rate()

array_intersect()

gte()

replace()

classification_precision()

array_join()

hamming_distance()

replace_first()

classification_recall()

array_max()

hmac_md5()

reverse()

classification_thresholds()

array_min()

hmac_sha1()

round()

corr()

array_normalize()

hmac_sha256()

rpad()

count()

array_position()

hmac_sha512()

rtrim()

count_if()

array_remove()

hour()

second()

covar_pop()

array_sort()

in

secure_rand()

covar_samp()

array_sort_desc()

infinity()

secure_random()

entropy()

array_sum()

inverse_beta_cdf()

sequence()

every()

array_sum_propagate_element_null()

inverse_cauchy_cdf()

sha1()

geometric_mean()

array_union()

inverse_laplace_cdf()

sha256()

histogram()

arrays_overlap()

inverse_normal_cdf()

sha512()

kurtosis()

asin()

inverse_weibull_cdf()

shuffle()

map_agg()

at_timezone()

ip_prefix()

sign()

map_union()

atan()

is_finite()

sin()

map_union_sum()

atan2()

is_infinite()

slice()

max()

beta_cdf()

is_json_scalar()

split()

max_by()

between()

is_nan()

split_part()

max_data_size_for_stats()

binomial_cdf()

is_null()

split_to_map()

merge()

bit_count()

json_array_contains()

spooky_hash_v2_32()

min()

bitwise_and()

json_array_get()

spooky_hash_v2_64()

min_by()

bitwise_arithmetic_shift_right()

json_array_length()

sqrt()

multimap_agg()

bitwise_left_shift()

json_extract()

starts_with()

reduce_agg()

bitwise_logical_shift_right()

json_extract_scalar()

strpos()

regr_avgx()

bitwise_not()

json_format()

strrpos()

regr_avgy()

bitwise_or()

json_parse()

subscript()

regr_count()

bitwise_right_shift()

json_size()

substr()

regr_intercept()

bitwise_right_shift_arithmetic()

laplace_cdf()

tan()

regr_r2()

bitwise_shift_left()

last_day_of_month()

tanh()

regr_slope()

bitwise_xor()

least()

timezone_hour()

regr_sxx()

cardinality()

length()

timezone_minute()

regr_sxy()

cauchy_cdf()

levenshtein_distance()

to_base()

regr_syy()

cbrt()

like()

to_base64()

set_agg()

ceil()

ln()

to_base64url()

set_union()

ceiling()

log10()

to_big_endian_32()

skewness()

chi_squared_cdf()

log2()

to_big_endian_64()

stddev()

chr()

lower()

to_hex()

stddev_pop()

clamp()

lpad()

to_ieee754_32()

stddev_samp()

codepoint()

lt()

to_ieee754_64()

sum()

combinations()

lte()

to_iso8601()

sum_data_size_for_stats()

concat()

ltrim()

to_milliseconds()

var_pop()

contains()

map()

to_unixtime()

var_samp()

cos()

map_concat()

to_utf8()

variance()

cosh()

map_entries()

trail()

cosine_similarity()

map_filter()

transform()

crc32()

map_from_entries()

transform_keys()

current_date()

map_key_exists()

transform_values()

date()

map_keys()

trim()

date_add()

map_normalize()

trim_array()

date_diff()

map_remove_null_values()

truncate()

date_format()

map_subset()

typeof()

date_parse()

map_top_n()

upper()

date_trunc()

map_top_n_keys()

url_decode()

day()

map_values()

url_encode()

day_of_month()

map_zip_with()

url_extract_fragment()

day_of_week()

md5()

url_extract_host()

day_of_year()

millisecond()

url_extract_parameter()

degrees()

minus()

url_extract_path()

distinct_from()

minute()

url_extract_port()

divide()

mod()

url_extract_protocol()

dow()

month()

url_extract_query()

doy()

multimap_from_entries()

uuid()

e()

multiply()

week()

element_at()

nan()

week_of_year()

empty_approx_set()

negate()

weibull_cdf()

ends_with()

neq()

width_bucket()

eq()

ngrams()

wilson_interval_lower()

exp()

no_keys_match()

wilson_interval_upper()

f_cdf()

no_values_match()

word_stem()

fail()

none_match()

xxhash64()

filter()

normal_cdf()

year()

find_first()

normalize()

year_of_week()

find_first_index()

not

yow()

flatten()

parse_datetime()

zip()

floor()

pi()

zip_with()