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

abs()

date_diff()

is_json_scalar()

render

st_points

approx_distinct()

acos()

date_format()

is_nan()

repeat

st_polygon

approx_most_frequent()

all_match

date_parse()

is_subnet_of

replace()

st_relate

approx_percentile()

any_match

date_trunc()

jaccard_index

reverse()

st_startpoint

approx_set()

array_average

day()

json_array_contains()

rgb

st_symdifference

arbitrary()

array_distinct()

day_of_month()

json_array_get

round()

st_touches

array_agg()

array_duplicates()

day_of_week()

json_array_length()

rpad()

st_union

avg()

array_except()

day_of_year()

json_extract

rtrim()

st_within

bitwise_and_agg()

array_frequency

degrees()

json_extract_scalar()

scale_qdigest

st_x

bitwise_or_agg()

array_has_duplicates

dow()

json_format

second()

st_xmax

bool_and()

array_intersect()

doy()

json_parse

sequence

st_xmin

bool_or()

array_join()

e()

json_size

sha1

st_y

checksum()

array_max()

element_at()

least()

sha256()

st_ymax

classification_fall_out

array_min()

empty_approx_set()

length()

sha512()

st_ymin

classification_miss_rate

array_normalize

enum_key

levenshtein_distance

shuffle

strpos()

classification_precision

array_position()

exp()

line_interpolate_point

sign()

strrpos

classification_recall

array_remove

expand_envelope

line_locate_point

simplify_geometry

substr()

classification_thresholds

array_sort()

features

ln()

sin()

tan()

convex_hull_agg

array_sum()

filter()

localtime

slice()

tanh()

corr()

array_union

flatten

localtimestamp

spatial_partitions

timezone_hour

count()

arrays_overlap()

flatten_geometry_collections

log10()

split()

timezone_minute

count_if()

asin()

floor()

log2()

split_part()

to_base()

covar_pop()

atan()

fnv1_32

lower()

split_to_map

to_base64()

covar_samp()

atan2()

fnv1_64

lpad()

split_to_multimap

to_base64url

differential_entropy

bar

fnv1a_32

ltrim()

spooky_hash_v2_32

to_big_endian_32

entropy

beta_cdf

fnv1a_64

map()

spooky_hash_v2_64

to_big_endian_64

evaluate_classifier_predictions

bing_tile

format_datetime()

map_concat()

sqrt()

to_geometry

every()

bing_tile_at

from_base()

map_entries()

st_area

to_hex()

geometric_mean

bing_tile_children

from_base64()

map_filter()

st_asbinary

to_ieee754_32

geometry_union_agg

bing_tile_coordinates

from_base64url

map_from_entries

st_astext

to_ieee754_64

histogram()

bing_tile_parent

from_big_endian_32

map_keys()

st_boundary

to_iso8601

khyperloglog_agg

bing_tile_polygon

from_big_endian_64

map_normalize

st_buffer

to_milliseconds

kurtosis

bing_tile_quadkey

from_hex()

map_values()

st_centroid

to_spherical_geography

learn_classifier

bing_tile_zoom_level

from_ieee754_32

map_zip_with()

st_contains

to_unixtime()

learn_libsvm_classifier

bing_tiles_around

from_ieee754_64

md5()

st_convexhull

to_utf8()

learn_libsvm_regressor

binomial_cdf

from_iso8601_date

merge_hll

st_coorddim

transform()

learn_regressor

bit_count()

from_iso8601_timestamp

merge_khll

st_crosses

transform_keys()

make_set_digest

bitwise_and()

from_unixtime()

millisecond()

st_difference

transform_values()

map_agg()

bitwise_arithmetic_shift_right()

from_utf8

minute()

st_dimension

trim()

map_union()

bitwise_left_shift()

geometry_as_geojson

mod()

st_disjoint

truncate()

map_union_sum

bitwise_logical_shift_right()

geometry_from_geojson

month()

st_distance

typeof

max()

bitwise_not()

geometry_invalid_reason

multimap_from_entries

st_endpoint

uniqueness_distribution

max_by()

bitwise_or()

geometry_nearest_points

myanmar_font_encoding

st_envelope

upper()

merge()

bitwise_right_shift()

geometry_to_bing_tiles

myanmar_normalize_unicode

st_envelopeaspts

url_decode()

merge_set_digest

bitwise_right_shift_arithmetic()

geometry_to_dissolved_bing_tiles

nan()

st_equals

url_encode()

min()

bitwise_shift_left()

geometry_union

ngrams

st_exteriorring

url_extract_fragment()

min_by()

bitwise_xor()

great_circle_distance

none_match

st_geometries

url_extract_host()

multimap_agg

cardinality()

greatest()

normal_cdf

st_geometryfromtext

url_extract_parameter()

numeric_histogram

cauchy_cdf

hamming_distance

normalize

st_geometryn

url_extract_path()

qdigest_agg

cbrt()

hash_counts

now

st_geometrytype

url_extract_port()

reduce_agg

ceil()

hmac_md5

parse_datetime()

st_geomfrombinary

url_extract_protocol()

regr_intercept

ceiling()

hmac_sha1

parse_duration

st_interiorringn

url_extract_query()

regr_slope

chi_squared_cdf

hmac_sha256

parse_presto_data_size

st_interiorrings

value_at_quantile

set_agg

chr()

hmac_sha512

pi()

st_intersection

values_at_quantiles

set_union

classify

hour()

poisson_cdf

st_intersects

week

skewness

codepoint()

infinity()

pow()

st_isclosed

week_of_year

spatial_partitioning

color

intersection_cardinality

power()

st_isempty

weibull_cdf

stddev()

combinations()

inverse_beta_cdf

quantile_at_value

st_isring

width_bucket()

stddev_pop()

concat()

inverse_binomial_cdf

quarter()

st_issimple

wilson_interval_lower

stddev_samp()

contains()

inverse_cauchy_cdf

radians()

st_isvalid

wilson_interval_upper

sum()

cos()

inverse_chi_squared_cdf

rand()

st_length

word_stem

tdigest_agg

cosh()

inverse_normal_cdf

random()

st_linefromtext

xxhash64()

var_pop()

cosine_similarity

inverse_poisson_cdf

reduce()

st_linestring

year()

var_samp()

crc32

inverse_weibull_cdf

regexp_extract()

st_multipoint

year_of_week()

variance()

current_date

ip_prefix

regexp_extract_all()

st_numgeometries

yow()

current_time

ip_subnet_max

regexp_like()

st_numinteriorring

zip()

current_timestamp

ip_subnet_min

regexp_replace()

st_numpoints

zip_with()

current_timezone

ip_subnet_range

regexp_split

st_overlaps

date

is_finite()

regress

st_point

date_add()

is_infinite()

reidentification_potential

st_pointn