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_format()`	`is_finite()`	`regexp_extract()`	st_point	`approx_distinct()`	`cume_dist()`
`acos()`	`date_parse()`	`is_infinite()`	`regexp_extract_all()`	st_pointn	`approx_most_frequent()`	`dense_rank()`
`all_match()`	`date_trunc()`	`is_json_scalar()`	`regexp_like()`	st_points	`approx_percentile()`	`first_value()`
any_keys_match	`day()`	`is_nan()`	`regexp_replace()`	st_polygon	`approx_set()`	`lag()`
`any_match()`	`day_of_month()`	is_subnet_of	regexp_split	st_relate	`arbitrary()`	`last_value()`
any_values_match	`day_of_week()`	jaccard_index	regress	st_startpoint	`array_agg()`	`lead()`
`array_average()`	`day_of_year()`	`json_array_contains()`	reidentification_potential	st_symdifference	`avg()`	`nth_value()`
array_cum_sum	`degrees()`	json_array_get	remove_nulls	st_touches	`bitwise_and_agg()`	`ntile()`
`array_distinct()`	`dow()`	`json_array_length()`	render	st_union	`bitwise_or_agg()`	`percent_rank()`
`array_duplicates()`	`doy()`	`json_extract()`	`repeat()`	st_within	`bool_and()`	`rank()`
`array_except()`	`e()`	`json_extract_scalar()`	`replace()`	st_x	`bool_or()`	`row_number()`
`array_frequency()`	`element_at()`	`json_format()`	`reverse()`	st_xmax	`checksum()`
`array_has_duplicates()`	`empty_approx_set()`	`json_parse()`	rgb	st_xmin	classification_fall_out
`array_intersect()`	ends_with	`json_size()`	`round()`	st_y	classification_miss_rate
`array_join()`	enum_key	key_sampling_percent	`rpad()`	st_ymax	classification_precision
`array_max()`	`exp()`	laplace_cdf	`rtrim()`	st_ymin	classification_recall
array_max_by	expand_envelope	last_day_of_month	scale_qdigest	starts_with	classification_thresholds
`array_min()`	f_cdf	`least()`	`second()`	`strpos()`	convex_hull_agg
array_min_by	features	`length()`	secure_random	`strrpos()`	`corr()`
`array_normalize()`	`filter()`	levenshtein_distance	`sequence()`	`substr()`	`count()`
`array_position()`	`filter()`	line_interpolate_point	`sha1()`	`tan()`	`count_if()`
array_remove	find_first	line_locate_point	`sha256()`	`tanh()`	`covar_pop()`
`array_sort()`	find_first_index	`ln()`	`sha512()`	tdigest_agg	`covar_samp()`
`array_sort_desc()`	`flatten()`	localtime	`shuffle()`	`timezone_hour()`	differential_entropy
`array_sum()`	flatten_geometry_collections	localtimestamp	`sign()`	`timezone_minute()`	`entropy()`
`array_union()`	`floor()`	`log10()`	simplify_geometry	`to_base()`	evaluate_classifier_predictions
`arrays_overlap()`	fnv1_32	`log2()`	`sin()`	`to_base64()`	`every()`
`asin()`	fnv1_64	`lower()`	`slice()`	`to_base64url()`	geometric_mean
`atan()`	fnv1a_32	`lpad()`	spatial_partitions	`to_big_endian_32()`	geometry_union_agg
`atan2()`	fnv1a_64	`ltrim()`	`split()`	`to_big_endian_64()`	`histogram()`
bar	`format_datetime()`	`map()`	`split_part()`	to_geometry	khyperloglog_agg
`beta_cdf()`	`from_base()`	`map_concat()`	split_to_map	`to_hex()`	`kurtosis()`
bing_tile	from_base32	`map_entries()`	split_to_multimap	to_ieee754_32	learn_classifier
bing_tile_at	`from_base64()`	`map_filter()`	`spooky_hash_v2_32()`	`to_ieee754_64()`	learn_libsvm_classifier
bing_tile_children	`from_base64url()`	`map_from_entries()`	`spooky_hash_v2_64()`	to_iso8601	learn_libsvm_regressor
bing_tile_coordinates	`from_big_endian_32()`	`map_keys()`	`sqrt()`	to_milliseconds	learn_regressor
bing_tile_parent	`from_big_endian_64()`	map_normalize	st_area	to_spherical_geography	make_set_digest
bing_tile_polygon	`from_hex()`	map_remove_null_values	st_asbinary	`to_unixtime()`	`map_agg()`
bing_tile_quadkey	from_ieee754_32	map_subset	st_astext	`to_utf8()`	`map_union()`
bing_tile_zoom_level	from_ieee754_64	map_top_n	st_boundary	`transform()`	`map_union_sum()`
bing_tiles_around	from_iso8601_date	map_top_n_keys	st_buffer	`transform_keys()`	`max()`
`binomial_cdf()`	from_iso8601_timestamp	map_top_n_values	st_centroid	`transform_values()`	`max_by()`
`bit_count()`	`from_unixtime()`	`map_values()`	st_contains	`trim()`	`merge()`
`bitwise_and()`	`from_utf8()`	`map_zip_with()`	st_convexhull	`trim_array()`	merge_set_digest
`bitwise_arithmetic_shift_right()`	gamma_cdf	`md5()`	st_coorddim	`truncate()`	`min()`
`bitwise_left_shift()`	geometry_as_geojson	merge_hll	st_crosses	typeof	`min_by()`
`bitwise_logical_shift_right()`	geometry_from_geojson	merge_khll	st_difference	uniqueness_distribution	multimap_agg
`bitwise_not()`	geometry_invalid_reason	`millisecond()`	st_dimension	`upper()`	numeric_histogram
`bitwise_or()`	geometry_nearest_points	`minute()`	st_disjoint	`url_decode()`	qdigest_agg
`bitwise_right_shift()`	geometry_to_bing_tiles	`mod()`	st_distance	`url_encode()`	reduce_agg
`bitwise_right_shift_arithmetic()`	geometry_to_dissolved_bing_tiles	`month()`	st_endpoint	`url_extract_fragment()`	`regr_intercept()`
`bitwise_shift_left()`	geometry_union	multimap_from_entries	st_envelope	`url_extract_host()`	`regr_slope()`
`bitwise_xor()`	great_circle_distance	murmur3_x64_128	st_envelopeaspts	`url_extract_parameter()`	`set_agg()`
`cardinality()`	`greatest()`	myanmar_font_encoding	st_equals	`url_extract_path()`	`set_union()`
`cauchy_cdf()`	hamming_distance	myanmar_normalize_unicode	st_exteriorring	`url_extract_port()`	`skewness()`
`cbrt()`	hash_counts	`nan()`	st_geometries	`url_extract_protocol()`	spatial_partitioning
`ceil()`	`hmac_md5()`	ngrams	st_geometryfromtext	`url_extract_query()`	`stddev()`
`ceiling()`	`hmac_sha1()`	no_keys_match	st_geometryn	uuid	`stddev_pop()`
`chi_squared_cdf()`	`hmac_sha256()`	no_values_match	st_geometrytype	value_at_quantile	`stddev_samp()`
`chr()`	`hmac_sha512()`	`none_match()`	st_geomfrombinary	values_at_quantiles	`sum()`
classify	`hour()`	`normal_cdf()`	st_interiorringn	`week()`	tdigest_agg
`codepoint()`	`infinity()`	normalize	st_interiorrings	`week_of_year()`	`var_pop()`
color	intersection_cardinality	now	st_intersection	weibull_cdf	`var_samp()`
`combinations()`	`inverse_beta_cdf()`	`parse_datetime()`	st_intersects	`width_bucket()`	`variance()`
`concat()`	inverse_binomial_cdf	parse_duration	st_isclosed	wilson_interval_lower
`contains()`	inverse_cauchy_cdf	parse_presto_data_size	st_isempty	wilson_interval_upper
`cos()`	inverse_chi_squared_cdf	`pi()`	st_isring	word_stem
`cosh()`	inverse_f_cdf	pinot_binary_decimal_to_double	st_issimple	`xxhash64()`
cosine_similarity	inverse_gamma_cdf	poisson_cdf	st_isvalid	`year()`
`crc32()`	inverse_laplace_cdf	`pow()`	st_length	`year_of_week()`
`current_date()`	inverse_normal_cdf	`power()`	st_linefromtext	`yow()`
current_time	inverse_poisson_cdf	quantile_at_value	st_linestring	`zip()`
current_timestamp	inverse_weibull_cdf	`quarter()`	st_multipoint	`zip_with()`
current_timezone	ip_prefix	`radians()`	st_numgeometries
`date()`	ip_subnet_max	`rand()`	st_numinteriorring
`date_add()`	ip_subnet_min	`random()`	st_numpoints
`date_diff()`	ip_subnet_range	`reduce()`	st_overlaps