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_json_scalar()`	render	st_points	`approx_distinct()`	`cume_dist()`
`acos()`	`date_format()`	`is_nan()`	`repeat()`	st_polygon	`approx_most_frequent()`	`dense_rank()`
all_match	`date_parse()`	is_subnet_of	`replace()`	st_relate	`approx_percentile()`	first_value
any_match	`date_trunc()`	jaccard_index	`reverse()`	st_startpoint	`approx_set()`	lag
`array_average()`	`day()`	`json_array_contains()`	rgb	st_symdifference	`arbitrary()`	last_value
`array_distinct()`	`day_of_month()`	json_array_get	`round()`	st_touches	`array_agg()`	lead
`array_duplicates()`	`day_of_week()`	`json_array_length()`	`rpad()`	st_union	`avg()`	`nth_value()`
`array_except()`	`day_of_year()`	json_extract	`rtrim()`	st_within	`bitwise_and_agg()`	`ntile()`
`array_frequency()`	`degrees()`	`json_extract_scalar()`	scale_qdigest	st_x	`bitwise_or_agg()`	`percent_rank()`
`array_has_duplicates()`	`dow()`	`json_format()`	`second()`	st_xmax	`bool_and()`	`rank()`
`array_intersect()`	`doy()`	`json_parse()`	sequence	st_xmin	`bool_or()`	`row_number()`
`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