Function CoverageΒΆ

Here is a list of all scalar and aggregate Presto functions with functions that are available in Velox highlighted.

Scalar Functions

Aggregate Functions

Window Functions

abs()

date_diff()

is_finite()

regexp_extract()

st_overlaps

approx_distinct()

cume_dist()

acos()

date_format()

is_infinite()

regexp_extract_all()

st_point

approx_most_frequent()

dense_rank()

all_match()

date_parse()

is_json_scalar()

regexp_like()

st_pointn

approx_percentile()

first_value()

any_keys_match()

date_trunc()

is_nan()

regexp_replace()

st_points

approx_set()

lag()

any_match()

day()

is_subnet_of

regexp_split

st_polygon

arbitrary()

last_value()

any_values_match()

day_of_month()

jaccard_index

regress

st_relate

array_agg()

lead()

array_average()

day_of_week()

json_array_contains()

reidentification_potential

st_startpoint

avg()

nth_value()

array_cum_sum

day_of_year()

json_array_get

remove_nulls()

st_symdifference

bitwise_and_agg()

ntile()

array_distinct()

degrees()

json_array_length()

render

st_touches

bitwise_or_agg()

percent_rank()

array_duplicates()

dow()

json_extract()

repeat()

st_union

bool_and()

rank()

array_except()

doy()

json_extract_scalar()

replace()

st_within

bool_or()

row_number()

array_frequency()

e()

json_format()

replace_first

st_x

checksum()

array_has_duplicates()

element_at()

json_parse()

reverse()

st_xmax

classification_fall_out

array_intersect()

empty_approx_set()

json_size()

rgb

st_xmin

classification_miss_rate

array_join()

ends_with()

key_sampling_percent

round()

st_y

classification_precision

array_least_frequent

enum_key

laplace_cdf()

rpad()

st_ymax

classification_recall

array_max()

exp()

last_day_of_month()

rtrim()

st_ymin

classification_thresholds

array_max_by

expand_envelope

least()

scale_qdigest

starts_with()

convex_hull_agg

array_min()

f_cdf()

length()

second()

strpos()

corr()

array_min_by

features

levenshtein_distance()

secure_rand

strrpos()

count()

array_normalize()

filter()

line_interpolate_point

secure_random

substr()

count_if()

array_position()

filter()

line_locate_point

sequence()

tan()

covar_pop()

array_remove()

find_first()

ln()

sha1()

tanh()

covar_samp()

array_sort()

find_first_index()

localtime

sha256()

tdigest_agg

differential_entropy

array_sort_desc()

flatten()

localtimestamp

sha512()

timezone_hour()

entropy()

array_sum()

flatten_geometry_collections

log10()

shuffle()

timezone_minute()

evaluate_classifier_predictions

array_top_n

floor()

log2()

sign()

to_base()

every()

array_union()

fnv1_32

lower()

simplify_geometry

to_base32

geometric_mean()

arrays_overlap()

fnv1_64

lpad()

sin()

to_base64()

geometry_union_agg

asin()

fnv1a_32

ltrim()

slice()

to_base64url()

histogram()

atan()

fnv1a_64

map()

spatial_partitions

to_big_endian_32()

khyperloglog_agg

atan2()

format_datetime()

map_concat()

split()

to_big_endian_64()

kurtosis()

bar

from_base()

map_entries()

split_part()

to_geometry

learn_classifier

beta_cdf()

from_base32

map_filter()

split_to_map()

to_hex()

learn_libsvm_classifier

bing_tile

from_base64()

map_from_entries()

split_to_multimap

to_ieee754_32()

learn_libsvm_regressor

bing_tile_at

from_base64url()

map_keys()

spooky_hash_v2_32()

to_ieee754_64()

learn_regressor

bing_tile_children

from_big_endian_32()

map_keys_by_top_n_values

spooky_hash_v2_64()

to_iso8601

make_set_digest

bing_tile_coordinates

from_big_endian_64()

map_normalize()

sqrt()

to_milliseconds

map_agg()

bing_tile_parent

from_hex()

map_remove_null_values

st_area

to_spherical_geography

map_union()

bing_tile_polygon

from_ieee754_32()

map_subset()

st_asbinary

to_unixtime()

map_union_sum()

bing_tile_quadkey

from_ieee754_64()

map_top_n()

st_astext

to_utf8()

max()

bing_tile_zoom_level

from_iso8601_date()

map_top_n_keys

st_boundary

trail

max_by()

bing_tiles_around

from_iso8601_timestamp

map_top_n_values

st_buffer

transform()

merge()

binomial_cdf()

from_unixtime()

map_values()

st_centroid

transform_keys()

merge_set_digest

bit_count()

from_utf8()

map_zip_with()

st_contains

transform_values()

min()

bitwise_and()

gamma_cdf()

md5()

st_convexhull

trim()

min_by()

bitwise_arithmetic_shift_right()

geometry_as_geojson

merge_hll

st_coorddim

trim_array()

multimap_agg()

bitwise_left_shift()

geometry_from_geojson

merge_khll

st_crosses

truncate()

noisy_avg_gaussian

bitwise_logical_shift_right()

geometry_invalid_reason

millisecond()

st_difference

typeof()

noisy_count_gaussian

bitwise_not()

geometry_nearest_points

minute()

st_dimension

uniqueness_distribution

noisy_count_if_gaussian

bitwise_or()

geometry_to_bing_tiles

mod()

st_disjoint

upper()

noisy_sum_gaussian

bitwise_right_shift()

geometry_to_dissolved_bing_tiles

month()

st_distance

url_decode()

numeric_histogram

bitwise_right_shift_arithmetic()

geometry_union

multimap_from_entries()

st_endpoint

url_encode()

qdigest_agg

bitwise_shift_left()

great_circle_distance

murmur3_x64_128

st_envelope

url_extract_fragment()

reduce_agg()

bitwise_xor()

greatest()

myanmar_font_encoding

st_envelopeaspts

url_extract_host()

regr_avgx()

cardinality()

hamming_distance()

myanmar_normalize_unicode

st_equals

url_extract_parameter()

regr_avgy()

cauchy_cdf()

hash_counts

nan()

st_exteriorring

url_extract_path()

regr_count()

cbrt()

hmac_md5()

ngrams()

st_geometries

url_extract_port()

regr_intercept()

ceil()

hmac_sha1()

no_keys_match()

st_geometryfromtext

url_extract_protocol()

regr_r2()

ceiling()

hmac_sha256()

no_values_match()

st_geometryn

url_extract_query()

regr_slope()

chi_squared_cdf()

hmac_sha512()

none_match()

st_geometrytype

uuid

regr_sxx()

chr()

hour()

normal_cdf()

st_geomfrombinary

value_at_quantile

regr_sxy()

classify

infinity()

normalize

st_interiorringn

values_at_quantiles

regr_syy()

codepoint()

intersection_cardinality

now

st_interiorrings

week()

set_agg()

color

inverse_beta_cdf()

parse_datetime()

st_intersection

week_of_year()

set_union()

combinations()

inverse_binomial_cdf

parse_duration

st_intersects

weibull_cdf()

skewness()

concat()

inverse_cauchy_cdf

parse_presto_data_size

st_isclosed

width_bucket()

spatial_partitioning

contains()

inverse_chi_squared_cdf

pi()

st_isempty

wilson_interval_lower()

stddev()

cos()

inverse_f_cdf

pinot_binary_decimal_to_double

st_isring

wilson_interval_upper()

stddev_pop()

cosh()

inverse_gamma_cdf

poisson_cdf()

st_issimple

word_stem

stddev_samp()

cosine_similarity()

inverse_laplace_cdf

pow()

st_isvalid

xxhash64()

sum()

crc32()

inverse_normal_cdf

power()

st_length

year()

tdigest_agg

current_date()

inverse_poisson_cdf

quantile_at_value

st_linefromtext

year_of_week()

var_pop()

current_time

inverse_weibull_cdf

quarter()

st_linestring

yow()

var_samp()

current_timestamp

ip_prefix

radians()

st_multipoint

zip()

variance()

current_timezone

ip_subnet_max

rand()

st_numgeometries

zip_with()

date()

ip_subnet_min

random()

st_numinteriorring

date_add()

ip_subnet_range

reduce()

st_numpoints