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 |
||||||
---|---|---|---|---|---|---|---|---|
st_point |
||||||||
|
st_pointn |
|||||||
|
st_points |
|||||||
any_keys_match |
st_polygon |
|||||||
|
is_subnet_of |
regexp_split |
st_relate |
|||||
any_values_match |
jaccard_index |
regress |
st_startpoint |
|||||
reidentification_potential |
st_symdifference |
|||||||
array_cum_sum |
json_array_get |
remove_nulls |
st_touches |
|||||
render |
st_union |
|||||||
st_within |
||||||||
st_x |
||||||||
st_xmax |
||||||||
rgb |
st_xmin |
classification_fall_out |
||||||
ends_with |
st_y |
classification_miss_rate |
||||||
enum_key |
key_sampling_percent |
st_ymax |
classification_precision |
|||||
laplace_cdf |
st_ymin |
classification_recall |
||||||
array_max_by |
expand_envelope |
last_day_of_month |
scale_qdigest |
starts_with |
classification_thresholds |
|||
f_cdf |
convex_hull_agg |
|||||||
array_min_by |
features |
secure_random |
||||||
levenshtein_distance |
||||||||
line_interpolate_point |
||||||||
array_remove |
find_first |
line_locate_point |
||||||
find_first_index |
tdigest_agg |
|||||||
localtime |
differential_entropy |
|||||||
flatten_geometry_collections |
localtimestamp |
|||||||
|
simplify_geometry |
evaluate_classifier_predictions |
||||||
fnv1_32 |
||||||||
fnv1_64 |
geometric_mean |
|||||||
fnv1a_32 |
spatial_partitions |
geometry_union_agg |
||||||
fnv1a_64 |
||||||||
bar |
|
to_geometry |
khyperloglog_agg |
|||||
split_to_map |
||||||||
bing_tile |
from_base32 |
split_to_multimap |
to_ieee754_32 |
learn_classifier |
||||
bing_tile_at |
learn_libsvm_classifier |
|||||||
bing_tile_children |
to_iso8601 |
learn_libsvm_regressor |
||||||
bing_tile_coordinates |
to_milliseconds |
learn_regressor |
||||||
bing_tile_parent |
map_normalize |
st_area |
to_spherical_geography |
make_set_digest |
||||
bing_tile_polygon |
map_remove_null_values |
st_asbinary |
||||||
bing_tile_quadkey |
from_ieee754_32 |
map_subset |
st_astext |
|||||
bing_tile_zoom_level |
from_ieee754_64 |
map_top_n |
st_boundary |
|||||
bing_tiles_around |
from_iso8601_date |
map_top_n_keys |
st_buffer |
|||||
from_iso8601_timestamp |
map_top_n_values |
st_centroid |
||||||
st_contains |
||||||||
st_convexhull |
merge_set_digest |
|||||||
gamma_cdf |
st_coorddim |
|||||||
geometry_as_geojson |
merge_hll |
st_crosses |
typeof |
|||||
geometry_from_geojson |
merge_khll |
st_difference |
uniqueness_distribution |
multimap_agg |
||||
geometry_invalid_reason |
st_dimension |
numeric_histogram |
||||||
geometry_nearest_points |
st_disjoint |
qdigest_agg |
||||||
geometry_to_bing_tiles |
st_distance |
reduce_agg |
||||||
geometry_to_dissolved_bing_tiles |
st_endpoint |
|||||||
geometry_union |
multimap_from_entries |
st_envelope |
||||||
great_circle_distance |
murmur3_x64_128 |
st_envelopeaspts |
||||||
myanmar_font_encoding |
st_equals |
|||||||
hamming_distance |
myanmar_normalize_unicode |
st_exteriorring |
||||||
hash_counts |
st_geometries |
spatial_partitioning |
||||||
ngrams |
st_geometryfromtext |
|||||||
no_keys_match |
st_geometryn |
uuid |
||||||
no_values_match |
st_geometrytype |
value_at_quantile |
||||||
|
st_geomfrombinary |
values_at_quantiles |
||||||
classify |
st_interiorringn |
tdigest_agg |
||||||
normalize |
st_interiorrings |
|||||||
color |
intersection_cardinality |
now |
st_intersection |
weibull_cdf |
||||
st_intersects |
||||||||
inverse_binomial_cdf |
parse_duration |
st_isclosed |
wilson_interval_lower |
|||||
inverse_cauchy_cdf |
parse_presto_data_size |
st_isempty |
wilson_interval_upper |
|||||
inverse_chi_squared_cdf |
st_isring |
word_stem |
||||||
inverse_f_cdf |
pinot_binary_decimal_to_double |
st_issimple |
||||||
cosine_similarity |
inverse_gamma_cdf |
poisson_cdf |
st_isvalid |
|||||
inverse_laplace_cdf |
st_length |
|||||||
inverse_normal_cdf |
st_linefromtext |
|||||||
current_time |
inverse_poisson_cdf |
quantile_at_value |
st_linestring |
|||||
current_timestamp |
inverse_weibull_cdf |
st_multipoint |
||||||
current_timezone |
ip_prefix |
st_numgeometries |
||||||
ip_subnet_max |
st_numinteriorring |
|||||||
ip_subnet_min |
st_numpoints |
|||||||
ip_subnet_range |
st_overlaps |