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 |
|||||
---|---|---|---|---|---|---|
render |
st_points |
|||||
st_polygon |
||||||
all_match |
|
is_subnet_of |
st_relate |
|||
any_match |
jaccard_index |
st_startpoint |
||||
array_average |
rgb |
st_symdifference |
||||
json_array_get |
st_touches |
|||||
st_union |
||||||
json_extract |
st_within |
|||||
array_frequency |
scale_qdigest |
st_x |
||||
st_xmax |
||||||
json_parse |
sequence |
st_xmin |
||||
sha1 |
st_y |
|||||
st_ymax |
classification_fall_out |
|||||
st_ymin |
classification_miss_rate |
|||||
array_normalize |
enum_key |
levenshtein_distance |
shuffle |
classification_precision |
||
line_interpolate_point |
classification_recall |
|||||
array_remove |
expand_envelope |
line_locate_point |
simplify_geometry |
classification_thresholds |
||
features |
convex_hull_agg |
|||||
localtime |
||||||
array_union |
flatten |
localtimestamp |
spatial_partitions |
timezone_hour |
||
flatten_geometry_collections |
timezone_minute |
|||||
fnv1_32 |
split_to_map |
|||||
fnv1_64 |
split_to_multimap |
to_base64url |
differential_entropy |
|||
bar |
fnv1a_32 |
to_big_endian_32 |
entropy |
|||
beta_cdf |
fnv1a_64 |
to_big_endian_64 |
evaluate_classifier_predictions |
|||
bing_tile |
|
to_geometry |
||||
bing_tile_at |
st_area |
geometric_mean |
||||
bing_tile_children |
st_asbinary |
to_ieee754_32 |
geometry_union_agg |
|||
bing_tile_coordinates |
from_base64url |
map_from_entries |
st_astext |
to_ieee754_64 |
||
bing_tile_parent |
from_big_endian_32 |
st_boundary |
to_iso8601 |
khyperloglog_agg |
||
bing_tile_polygon |
from_big_endian_64 |
map_normalize |
st_buffer |
to_milliseconds |
kurtosis |
|
bing_tile_quadkey |
st_centroid |
to_spherical_geography |
learn_classifier |
|||
bing_tile_zoom_level |
from_ieee754_32 |
st_contains |
learn_libsvm_classifier |
|||
bing_tiles_around |
from_ieee754_64 |
st_convexhull |
learn_libsvm_regressor |
|||
binomial_cdf |
from_iso8601_date |
merge_hll |
st_coorddim |
learn_regressor |
||
from_iso8601_timestamp |
merge_khll |
st_crosses |
make_set_digest |
|||
st_difference |
||||||
from_utf8 |
st_dimension |
|||||
geometry_as_geojson |
st_disjoint |
map_union_sum |
||||
geometry_from_geojson |
st_distance |
typeof |
||||
geometry_invalid_reason |
multimap_from_entries |
st_endpoint |
uniqueness_distribution |
|||
geometry_nearest_points |
myanmar_font_encoding |
st_envelope |
||||
geometry_to_bing_tiles |
myanmar_normalize_unicode |
st_envelopeaspts |
merge_set_digest |
|||
geometry_to_dissolved_bing_tiles |
st_equals |
|||||
geometry_union |
ngrams |
st_exteriorring |
||||
great_circle_distance |
none_match |
st_geometries |
multimap_agg |
|||
normal_cdf |
st_geometryfromtext |
numeric_histogram |
||||
cauchy_cdf |
hamming_distance |
normalize |
st_geometryn |
qdigest_agg |
||
hash_counts |
now |
st_geometrytype |
reduce_agg |
|||
hmac_md5 |
st_geomfrombinary |
regr_intercept |
||||
parse_duration |
st_interiorringn |
regr_slope |
||||
chi_squared_cdf |
parse_presto_data_size |
st_interiorrings |
value_at_quantile |
set_agg |
||
st_intersection |
values_at_quantiles |
set_union |
||||
classify |
poisson_cdf |
st_intersects |
skewness |
|||
st_isclosed |
spatial_partitioning |
|||||
color |
intersection_cardinality |
st_isempty |
weibull_cdf |
|||
inverse_beta_cdf |
quantile_at_value |
st_isring |
||||
inverse_binomial_cdf |
st_issimple |
wilson_interval_lower |
||||
inverse_cauchy_cdf |
st_isvalid |
wilson_interval_upper |
||||
inverse_chi_squared_cdf |
st_length |
word_stem |
tdigest_agg |
|||
inverse_normal_cdf |
st_linefromtext |
|||||
cosine_similarity |
inverse_poisson_cdf |
st_linestring |
||||
inverse_weibull_cdf |
st_multipoint |
|||||
current_date |
ip_prefix |
st_numgeometries |
||||
current_time |
ip_subnet_max |
st_numinteriorring |
||||
current_timestamp |
ip_subnet_min |
st_numpoints |
||||
current_timezone |
ip_subnet_range |
regexp_split |
st_overlaps |
|||
date |
regress |
st_point |
||||
reidentification_potential |
st_pointn |