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 |
||||||
---|---|---|---|---|---|---|---|---|
render |
st_points |
|||||||
st_polygon |
||||||||
all_match |
|
is_subnet_of |
st_relate |
first_value |
||||
any_match |
jaccard_index |
st_startpoint |
lag |
|||||
rgb |
st_symdifference |
last_value |
||||||
json_array_get |
st_touches |
lead |
||||||
st_union |
||||||||
json_extract |
st_within |
|||||||
scale_qdigest |
st_x |
|||||||
st_xmax |
||||||||
sequence |
st_xmin |
|||||||
st_y |
||||||||
st_ymax |
classification_fall_out |
|||||||
st_ymin |
classification_miss_rate |
|||||||
enum_key |
levenshtein_distance |
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 |