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

abs()

eq()

quarter()

approx_distinct()

cume_dist()

acos()

exp()

radians()

approx_most_frequent()

dense_rank()

array_average()

filter()

rand()

approx_percentile()

nth_value()

array_constructor()

floor()

random()

approx_set()

ntile()

array_distinct()

format_datetime()

reduce()

arbitrary()

percent_rank()

array_duplicates()

from_base()

regexp_extract()

array_agg()

rank()

array_except()

from_base64()

regexp_extract_all()

avg()

row_number()

array_frequency()

from_hex()

regexp_like()

bitwise_and_agg()

array_has_duplicates()

from_unixtime()

regexp_replace()

bitwise_or_agg()

array_intersect()

greatest()

repeat()

bool_and()

array_join()

gt()

replace()

bool_or()

array_max()

gte()

reverse()

checksum()

array_min()

hmac_sha1()

round()

corr()

array_normalize()

hmac_sha256()

rpad()

count()

array_position()

hmac_sha512()

rtrim()

count_if()

array_sort()

hour()

second()

covar_pop()

array_sum()

in

sha1()

covar_samp()

arrays_overlap()

infinity()

sha256()

every()

asin()

is_finite()

sha512()

histogram()

atan()

is_infinite()

shuffle()

map_agg()

atan2()

is_json_scalar()

sign()

map_union()

between()

is_nan()

sin()

max()

bit_count()

is_null()

slice()

max_by()

bitwise_and()

json_array_contains()

split()

max_data_size_for_stats()

bitwise_arithmetic_shift_right()

json_array_length()

split_part()

merge()

bitwise_left_shift()

json_extract_scalar()

spooky_hash_v2_32()

min()

bitwise_logical_shift_right()

json_format()

spooky_hash_v2_64()

min_by()

bitwise_not()

json_parse()

sqrt()

stddev()

bitwise_or()

json_size()

strpos()

stddev_pop()

bitwise_right_shift()

least()

strrpos()

stddev_samp()

bitwise_right_shift_arithmetic()

length()

subscript()

sum()

bitwise_shift_left()

like()

substr()

var_pop()

bitwise_xor()

ln()

tan()

var_samp()

cardinality()

log10()

tanh()

variance()

cbrt()

log2()

to_base()

ceil()

lower()

to_base64()

ceiling()

lpad()

to_hex()

chr()

lt()

to_unixtime()

clamp()

lte()

to_utf8()

codepoint()

ltrim()

transform()

combinations()

map()

transform_keys()

concat()

map_concat()

transform_values()

contains()

map_entries()

trim()

cos()

map_filter()

truncate()

cosh()

map_keys()

upper()

crc32()

map_values()

url_decode()

date_add()

map_zip_with()

url_encode()

date_diff()

md5()

url_extract_fragment()

date_format()

millisecond()

url_extract_host()

date_parse()

minus()

url_extract_parameter()

date_trunc()

minute()

url_extract_path()

day()

mod()

url_extract_port()

day_of_month()

month()

url_extract_protocol()

day_of_week()

multiply()

url_extract_query()

day_of_year()

nan()

week()

degrees()

negate()

week_of_year()

distinct_from()

neq()

width_bucket()

divide()

not

xxhash64()

dow()

parse_datetime()

year()

doy()

pi()

year_of_week()

e()

plus()

yow()

element_at()

pow()

zip()

empty_approx_set()

power()

zip_with()