sqlite-presto-ext is a loadable SQLite extension that exposes a large MVP subset of Presto-style functions to SQLite.
- Builds a SQLite extension library from Rust (
libsqlite_presto_ext.{so,dylib}). - Registers Presto-like functions into SQLite using the
p_<presto_function_name>naming convention. - Covers numeric, bitwise, text/regex, binary/hash, URL/IP, UUID, and partial window/vector function surfaces.
cargo build -p sqlite-presto-ext --release
sqlite3 :memory: ".load ./target/release/libsqlite_presto_ext" "select p_lower('HeLLo');"On Linux use
.so; on macOS use.dylib.
This section tracks the full current Presto function list from the official docs and maps each function to SQLite extension support status.
Supported: exposed and bridged in this SQLite extensionStubbed: exposed asp_<function>but SQLite bridge is not implemented yetNo: not currently exposed by this extension
Note: if a function appears in multiple Presto categories, this document keeps a single row using its first category in the Presto functions index.
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
greatest |
No | Not currently exposed by this extension. |
least |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
coalesce |
No | Not currently exposed by this extension. |
if |
No | Not currently exposed by this extension. |
nullif |
No | Not currently exposed by this extension. |
try |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
cast |
No | Not currently exposed by this extension. |
parse_presto_data_size |
No | Not currently exposed by this extension. |
try_cast |
No | Not currently exposed by this extension. |
typeof |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
abs |
Supported | — |
acos |
Supported | — |
asin |
Supported | — |
atan |
Supported | — |
atan2 |
Supported | — |
beta_cdf |
Supported | — |
binomial_cdf |
Supported | — |
cauchy_cdf |
Supported | — |
cbrt |
Supported | — |
ceil |
Supported | — |
ceiling |
Supported | — |
chi_squared_cdf |
Supported | — |
cos |
Supported | — |
cosh |
Supported | — |
cosine_similarity |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
degrees |
Supported | — |
dot_product |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
e |
Supported | — |
exp |
Supported | — |
f_cdf |
Supported | — |
factorial |
Supported | — |
floor |
Supported | — |
from_base |
Supported | — |
gamma_cdf |
Supported | — |
infinity |
Supported | — |
inverse_beta_cdf |
Supported | — |
inverse_binomial_cdf |
Supported | — |
inverse_cauchy_cdf |
Supported | — |
inverse_chi_squared_cdf |
Supported | — |
inverse_f_cdf |
Supported | — |
inverse_gamma_cdf |
Supported | — |
inverse_laplace_cdf |
Supported | — |
inverse_normal_cdf |
Supported | — |
inverse_poisson_cdf |
Supported | — |
inverse_t_cdf |
Supported | — |
inverse_weibull_cdf |
Supported | — |
is_finite |
Supported | — |
is_infinite |
Supported | — |
is_nan |
Supported | — |
l2_squared |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
laplace_cdf |
Supported | — |
ln |
Supported | — |
log10 |
Supported | — |
log2 |
Supported | — |
mod |
Supported | — |
nan |
Supported | — |
normal_cdf |
Supported | — |
pi |
Supported | — |
poisson_cdf |
Supported | — |
pow |
Supported | — |
power |
Supported | — |
radians |
Supported | — |
rand |
Supported | Non-deterministic random output. |
random |
Supported | Non-deterministic random output. |
round |
Supported | — |
secure_rand |
Supported | Non-deterministic random output (OS RNG). |
secure_random |
Supported | Non-deterministic random output (OS RNG). |
sign |
Supported | — |
sin |
Supported | — |
sqrt |
Supported | — |
t_cdf |
Supported | — |
tan |
Supported | — |
tanh |
Supported | — |
to_base |
Supported | — |
truncate |
Supported | — |
weibull_cdf |
Supported | — |
width_bucket |
Supported | — |
wilson_interval_lower |
Supported | — |
wilson_interval_upper |
Supported | — |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
bit_count |
Supported | — |
bitwise_and |
Supported | — |
bitwise_arithmetic_shift_right |
Supported | — |
bitwise_left_shift |
Supported | — |
bitwise_logical_shift_right |
Supported | — |
bitwise_not |
Supported | — |
bitwise_or |
Supported | — |
bitwise_right_shift |
Supported | — |
bitwise_right_shift_arithmetic |
Supported | — |
bitwise_shift_left |
Supported | — |
bitwise_xor |
Supported | — |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
bit_length |
Supported | — |
chr |
Supported | — |
codepoint |
Supported | — |
concat |
Supported | Single p_concat bridge handles both text and blob forms. |
ends_with |
Supported | — |
from_utf8 |
Supported | — |
hamming_distance |
Supported | — |
jarowinkler_similarity |
Supported | — |
key_sampling_percent |
Supported | — |
length |
Supported | Single p_length bridge handles both text and blob forms. |
levenshtein_distance |
Supported | — |
longest_common_prefix |
Supported | — |
lower |
Supported | — |
lpad |
Supported | Single p_lpad bridge handles both text and blob forms. |
ltrim |
Supported | — |
normalize |
Supported | — |
position |
No | Not currently exposed by this extension. |
replace |
Supported | — |
replace_first |
Supported | — |
reverse |
Supported | Single p_reverse bridge handles both text and blob forms. |
rpad |
Supported | Single p_rpad bridge handles both text and blob forms. |
rtrim |
Supported | — |
split |
Supported | Returns comma-joined text instead of array in SQLite bridge. |
split_part |
Supported | — |
split_to_map |
No | Not currently exposed by this extension. |
split_to_multimap |
Supported | Returns encoded text (key=v1|v2;...) instead of map type. |
starts_with |
Supported | — |
strpos |
Supported | — |
strrpos |
Supported | — |
substr |
Supported | Single p_substr bridge handles both text and blob forms. |
to_utf8 |
Supported | — |
trail |
Supported | — |
trim |
Supported | — |
upper |
Supported | — |
word_stem |
Supported | — |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
regexp_extract |
Supported | Uses Rust regex engine (not full Java/Presto regex semantics). |
regexp_extract_all |
Supported | Returns comma-joined text instead of array in SQLite bridge. |
regexp_like |
Supported | Uses Rust regex engine (not full Java/Presto regex semantics). |
regexp_replace |
Supported | Lambda/function replacement overload is not implemented. |
regexp_split |
Supported | Returns comma-joined text instead of array in SQLite bridge. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
crc32 |
Supported | — |
from_base32 |
Supported | — |
from_base64 |
Supported | — |
from_base64url |
Supported | — |
from_big_endian_32 |
Supported | — |
from_big_endian_64 |
Supported | — |
from_hex |
Supported | — |
from_ieee754_32 |
Supported | — |
from_ieee754_64 |
Supported | — |
hmac_md5 |
Supported | — |
hmac_sha1 |
Supported | — |
hmac_sha256 |
Supported | — |
hmac_sha512 |
Supported | — |
md5 |
Supported | — |
murmur3_x64_128 |
Supported | — |
sha1 |
Supported | — |
sha256 |
Supported | — |
sha512 |
Supported | — |
spooky_hash_v2_32 |
Supported | — |
spooky_hash_v2_64 |
Supported | — |
to_base32 |
Supported | — |
to_base64 |
Supported | — |
to_base64url |
Supported | — |
to_big_endian_32 |
Supported | — |
to_big_endian_64 |
Supported | — |
to_hex |
Supported | — |
to_ieee754_32 |
Supported | — |
to_ieee754_64 |
Supported | — |
xxhash64 |
Supported | — |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
is_json_scalar |
No | Not currently exposed by this extension. |
json_array_contains |
No | Not currently exposed by this extension. |
json_array_get |
No | Not currently exposed by this extension. |
json_array_length |
No | Not currently exposed by this extension. |
json_extract |
No | Not currently exposed by this extension. |
json_extract_scalar |
No | Not currently exposed by this extension. |
json_format |
No | Not currently exposed by this extension. |
json_parse |
No | Not currently exposed by this extension. |
json_size |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
current_date |
No | Not currently exposed by this extension. |
current_time |
No | Not currently exposed by this extension. |
current_timestamp |
No | Not currently exposed by this extension. |
current_timezone |
No | Not currently exposed by this extension. |
date |
No | Not currently exposed by this extension. |
date_add |
No | Not currently exposed by this extension. |
date_diff |
No | Not currently exposed by this extension. |
date_format |
No | Not currently exposed by this extension. |
date_parse |
No | Not currently exposed by this extension. |
date_trunc |
No | Not currently exposed by this extension. |
day |
No | Not currently exposed by this extension. |
day_of_month |
No | Not currently exposed by this extension. |
day_of_week |
No | Not currently exposed by this extension. |
day_of_year |
No | Not currently exposed by this extension. |
dow |
No | Not currently exposed by this extension. |
doy |
No | Not currently exposed by this extension. |
extract |
No | Not currently exposed by this extension. |
format_datetime |
No | Not currently exposed by this extension. |
from_iso8601_date |
No | Not currently exposed by this extension. |
from_iso8601_timestamp |
No | Not currently exposed by this extension. |
from_unixtime |
No | Not currently exposed by this extension. |
hour |
No | Not currently exposed by this extension. |
last_day_of_month |
No | Not currently exposed by this extension. |
localtime |
No | Not currently exposed by this extension. |
localtimestamp |
No | Not currently exposed by this extension. |
millisecond |
No | Not currently exposed by this extension. |
minute |
No | Not currently exposed by this extension. |
month |
No | Not currently exposed by this extension. |
now |
No | Not currently exposed by this extension. |
parse_datetime |
No | Not currently exposed by this extension. |
parse_duration |
No | Not currently exposed by this extension. |
quarter |
No | Not currently exposed by this extension. |
second |
No | Not currently exposed by this extension. |
timezone_hour |
No | Not currently exposed by this extension. |
timezone_minute |
No | Not currently exposed by this extension. |
to_iso8601 |
No | Not currently exposed by this extension. |
to_milliseconds |
No | Not currently exposed by this extension. |
to_unixtime |
No | Not currently exposed by this extension. |
week |
No | Not currently exposed by this extension. |
week_of_year |
No | Not currently exposed by this extension. |
year |
No | Not currently exposed by this extension. |
year_of_week |
No | Not currently exposed by this extension. |
yow |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
any_value |
No | Not currently exposed by this extension. |
approx_distinct |
No | Not currently exposed by this extension. |
approx_most_frequent |
No | Not currently exposed by this extension. |
approx_percentile |
No | Not currently exposed by this extension. |
approx_set |
No | Not currently exposed by this extension. |
arbitrary |
No | Not currently exposed by this extension. |
array_agg |
No | Not currently exposed by this extension. |
avg |
No | Not currently exposed by this extension. |
bitwise_and_agg |
No | Not currently exposed by this extension. |
bitwise_or_agg |
No | Not currently exposed by this extension. |
bitwise_xor_agg |
No | Not currently exposed by this extension. |
bool_and |
No | Not currently exposed by this extension. |
bool_or |
No | Not currently exposed by this extension. |
checksum |
No | Not currently exposed by this extension. |
classification_fall_out |
No | Not currently exposed by this extension. |
classification_miss_rate |
No | Not currently exposed by this extension. |
classification_precision |
No | Not currently exposed by this extension. |
classification_recall |
No | Not currently exposed by this extension. |
classification_thresholds |
No | Not currently exposed by this extension. |
corr |
No | Not currently exposed by this extension. |
count |
No | Not currently exposed by this extension. |
count_if |
No | Not currently exposed by this extension. |
covar_pop |
No | Not currently exposed by this extension. |
covar_samp |
No | Not currently exposed by this extension. |
differential_entropy |
No | Not currently exposed by this extension. |
entropy |
No | Not currently exposed by this extension. |
every |
No | Not currently exposed by this extension. |
geometric_mean |
No | Not currently exposed by this extension. |
histogram |
No | Not currently exposed by this extension. |
khyperloglog_agg |
No | Not currently exposed by this extension. |
kurtosis |
No | Not currently exposed by this extension. |
map_agg |
No | Not currently exposed by this extension. |
map_union |
No | Not currently exposed by this extension. |
map_union_sum |
No | Not currently exposed by this extension. |
max |
No | Not currently exposed by this extension. |
max_by |
No | Not currently exposed by this extension. |
merge |
No | Not currently exposed by this extension. |
min |
No | Not currently exposed by this extension. |
min_by |
No | Not currently exposed by this extension. |
multimap_agg |
No | Not currently exposed by this extension. |
numeric_histogram |
No | Not currently exposed by this extension. |
qdigest_agg |
No | Not currently exposed by this extension. |
reduce_agg |
No | Not currently exposed by this extension. |
regr_avgx |
No | Not currently exposed by this extension. |
regr_avgy |
No | Not currently exposed by this extension. |
regr_count |
No | Not currently exposed by this extension. |
regr_intercept |
No | Not currently exposed by this extension. |
regr_r2 |
No | Not currently exposed by this extension. |
regr_slope |
No | Not currently exposed by this extension. |
regr_sxx |
No | Not currently exposed by this extension. |
regr_sxy |
No | Not currently exposed by this extension. |
regr_syy |
No | Not currently exposed by this extension. |
reservoir_sample |
No | Not currently exposed by this extension. |
set_agg |
No | Not currently exposed by this extension. |
set_union |
No | Not currently exposed by this extension. |
skewness |
No | Not currently exposed by this extension. |
stddev |
No | Not currently exposed by this extension. |
stddev_pop |
No | Not currently exposed by this extension. |
stddev_samp |
No | Not currently exposed by this extension. |
sum |
No | Not currently exposed by this extension. |
var_pop |
No | Not currently exposed by this extension. |
var_samp |
No | Not currently exposed by this extension. |
variance |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
cardinality |
No | Not currently exposed by this extension. |
merge_sfm |
No | Not currently exposed by this extension. |
noisy_approx_distinct_sfm |
No | Not currently exposed by this extension. |
noisy_approx_set_sfm |
No | Not currently exposed by this extension. |
noisy_approx_set_sfm_from_index_and_zeros |
No | Not currently exposed by this extension. |
noisy_avg_gaussian |
No | Not currently exposed by this extension. |
noisy_count_gaussian |
No | Not currently exposed by this extension. |
noisy_count_if_gaussian |
No | Not currently exposed by this extension. |
noisy_empty_approx_set_sfm |
No | Not currently exposed by this extension. |
noisy_sum_gaussian |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
cume_dist |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
dense_rank |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
first_value |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
lag |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
last_value |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
lead |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
nth_value |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
ntile |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
percent_rank |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
rank |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
row_number |
Stubbed | Registered name exists, but SQLite argument/result bridge is not implemented yet (stub returns error). |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
all_match |
No | Not currently exposed by this extension. |
any_match |
No | Not currently exposed by this extension. |
array_average |
No | Not currently exposed by this extension. |
array_cum_sum |
No | Not currently exposed by this extension. |
array_distinct |
No | Not currently exposed by this extension. |
array_duplicates |
No | Not currently exposed by this extension. |
array_except |
No | Not currently exposed by this extension. |
array_frequency |
No | Not currently exposed by this extension. |
array_has_duplicates |
No | Not currently exposed by this extension. |
array_intersect |
No | Not currently exposed by this extension. |
array_join |
No | Not currently exposed by this extension. |
array_least_frequent |
No | Not currently exposed by this extension. |
array_max |
No | Not currently exposed by this extension. |
array_max_by |
No | Not currently exposed by this extension. |
array_min |
No | Not currently exposed by this extension. |
array_min_by |
No | Not currently exposed by this extension. |
array_normalize |
No | Not currently exposed by this extension. |
array_position |
No | Not currently exposed by this extension. |
array_remove |
No | Not currently exposed by this extension. |
array_sort |
No | Not currently exposed by this extension. |
array_sort_desc |
No | Not currently exposed by this extension. |
array_split_into_chunks |
No | Not currently exposed by this extension. |
array_sum |
No | Not currently exposed by this extension. |
array_top_n |
No | Not currently exposed by this extension. |
array_transpose |
No | Not currently exposed by this extension. |
array_union |
No | Not currently exposed by this extension. |
arrays_overlap |
No | Not currently exposed by this extension. |
combinations |
No | Not currently exposed by this extension. |
contains |
No | Not currently exposed by this extension. |
element_at |
No | Not currently exposed by this extension. |
filter |
No | Not currently exposed by this extension. |
find_first |
No | Not currently exposed by this extension. |
find_first_index |
No | Not currently exposed by this extension. |
flatten |
No | Not currently exposed by this extension. |
ngrams |
No | Not currently exposed by this extension. |
none_match |
No | Not currently exposed by this extension. |
reduce |
No | Not currently exposed by this extension. |
remove_nulls |
No | Not currently exposed by this extension. |
repeat |
No | Not currently exposed by this extension. |
sequence |
No | Not currently exposed by this extension. |
shuffle |
No | Not currently exposed by this extension. |
slice |
No | Not currently exposed by this extension. |
transform |
No | Not currently exposed by this extension. |
trim_array |
No | Not currently exposed by this extension. |
zip |
No | Not currently exposed by this extension. |
zip_with |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
all_keys_match |
No | Not currently exposed by this extension. |
any_keys_match |
No | Not currently exposed by this extension. |
any_values_match |
No | Not currently exposed by this extension. |
array_to_map_int_keys |
No | Not currently exposed by this extension. |
map |
No | Not currently exposed by this extension. |
map_concat |
No | Not currently exposed by this extension. |
map_entries |
No | Not currently exposed by this extension. |
map_filter |
No | Not currently exposed by this extension. |
map_from_entries |
No | Not currently exposed by this extension. |
map_int_keys_to_array |
No | Not currently exposed by this extension. |
map_key_exists |
No | Not currently exposed by this extension. |
map_keys |
No | Not currently exposed by this extension. |
map_keys_by_top_n_values |
No | Not currently exposed by this extension. |
map_normalize |
No | Not currently exposed by this extension. |
map_remove_null_values |
No | Not currently exposed by this extension. |
map_subset |
No | Not currently exposed by this extension. |
map_top_n |
No | Not currently exposed by this extension. |
map_top_n_keys |
No | Not currently exposed by this extension. |
map_top_n_values |
No | Not currently exposed by this extension. |
map_values |
No | Not currently exposed by this extension. |
map_zip_with |
No | Not currently exposed by this extension. |
multimap_from_entries |
No | Not currently exposed by this extension. |
no_keys_match |
No | Not currently exposed by this extension. |
no_values_match |
No | Not currently exposed by this extension. |
transform_keys |
No | Not currently exposed by this extension. |
transform_values |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
url_decode |
Supported | — |
url_encode |
Supported | — |
url_extract_fragment |
Supported | — |
url_extract_host |
Supported | — |
url_extract_parameter |
Supported | — |
url_extract_path |
Supported | — |
url_extract_port |
Supported | — |
url_extract_protocol |
Supported | — |
url_extract_query |
Supported | — |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
ip_prefix |
Supported | — |
ip_prefix_collapse |
Supported | Input/output arrays are represented as comma-joined text. |
ip_prefix_subnets |
Supported | Returns comma-joined text instead of array type. |
ip_subnet_max |
Supported | — |
ip_subnet_min |
Supported | — |
ip_subnet_range |
Supported | Returns comma-joined text instead of array type. |
is_private_ip |
Supported | — |
is_subnet_of |
Supported | — |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
bing_tile |
No | Not currently exposed by this extension. |
bing_tile_at |
No | Not currently exposed by this extension. |
bing_tile_children |
No | Not currently exposed by this extension. |
bing_tile_coordinates |
No | Not currently exposed by this extension. |
bing_tile_parent |
No | Not currently exposed by this extension. |
bing_tile_polygon |
No | Not currently exposed by this extension. |
bing_tile_quadkey |
No | Not currently exposed by this extension. |
bing_tile_zoom_level |
No | Not currently exposed by this extension. |
bing_tiles_around |
No | Not currently exposed by this extension. |
convex_hull_agg |
No | Not currently exposed by this extension. |
expand_envelope |
No | Not currently exposed by this extension. |
flatten_geometry_collections |
No | Not currently exposed by this extension. |
geometry_as_geojson |
No | Not currently exposed by this extension. |
geometry_from_geojson |
No | Not currently exposed by this extension. |
geometry_invalid_reason |
No | Not currently exposed by this extension. |
geometry_nearest_points |
No | Not currently exposed by this extension. |
geometry_to_bing_tiles |
No | Not currently exposed by this extension. |
geometry_to_dissolved_bing_tiles |
No | Not currently exposed by this extension. |
geometry_union |
No | Not currently exposed by this extension. |
geometry_union_agg |
No | Not currently exposed by this extension. |
great_circle_distance |
No | Not currently exposed by this extension. |
line_interpolate_point |
No | Not currently exposed by this extension. |
line_locate_point |
No | Not currently exposed by this extension. |
simplify_geometry |
No | Not currently exposed by this extension. |
st_area |
No | Not currently exposed by this extension. |
st_asbinary |
No | Not currently exposed by this extension. |
st_astext |
No | Not currently exposed by this extension. |
st_boundary |
No | Not currently exposed by this extension. |
st_buffer |
No | Not currently exposed by this extension. |
st_centroid |
No | Not currently exposed by this extension. |
st_contains |
No | Not currently exposed by this extension. |
st_convexhull |
No | Not currently exposed by this extension. |
st_coorddim |
No | Not currently exposed by this extension. |
st_crosses |
No | Not currently exposed by this extension. |
st_difference |
No | Not currently exposed by this extension. |
st_dimension |
No | Not currently exposed by this extension. |
st_disjoint |
No | Not currently exposed by this extension. |
st_distance |
No | Not currently exposed by this extension. |
st_endpoint |
No | Not currently exposed by this extension. |
st_envelope |
No | Not currently exposed by this extension. |
st_envelopeaspts |
No | Not currently exposed by this extension. |
st_equals |
No | Not currently exposed by this extension. |
st_exteriorring |
No | Not currently exposed by this extension. |
st_geometries |
No | Not currently exposed by this extension. |
st_geometryfromtext |
No | Not currently exposed by this extension. |
st_geometryn |
No | Not currently exposed by this extension. |
st_geometrytype |
No | Not currently exposed by this extension. |
st_geomfrombinary |
No | Not currently exposed by this extension. |
st_interiorringn |
No | Not currently exposed by this extension. |
st_interiorrings |
No | Not currently exposed by this extension. |
st_intersection |
No | Not currently exposed by this extension. |
st_intersects |
No | Not currently exposed by this extension. |
st_isclosed |
No | Not currently exposed by this extension. |
st_isempty |
No | Not currently exposed by this extension. |
st_isring |
No | Not currently exposed by this extension. |
st_issimple |
No | Not currently exposed by this extension. |
st_isvalid |
No | Not currently exposed by this extension. |
st_length |
No | Not currently exposed by this extension. |
st_linefromtext |
No | Not currently exposed by this extension. |
st_linestring |
No | Not currently exposed by this extension. |
st_multipoint |
No | Not currently exposed by this extension. |
st_numgeometries |
No | Not currently exposed by this extension. |
st_numinteriorring |
No | Not currently exposed by this extension. |
st_numpoints |
No | Not currently exposed by this extension. |
st_overlaps |
No | Not currently exposed by this extension. |
st_point |
No | Not currently exposed by this extension. |
st_pointn |
No | Not currently exposed by this extension. |
st_points |
No | Not currently exposed by this extension. |
st_polygon |
No | Not currently exposed by this extension. |
st_relate |
No | Not currently exposed by this extension. |
st_startpoint |
No | Not currently exposed by this extension. |
st_symdifference |
No | Not currently exposed by this extension. |
st_touches |
No | Not currently exposed by this extension. |
st_union |
No | Not currently exposed by this extension. |
st_within |
No | Not currently exposed by this extension. |
st_x |
No | Not currently exposed by this extension. |
st_xmax |
No | Not currently exposed by this extension. |
st_xmin |
No | Not currently exposed by this extension. |
st_y |
No | Not currently exposed by this extension. |
st_ymax |
No | Not currently exposed by this extension. |
st_ymin |
No | Not currently exposed by this extension. |
to_geometry |
No | Not currently exposed by this extension. |
to_spherical_geography |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
empty_approx_set |
No | Not currently exposed by this extension. |
merge_hll |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
intersection_cardinality |
No | Not currently exposed by this extension. |
jaccard_index |
No | Not currently exposed by this extension. |
merge_khll |
No | Not currently exposed by this extension. |
reidentification_potential |
No | Not currently exposed by this extension. |
uniqueness_distribution |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
quantile_at_value |
No | Not currently exposed by this extension. |
scale_qdigest |
No | Not currently exposed by this extension. |
value_at_quantile |
No | Not currently exposed by this extension. |
values_at_quantiles |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
uuid |
Supported | Non-deterministic (generates a new UUID each call). |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
construct_tdigest |
No | Not currently exposed by this extension. |
destructure_tdigest |
No | Not currently exposed by this extension. |
merge_tdigest |
No | Not currently exposed by this extension. |
quantiles_at_values |
No | Not currently exposed by this extension. |
scale_tdigest |
No | Not currently exposed by this extension. |
tdigest_agg |
No | Not currently exposed by this extension. |
trimmed_mean |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
bar |
No | Not currently exposed by this extension. |
color |
No | Not currently exposed by this extension. |
render |
No | Not currently exposed by this extension. |
rgb |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
current_user |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
char2hexint |
No | Not currently exposed by this extension. |
index |
No | Not currently exposed by this extension. |
substring |
No | Not currently exposed by this extension. |
to_char |
No | Not currently exposed by this extension. |
to_date |
No | Not currently exposed by this extension. |
to_timestamp |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
myanmar_font_encoding |
No | Not currently exposed by this extension. |
myanmar_normalize_unicode |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
hash_counts |
No | Not currently exposed by this extension. |
make_set_digest |
No | Not currently exposed by this extension. |
merge_set_digest |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
sketch_kll |
No | Not currently exposed by this extension. |
sketch_kll_quantile |
No | Not currently exposed by this extension. |
sketch_kll_rank |
No | Not currently exposed by this extension. |
sketch_kll_with_k |
No | Not currently exposed by this extension. |
sketch_theta |
No | Not currently exposed by this extension. |
sketch_theta_estimate |
No | Not currently exposed by this extension. |
sketch_theta_summary |
No | Not currently exposed by this extension. |
| Function (Presto docs) | SQLite extension status | Comments |
|---|---|---|
pinot_binary_decimal_to_double |
No | Not currently exposed by this extension. |
Summary: 510 Presto functions total, 162 supported, 14 stubbed, 334 not exposed.