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()

hash_counts()

s2_cell_from_token()

any_value()

cume_dist()

acos()

hmac_md5()

s2_cell_level()

approx_distinct()

dense_rank()

all_keys_match()

hmac_sha1()

s2_cell_parent()

approx_most_frequent()

first_value()

all_match()

hmac_sha256()

s2_cell_to_token()

approx_percentile()

lag()

any_keys_match()

hmac_sha512()

s2_cells()

approx_set()

last_value()

any_match()

hour()

scale_qdigest()

approx_winsorized_mean()

lead()

any_values_match()

infinity()

scale_tdigest()

arbitrary()

nth_value()

array_average()

intersection_cardinality()

second()

array_agg()

ntile()

array_constructor()

inverse_beta_cdf()

secure_rand()

avg()

percent_rank()

array_cum_sum()

inverse_binomial_cdf()

secure_random()

bitwise_and_agg()

rank()

array_distinct()

inverse_cauchy_cdf()

sequence()

bitwise_or_agg()

row_number()

array_duplicates()

inverse_chi_squared_cdf()

sha1()

bitwise_xor_agg()

array_except()

inverse_f_cdf()

sha256()

bool_and()

array_frequency()

inverse_gamma_cdf()

sha512()

bool_or()

array_has_duplicates()

inverse_laplace_cdf()

shuffle()

checksum()

array_intersect()

inverse_normal_cdf()

sign()

classification_fall_out()

array_join()

inverse_poisson_cdf()

simplify_geometry()

classification_miss_rate()

array_max()

inverse_t_cdf()

sin()

classification_precision()

array_max_by()

inverse_weibull_cdf()

slice()

classification_recall()

array_min()

ip_prefix()

split()

classification_thresholds()

array_min_by()

ip_prefix_collapse()

split_part()

convex_hull_agg()

array_normalize()

ip_prefix_masklen()

split_to_map()

corr()

array_position()

ip_prefix_subnets()

split_to_multimap()

count()

array_remove()

ip_subnet_max()

spooky_hash_v2_32()

count_if()

array_sort()

ip_subnet_min()

spooky_hash_v2_64()

covar_pop()

array_sort_desc()

ip_subnet_range()

sqrt()

covar_samp()

array_split_into_chunks()

ip_version()

st_area()

entropy()

array_subset()

is_finite()

st_asbinary()

every()

array_sum()

is_infinite()

st_astext()

geometric_mean()

array_sum_propagate_element_null()

is_json_scalar()

st_boundary()

geometry_union_agg()

array_top_n()

is_nan()

st_buffer()

histogram()

array_union()

is_null()

st_centroid()

khyperloglog_agg()

arrays_overlap()

is_private_ip()

st_contains()

kurtosis()

asin()

is_subnet_of()

st_convexhull()

make_set_digest()

at_timezone()

jaccard_index()

st_coorddim()

map_agg()

at_timezone_convert()

jarowinkler_similarity()

st_crosses()

map_union()

atan()

json_array_contains()

st_difference()

map_union_sum()

atan2()

json_array_get()

st_dimension()

max()

beta_cdf()

json_array_length()

st_disjoint()

max_by()

between()

json_extract()

st_distance()

max_data_size_for_stats()

bing_tile()

json_extract_scalar()

st_endpoint()

merge()

bing_tile_at()

json_format()

st_envelope()

merge_set_digest()

bing_tile_children()

json_parse()

st_envelopeaspts()

min()

bing_tile_coordinates()

json_size()

st_equals()

min_by()

bing_tile_parent()

key_sampling_percent()

st_exteriorring()

multimap_agg()

bing_tile_polygon()

l2_norm()

st_geometries()

noisy_approx_distinct_sfm()

bing_tile_quadkey()

l2_squared()

st_geometryfromtext()

noisy_approx_set_sfm()

bing_tile_zoom_level()

laplace_cdf()

st_geometryn()

noisy_approx_set_sfm_from_index_and_zeros()

bing_tiles_around()

last_day_of_month()

st_geometrytype()

noisy_avg_gaussian()

binomial_cdf()

least()

st_geomfrombinary()

noisy_count_gaussian()

bit_count()

length()

st_interiorringn()

noisy_count_if_gaussian()

bit_length()

levenshtein_distance()

st_interiorrings()

noisy_sum_gaussian()

bitwise_and()

like()

st_intersection()

numeric_histogram()

bitwise_arithmetic_shift_right()

line_interpolate_point()

st_intersects()

qdigest_agg()

bitwise_left_shift()

line_locate_point()

st_isclosed()

reduce_agg()

bitwise_logical_shift_right()

ln()

st_isempty()

regr_avgx()

bitwise_not()

localtime()

st_isring()

regr_avgy()

bitwise_or()

localtimestamp()

st_issimple()

regr_count()

bitwise_right_shift()

log10()

st_isvalid()

regr_intercept()

bitwise_right_shift_arithmetic()

log2()

st_length()

regr_r2()

bitwise_shift_left()

longest_common_prefix()

st_linefromtext()

regr_slope()

bitwise_xor()

lower()

st_linestring()

regr_sxx()

cardinality()

lpad()

st_multipoint()

regr_sxy()

cauchy_cdf()

lt()

st_numgeometries()

regr_syy()

cbrt()

lte()

st_numinteriorring()

reservoir_sample()

ceil()

ltrim()

st_numpoints()

set_agg()

ceiling()

map()

st_overlaps()

set_union()

chi_squared_cdf()

map_append()

st_point()

skewness()

chr()

map_concat()

st_pointn()

stddev()

clamp()

map_entries()

st_points()

stddev_pop()

codepoint()

map_except()

st_polygon()

stddev_samp()

combinations()

map_filter()

st_relate()

sum()

combine_hash_internal()

map_from_entries()

st_startpoint()

sum_data_size_for_stats()

concat()

map_intersect()

st_symdifference()

tdigest_agg()

construct_tdigest()

map_key_exists()

st_touches()

var_pop()

contains()

map_keys()

st_union()

var_samp()

cos()

map_keys_by_top_n_values()

st_within()

variance()

cosh()

map_keys_overlap()

st_x()

vector_sum()

cosine_similarity()

map_normalize()

st_xmax()

crc32()

map_remove_null_values()

st_xmin()

current_date()

map_subset()

st_y()

current_time()

map_subset_key_in_range()

st_ymax()

current_timestamp()

map_top_n()

st_ymin()

current_timezone()

map_top_n_keys()

starts_with()

date()

map_top_n_values()

strpos()

date_add()

map_trim_values()

strrpos()

date_diff()

map_update()

subscript()

date_format()

map_values()

substr()

date_parse()

map_values_all_match()

substring()

date_trunc()

map_values_any_match()

t_cdf()

day()

map_values_in_range()

tan()

day_of_month()

map_values_none_match()

tanh()

day_of_week()

map_zip_with()

timezone_hour()

day_of_year()

md5()

timezone_minute()

degrees()

merge_hll()

to_base()

destructure_tdigest()

merge_khll()

to_base64()

distinct_from()

merge_sfm()

to_base64url()

divide()

merge_tdigest()

to_big_endian_32()

dot_product()

millisecond()

to_big_endian_64()

dow()

minus()

to_geometry()

doy()

minute()

to_hex()

e()

mod()

to_ieee754_32()

element_at()

month()

to_ieee754_64()

empty_approx_set()

multimap_from_entries()

to_iso8601()

ends_with()

multiply()

to_milliseconds()

enum_key()

murmur3_x64_128()

to_spherical_geography()

eq()

nan()

to_unixtime()

exp()

negate()

to_utf8()

expand_envelope()

neq()

trail()

f_cdf()

ngrams()

transform()

fail()

no_keys_match()

transform_keys()

filter()

no_values_match()

transform_values()

find_first()

noisy_empty_approx_set_sfm()

transform_with_index()

find_first_index()

none_match()

trim()

flatten()

normal_cdf()

trim_array()

flatten_geometry_collections()

normalize()

trimmed_mean()

floor()

now()

truncate()

fnv1_32()

parse_datetime()

typeof()

fnv1_64()

parse_duration()

uniqueness_distribution()

fnv1a_32()

parse_presto_data_size()

upper()

fnv1a_64()

pi()

url_decode()

format_datetime()

plus()

url_encode()

from_base()

pmod()

url_extract_fragment()

from_base32()

poisson_cdf()

url_extract_host()

from_base64()

pow()

url_extract_parameter()

from_base64url()

power()

url_extract_path()

from_big_endian_32()

quantile_at_value()

url_extract_port()

from_big_endian_64()

quantiles_at_values()

url_extract_protocol()

from_hex()

quarter()

url_extract_query()

from_ieee754_32()

radians()

uuid()

from_ieee754_64()

rand()

value_at_quantile()

from_iso8601_date()

random()

values_at_quantiles()

from_iso8601_timestamp()

reduce()

week()

from_unixtime()

regexp_extract()

week_of_year()

from_utf8()

regexp_extract_all()

weibull_cdf()

gamma_cdf()

regexp_like()

width_bucket()

geometry_as_geojson()

regexp_replace()

wilson_interval_lower()

geometry_from_geojson()

regexp_split()

wilson_interval_upper()

geometry_invalid_reason()

reidentification_potential()

winsorized_mean()

geometry_nearest_points()

remap_keys()

word_stem()

geometry_to_bing_tiles()

remove_nulls()

xxhash128()

geometry_to_dissolved_bing_tiles()

repeat()

xxhash64()

geometry_union()

replace()

xxhash64_internal()

google_polyline_decode()

replace_first()

year()

google_polyline_encode()

reverse()

year_of_week()

great_circle_distance()

round()

yow()

greatest()

rpad()

zip()

gt()

rtrim()

zip_with()

gte()

s2_cell_area_sq_km()

hamming_distance()

s2_cell_contains()