Applies to VAST Cluster 5.5.
Every function name in the VAST Query Engine on VAST Cluster 5.5. Available functions link to their page. For the others, the table says why they aren't available and, where there's one, what to use instead.
| Name | Available | Page, or why not |
|---|---|---|
!~ |
Yes | regexp_full_match (same as regexp_full_match) |
!~~ |
Yes | LIKE and NOT LIKE (same as LIKE and NOT LIKE) |
!~~* |
Yes | ILIKE and NOT ILIKE (same as ILIKE and NOT ILIKE) |
% |
Yes | % (modulo) |
& |
Yes | & (bitwise AND) |
&& |
Yes | list_has_any (same as list_has_any) |
(a, b, ...) |
Yes | row (same as row) |
* |
Yes | * (multiply an interval) |
** |
Yes | pow (same as pow) |
+ |
Yes | + (add a date or interval) |
+a |
Yes | + (addition) (same as +) |
- |
Yes | - (subtract a date or interval) |
-> |
Yes | json_extract (same as json_extract) |
->> |
Yes | json_extract_string (same as json_extract_string) |
-a |
Yes | - (subtraction and negation) (same as -) |
/ |
Yes | / (divide an interval) |
// |
Yes | // (integer division) |
<< |
Yes | << (shift left) |
<@ |
Yes | list_has_all (same as list_has_all) |
>> |
Yes | >> (shift right) |
@ |
Yes | abs (same as abs) |
@> |
Yes | list_has_all (same as list_has_all) |
[...] |
Yes | list_value (same as list_value) |
^ |
Yes | pow (same as pow) |
^@ |
Yes | starts_with (same as starts_with) |
a * b |
Yes | * (multiplication) (same as *) |
a - b |
Yes | - (subtraction and negation) (same as -) |
abs |
Yes | abs |
acos |
Yes | acos |
acosh |
Yes | acosh |
add |
Yes | list_concat (same as list_concat) |
add(a) |
Yes | + (addition) (same as +) |
add(a, b) |
Yes | + (add a date or interval) (same as +) |
age |
Yes | age |
aggregate |
Yes | list_aggregate (same as list_aggregate) |
any_value |
Yes | any_value |
apply |
Yes | list_transform (same as list_transform) |
approx_count_distinct |
Yes | approx_count_distinct |
approx_quantile |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark, or the list functions on a list column |
approx_top_k |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
arbitrary |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
arg_max |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
arg_max_null |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
arg_min |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
arg_min_null |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
argmax |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
argmin |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
ARRAY[...] |
Yes | list_value (same as list_value) |
array_agg |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
array_aggr |
Yes | list_aggregate (same as list_aggregate) |
array_aggregate |
Yes | list_aggregate (same as list_aggregate) |
array_append |
Yes | list_append (same as list_append) |
array_apply |
Yes | list_transform (same as list_transform) |
array_cat |
Yes | list_concat (same as list_concat) |
array_concat |
Yes | list_concat (same as list_concat) |
array_contains |
Yes | list_contains (same as list_contains) |
array_cosine_distance |
Yes | array_cosine_distance |
array_distance |
Yes | array_distance |
array_distinct |
Yes | list_distinct (same as list_distinct) |
array_extract |
Yes | list_extract (same as list_extract) |
array_extract(s, 'field') |
Yes | struct_extract (same as struct_extract) |
array_filter |
Yes | list_filter (same as list_filter) |
array_grade_up |
Yes | list_grade_up (same as list_grade_up) |
array_has |
Yes | list_contains (same as list_contains) |
array_has_all |
Yes | list_has_all (same as list_has_all) |
array_has_any |
Yes | list_has_any (same as list_has_any) |
array_indexof |
Yes | list_position (same as list_position) |
array_intersect |
Yes | list_intersect (same as list_intersect) |
array_length |
Yes | array_length |
array_negative_inner_product |
Yes | array_negative_inner_product |
array_pop_back |
Yes | array_pop_back |
array_pop_front |
Yes | array_pop_front |
array_position |
Yes | list_position (same as list_position) |
array_prepend |
Yes | list_prepend (same as list_prepend) |
array_push_back |
Yes | list_append (same as list_append) |
array_push_front |
Yes | list_prepend (same as list_prepend) |
array_reduce |
Yes | list_reduce (same as list_reduce) |
array_resize |
Yes | list_resize (same as list_resize) |
array_reverse |
Yes | list_reverse (same as list_reverse) |
array_reverse_sort |
Yes | list_reverse_sort (same as list_reverse_sort) |
array_select |
Yes | list_select (same as list_select) |
array_slice |
Yes | list_slice (same as list_slice) |
array_sort |
Yes | list_sort (same as list_sort) |
array_to_json |
Yes | array_to_json |
array_to_string |
Yes | array_to_string |
array_to_string(list, ',') |
Yes | array_to_string (same as array_to_string) |
array_to_string_comma_default(list) |
Yes | array_to_string (same as array_to_string) |
array_transform |
Yes | list_transform (same as list_transform) |
array_unique |
Yes | list_unique (same as list_unique) |
array_value |
Yes | array_value |
array_where |
Yes | list_where (same as list_where) |
array_zip |
Yes | list_zip (same as list_zip) |
ascii |
Yes | ascii |
asin |
Yes | asin |
asinh |
Yes | asinh |
atan |
Yes | atan |
atan2 |
Yes | atan2 |
atanh |
Yes | atanh |
avg |
Yes | avg |
bar |
Yes | bar |
base64 |
Yes | to_base64 (same as to_base64) |
BIGINT |
No | Not available in the VAST Query Engine. Instead: Cast first: factorial(CAST(b AS INTEGER)), format_bytes(CAST(x AS BIGINT)) |
bin |
Yes | bin |
BIT |
No | Not available in the VAST Query Engine. Instead: Store the bits as a VARCHAR of 0s and 1s, or an integer, and the enum as VARCHAR; cast in the query |
BIT values and casts |
Yes | BIT values and casts |
bit_and |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
bit_count |
Yes | bit_count |
bit_length |
Yes | bit_length |
bit_or |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
bit_position |
Yes | bit_position |
bit_xor |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
bitstring |
Yes | bitstring |
bitstring_agg |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
Bitwise operators on BIT values |
Yes | Bitwise operators on BIT values |
BLOB |
No | Not available in the VAST Query Engine. Instead: octet_length(), or decode() to VARCHAR first |
BLOB values, comparisons and || |
Yes | BLOB values, comparisons and || |
bool_and |
Yes | bool_and |
bool_or |
Yes | bool_or |
btrim |
No | Not available in the VAST Query Engine. Instead: trim(s, chars) |
can_cast_implicitly |
Yes | can_cast_implicitly |
cardinality |
Yes | cardinality |
CASE |
Yes | CASE |
CAST and :: |
Yes | CAST and :: |
cbrt |
Yes | cbrt |
ceil |
Yes | ceil |
ceiling |
Yes | ceil (same as ceil) |
century |
Yes | century |
char_length |
No | Not available in the VAST Query Engine. Instead: length |
character_length |
No | Not available in the VAST Query Engine. Instead: length |
charindex |
No | Not available in the VAST Query Engine. Instead: strpos(s, substring) or position(substring IN s) |
chr |
Yes | chr |
coalesce |
Yes | coalesce |
COLLATE nocase and noaccent |
Yes | COLLATE nocase and noaccent |
combine |
No | Fails in the VAST Query Engine. |
concat |
Yes | concat |
concat_ws |
Yes | concat_ws |
contains |
Yes | list_contains (same as list_contains) |
corr |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
cos |
Yes | cos |
cosh |
Yes | cosh |
cot |
Yes | cot |
count |
Yes | count |
count() |
Yes | count (same as count) |
count(*) |
Yes | count (same as count) |
count(ALL x) |
Yes | count (same as count) |
count(x) |
Yes | count (same as count) |
count_if |
Yes | count_if |
count_star() |
Yes | count (same as count) |
countif |
Yes | count_if (same as count_if) |
covar_pop |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
covar_samp |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
crc32 |
No | Not available in the VAST Query Engine. Instead: sha256(), or compute them in your code |
create_sort_key |
Yes | create_sort_key |
current_date |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. Instead: CAST(CAST(now() AS TIMESTAMP) AS DATE), or CAST(now() AS TIMESTAMP) |
current_localtime |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. Instead: CAST(CAST(now() AS TIMESTAMP) AS DATE), or CAST(now() AS TIMESTAMP) |
current_localtimestamp |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. Instead: CAST(CAST(now() AS TIMESTAMP) AS DATE), or CAST(now() AS TIMESTAMP) |
current_query |
No | Fails in the VAST Query Engine. |
current_setting |
Yes | current_setting |
current_time |
No | Not available in the VAST Query Engine. Instead: CAST(CAST(now() AS TIMESTAMP) AS DATE), or CAST(now() AS TIMESTAMP) |
current_timestamp |
Yes | now (same as now) |
currval |
No | Not available in the VAST Query Engine. |
damerau_levenshtein |
Yes | damerau_levenshtein |
DATE |
No | Not available in the VAST Query Engine. Instead: Not needed: TIMESTAMP values have no zone |
date_add |
Yes | date_add |
date_diff |
Yes | date_diff |
date_part |
Yes | date_part |
date_part('day', value) |
Yes | day (same as day) |
date_part('part', value) |
Yes | date_part (same as date_part) |
date_sub |
Yes | date_sub |
date_trunc |
Yes | date_trunc |
datediff |
Yes | date_diff (same as date_diff) |
datepart |
Yes | date_part (same as date_part) |
datesub |
Yes | date_sub (same as date_sub) |
datetrunc |
Yes | date_trunc (same as date_trunc) |
day |
Yes | day |
dayname |
Yes | dayname |
dayofmonth |
Yes | day (same as day) |
dayofweek |
Yes | dayofweek |
dayofyear |
Yes | dayofyear |
decade |
Yes | decade |
DECIMAL |
No | Not available in the VAST Query Engine. Instead: Cast to DOUBLE: round(d::DOUBLE, n) |
decode |
Yes | decode |
degrees |
Yes | degrees |
DISTINCT |
No | Not available in the VAST Query Engine. Instead: approx_count_distinct(x), or Trino or Spark |
divide |
Yes | divide |
DOUBLE |
No | Not available in the VAST Query Engine. Instead: Cast first: factorial(CAST(b AS INTEGER)), format_bytes(CAST(x AS BIGINT)) |
editdist3 |
Yes | levenshtein (same as levenshtein) |
element_at |
Yes | map_extract (same as map_extract) |
encode |
Yes | encode |
ends_with |
Yes | ends_with |
entropy |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
ENUM |
No | Not available in the VAST Query Engine. Instead: Store the bits as a VARCHAR of 0s and 1s, or an integer, and the enum as VARCHAR; cast in the query |
enum_code |
Yes | enum_code |
enum_first |
Yes | enum_first |
enum_last |
Yes | enum_last |
enum_range |
Yes | enum_range |
enum_range_boundary |
Yes | enum_range_boundary |
epoch |
Yes | epoch |
epoch_ms |
Yes | epoch_ms |
epoch_ns |
Yes | epoch_ns |
epoch_us |
Yes | epoch_us |
equi_width_bins |
Yes | equi_width_bins |
era |
Yes | era |
error |
Yes | error |
even |
Yes | even |
exp |
Yes | exp |
extract(day FROM value) |
Yes | day (same as day) |
extract(part FROM value) |
Yes | date_part (same as date_part) |
factorial |
Yes | factorial |
favg |
No | Not available as an aggregate in the VAST Query Engine. Instead: sum() on DECIMAL values, which is exact |
fdiv |
Yes | fdiv |
FILTER |
Yes | FILTER (WHERE ...) |
filter |
Yes | list_filter (same as list_filter) |
finalize |
No | Fails in the VAST Query Engine. |
first |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
flatten |
Yes | flatten |
floor |
Yes | floor |
fmod |
Yes | fmod |
format |
Yes | format |
format_bytes |
Yes | format_bytes |
format_type |
No | Fails in the VAST Query Engine (operator not supported). |
formatReadableDecimalSize |
Yes | formatReadableDecimalSize |
formatReadableSize |
Yes | format_bytes (same as format_bytes) |
from_base64 |
Yes | from_base64 |
from_binary |
Yes | from_binary |
from_hex |
Yes | from_hex |
from_json |
Yes | json_transform (same as json_transform) |
from_json_strict |
Yes | json_transform_strict (same as json_transform_strict) |
fsum |
No | Not available as an aggregate in the VAST Query Engine. Instead: sum() on DECIMAL values, which is exact |
gamma |
Yes | gamma |
gcd |
Yes | gcd |
gen_random_uuid |
Yes | gen_random_uuid |
generate_series |
Yes | generate_series |
geomean |
Yes | geomean |
geometric_mean |
Yes | geomean (same as geomean) |
get_bit |
Yes | get_bit |
get_block_size |
No | Fails in the VAST Query Engine (operator not supported). |
get_current_time |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. Instead: CAST(CAST(now() AS TIMESTAMP) AS DATE), or CAST(now() AS TIMESTAMP) |
get_current_timestamp |
Yes | now (same as now) |
getvariable |
Yes | getvariable |
GLOB |
Yes | GLOB |
glob |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Read the objects through S3 with your client |
grade_up |
Yes | list_grade_up (same as list_grade_up) |
greatest |
Yes | greatest |
greatest_common_divisor |
Yes | gcd (same as gcd) |
group_concat |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
hamming |
Yes | hamming |
hash |
Yes | hash |
hex |
Yes | hex |
histogram |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
histogram_exact |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
hour |
Yes | hour |
icu_collate_af |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_am |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ar |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ar_sa |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_as |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_az |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_be |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_bg |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_bn |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_bo |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_br |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_bs |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ca |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ceb |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_chr |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_cs |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_cy |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_da |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_de |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_de_at |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_dsb |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_dz |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ee |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_el |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_en |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_en_us |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_eo |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_es |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_et |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_fa |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_fa_af |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ff |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_fi |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_fil |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_fo |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_fr |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_fr_ca |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_fy |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ga |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_gl |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_gu |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ha |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_haw |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_he |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_he_il |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_hi |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_hr |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_hsb |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_hu |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_hy |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_id |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_id_id |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ig |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_is |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_it |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ja |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ka |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_kk |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_kl |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_km |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_kn |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ko |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_kok |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ku |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ky |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_lb |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_lkt |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ln |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_lo |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_lt |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_lv |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_mk |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ml |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_mn |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_mr |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ms |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_mt |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_my |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_nb |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_nb_no |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ne |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_nl |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_nn |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_noaccent |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_om |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_or |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_pa |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_pa_in |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_pl |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ps |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_pt |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ro |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ru |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sa |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_se |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_si |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sk |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sl |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_smn |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sq |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sr |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sr_ba |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sr_me |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sr_rs |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sv |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_sw |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ta |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_te |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_th |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_tk |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_to |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_tr |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ug |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_uk |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_ur |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_uz |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_vi |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_wae |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_wo |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_xh |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_yi |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_yo |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_yue |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_yue_cn |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_zh |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_zh_cn |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_zh_hk |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_zh_mo |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_zh_sg |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_zh_tw |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_collate_zu |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. |
icu_sort_key |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. Instead: COLLATE nocase or COLLATE noaccent, or Trino or Spark |
if |
Yes | if |
iff |
No | Not available in the VAST Query Engine. Instead: if or CASE |
ifnull |
Yes | ifnull |
ILIKE |
Yes | ILIKE and NOT ILIKE (same as ILIKE and NOT ILIKE) |
ILIKE and NOT ILIKE |
Yes | ILIKE and NOT ILIKE |
ilike_escape |
Yes | ilike_escape |
IN |
No | Not available in the VAST Query Engine. Instead: ORs on the same column, which push down |
in_search_path |
Yes | in_search_path |
initcap |
No | Not available in the VAST Query Engine. Instead: Your client code, or Trino or Spark |
instr |
Yes | strpos (same as strpos) |
INTERVAL |
No | Not available in the VAST Query Engine. Instead: Cast the value to TIMESTAMP first |
isfinite |
Yes | isfinite |
isinf |
Yes | isinf |
isnan |
Yes | isnan |
isodow |
Yes | isodow |
isoyear |
Yes | isoyear |
jaccard |
Yes | jaccard |
jaro_similarity |
Yes | jaro_similarity |
jaro_winkler_similarity |
Yes | jaro_winkler_similarity |
json |
Yes | json |
json_array |
Yes | json_array |
json_array_length |
Yes | json_array_length |
json_contains |
Yes | json_contains |
json_deserialize_sql |
Yes | json_deserialize_sql |
json_exists |
Yes | json_exists |
json_extract |
Yes | json_extract |
json_extract_path |
Yes | json_extract (same as json_extract) |
json_extract_path_text |
Yes | json_extract_string (same as json_extract_string) |
json_extract_string |
Yes | json_extract_string |
json_group_array |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
json_group_object |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
json_group_structure |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
json_keys |
Yes | json_keys |
json_merge_patch |
Yes | json_merge_patch |
json_object |
Yes | json_object |
json_pretty |
Yes | json_pretty |
json_quote |
Yes | json_quote |
json_serialize_sql |
Yes | json_serialize_sql |
json_structure |
Yes | json_structure |
json_transform |
Yes | json_transform |
json_transform_strict |
Yes | json_transform_strict |
json_type |
Yes | json_type |
json_valid |
Yes | json_valid |
json_value |
Yes | json_value |
julian |
Yes | julian |
kahan_sum |
No | Not available as an aggregate in the VAST Query Engine. Instead: sum() on DECIMAL values, which is exact |
kurtosis |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
kurtosis_pop |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
last |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
last_day |
Yes | last_day |
lcase |
Yes | lower (same as lower) |
lcm |
Yes | lcm |
least |
Yes | least |
least_common_multiple |
Yes | lcm (same as lcm) |
left |
Yes | left |
left_grapheme |
Yes | left_grapheme |
len |
Yes | length (same as length) |
length |
Yes | length |
length_grapheme |
Yes | length_grapheme |
levenshtein |
Yes | levenshtein |
lgamma |
Yes | lgamma |
LIKE |
Yes | LIKE and NOT LIKE (same as LIKE and NOT LIKE) |
LIKE and NOT LIKE |
Yes | LIKE and NOT LIKE |
like_escape |
Yes | like_escape |
list |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
List comprehensions |
Yes | List comprehensions |
list[begin:end:step] |
Yes | list_slice (same as list_slice) |
list[begin:end] |
Yes | list_slice (same as list_slice) |
list[index] |
Yes | list_extract (same as list_extract) |
list_aggr |
Yes | list_aggregate (same as list_aggregate) |
list_aggregate |
Yes | list_aggregate |
list_any_value |
Yes | list_any_value |
list_append |
Yes | list_append |
list_apply |
Yes | list_transform (same as list_transform) |
list_approx_count_distinct |
Yes | list_approx_count_distinct |
list_avg |
Yes | list_avg |
list_bit_and |
Yes | list_bit_and |
list_bit_or |
Yes | list_bit_or |
list_bit_xor |
Yes | list_bit_xor |
list_bool_and |
Yes | list_bool_and |
list_bool_or |
Yes | list_bool_or |
list_cat |
Yes | list_concat (same as list_concat) |
list_concat |
Yes | list_concat |
list_contains |
Yes | list_contains |
list_count |
Yes | list_count |
list_distinct |
Yes | list_distinct |
list_element |
Yes | list_extract (same as list_extract) |
list_entropy |
Yes | list_entropy |
list_extract |
Yes | list_extract |
list_filter |
Yes | list_filter |
list_first |
Yes | list_first |
list_grade_up |
Yes | list_grade_up |
list_has |
Yes | list_contains (same as list_contains) |
list_has_all |
Yes | list_has_all |
list_has_any |
Yes | list_has_any |
list_histogram |
Yes | list_histogram |
list_indexof |
Yes | list_position (same as list_position) |
list_intersect |
Yes | list_intersect |
list_kurtosis |
Yes | list_kurtosis |
list_kurtosis_pop |
Yes | list_kurtosis_pop |
list_last |
Yes | list_last |
list_mad |
Yes | list_mad |
list_max |
Yes | list_max |
list_median |
Yes | list_median |
list_min |
Yes | list_min |
list_mode |
Yes | list_mode |
list_pack |
Yes | list_value (same as list_value) |
list_position |
Yes | list_position |
list_prepend |
Yes | list_prepend |
list_product |
Yes | list_product |
list_reduce |
Yes | list_reduce |
list_resize |
Yes | list_resize |
list_reverse |
Yes | list_reverse |
list_reverse_sort |
Yes | list_reverse_sort |
list_select |
Yes | list_select |
list_sem |
Yes | list_sem |
list_skewness |
Yes | list_skewness |
list_slice |
Yes | list_slice |
list_sort |
Yes | list_sort |
list_stddev_pop |
Yes | list_stddev_pop |
list_stddev_samp |
Yes | list_stddev_samp |
list_string_agg |
Yes | list_string_agg |
list_sum |
Yes | list_sum |
list_transform |
Yes | list_transform |
list_unique |
Yes | list_unique |
list_value |
Yes | list_value |
list_var_pop |
Yes | list_var_pop |
list_var_samp |
Yes | list_var_samp |
list_where |
Yes | list_where |
list_zip |
Yes | list_zip |
listagg |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
ln |
Yes | ln |
localtime |
No | Not available in the VAST Query Engine. Instead: CAST(CAST(now() AS TIMESTAMP) AS DATE), or CAST(now() AS TIMESTAMP) |
localtimestamp |
No | Not available in the VAST Query Engine. Instead: CAST(CAST(now() AS TIMESTAMP) AS DATE), or CAST(now() AS TIMESTAMP) |
locate |
No | Not available in the VAST Query Engine. Instead: strpos(s, substring) or position(substring IN s) |
log |
Yes | log |
log(2, x) |
Yes | log2 (same as log2) |
log10 |
Yes | log10 |
log2 |
Yes | log2 |
lower |
Yes | lower |
lpad |
Yes | lpad |
ltrim |
Yes | ltrim |
m[key] |
Yes | map_extract_value (same as map_extract_value) |
mad |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark, or the list functions on a list column |
make_date |
Yes | make_date |
make_time |
Yes | make_time |
make_timestamp |
Yes | make_timestamp |
make_timestamp_ns |
Yes | make_timestamp_ns |
make_timestamptz |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. Instead: Store UTC TIMESTAMP values and convert in your client, or in Trino or Spark |
MAP |
No | Not available in the VAST Query Engine. Instead: Store keys and values as two list columns, and build the map with map(keys, values) |
map |
Yes | map |
map_concat |
Yes | map_concat |
map_contains |
Yes | map_contains |
map_contains_entry |
Yes | map_contains_entry |
map_contains_value |
Yes | map_contains_value |
map_entries |
Yes | map_entries |
map_extract |
Yes | map_extract |
map_extract_value |
Yes | map_extract_value |
map_from_entries |
Yes | map_from_entries |
map_keys |
Yes | map_keys |
map_to_pg_oid |
Yes | map_to_pg_oid |
map_values |
Yes | map_values |
max |
Yes | max |
max_by |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
md5 |
Yes | md5 |
md5_number |
Yes | md5_number |
md5_number_lower |
Yes | md5_number_lower |
md5_number_upper |
Yes | md5_number_upper |
mean |
Yes | avg (same as avg) |
median |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark, or the list functions on a list column |
microsecond |
Yes | microsecond |
millennium |
Yes | millennium |
millisecond |
Yes | millisecond |
min |
Yes | min |
min_by |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the rows with ORDER BY ... LIMIT, or use Trino or Spark |
minute |
Yes | minute |
mismatches |
Yes | hamming (same as hamming) |
mod(a, b) |
Yes | % (modulo) (same as %) |
mode |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark, or the list functions on a list column |
month |
Yes | month |
monthname |
Yes | monthname |
multiply(a, b) |
Yes | * (multiply an interval) (same as *) |
murmurhash3_32 |
No | Not available in the VAST Query Engine. Instead: sha256(), or compute them in your code |
n |
No | Not available in the VAST Query Engine. Instead: Cast to DOUBLE: round(d::DOUBLE, n) |
n! |
Yes | factorial (same as factorial) |
nanosecond |
Yes | nanosecond |
nextafter |
Yes | nextafter |
nextval |
Yes | nextval |
nfc_normalize |
Yes | nfc_normalize |
normalized_interval |
Yes | normalized_interval |
NOT ILIKE |
Yes | ILIKE and NOT ILIKE (same as ILIKE and NOT ILIKE) |
NOT LIKE |
Yes | LIKE and NOT LIKE (same as LIKE and NOT LIKE) |
NOT regexp_full_match(s, pattern) |
Yes | regexp_full_match (same as regexp_full_match) |
now |
Yes | now |
nullif |
Yes | nullif |
nullifzero |
No | Not available in the VAST Query Engine. Instead: nullif(x, 0) |
nvl |
No | Not available in the VAST Query Engine. Instead: coalesce or ifnull; nvl2(x, a, b) is CASE WHEN x IS NOT NULL THEN a ELSE b END; zeroifnull(x) is coalesce(x, 0) |
nvl2 |
No | Not available in the VAST Query Engine. Instead: coalesce or ifnull; nvl2(x, a, b) is CASE WHEN x IS NOT NULL THEN a ELSE b END; zeroifnull(x) is coalesce(x, 0) |
octet_length |
Yes | octet_length |
ord |
Yes | ord |
parquet_bloom_probe |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Read the file's metadata with PyArrow in your client |
parquet_file_metadata |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Read the file's metadata with PyArrow in your client |
parquet_kv_metadata |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Read the file's metadata with PyArrow in your client |
parquet_metadata |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Read the file's metadata with PyArrow in your client |
parquet_scan |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Import the files into a table, then query it |
parquet_schema |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Read the file's metadata with PyArrow in your client |
parse_dirname |
Yes | parse_dirname |
parse_dirpath |
Yes | parse_dirpath |
parse_filename |
Yes | parse_filename |
parse_path |
Yes | parse_path |
pg_catalog.map_to_pg_oid |
Yes | map_to_pg_oid (same as map_to_pg_oid) |
pg_get_constraintdef |
No | Fails in the VAST Query Engine (operator not supported). |
pg_get_viewdef |
No | Fails in the VAST Query Engine (operator not supported). |
pg_size_pretty |
Yes | pg_size_pretty |
pg_typeof |
Yes | pg_typeof |
pi |
Yes | pi |
position(substring IN s) |
Yes | strpos (same as strpos) |
pow |
Yes | pow |
power |
Yes | pow (same as pow) |
prefix |
Yes | starts_with (same as starts_with) |
printf |
Yes | printf |
product |
Yes | product |
quantile |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark, or the list functions on a list column |
quantile_cont |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark, or the list functions on a list column |
quantile_disc |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark, or the list functions on a list column |
quarter |
Yes | quarter |
query |
Yes | query |
query_table |
Yes | query_table |
quote_ident |
No | Not available in the VAST Query Engine. Instead: Your client code, or Trino or Spark |
quote_literal |
No | Not available in the VAST Query Engine. Instead: Your client code, or Trino or Spark |
radians |
Yes | radians |
random |
Yes | random |
range |
Yes | range |
read_blob |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Read the objects through S3 with your client |
read_csv |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_csv_auto |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_json |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_json_auto |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_json_objects |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_json_objects_auto |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_ndjson |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_ndjson_auto |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_ndjson_objects |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Load the file in your client and write it with the Python SDK, or convert it to Parquet and import it |
read_parquet |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Import the files into a table, then query it |
read_text |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: Read the objects through S3 with your client |
reduce |
Yes | list_reduce (same as list_reduce) |
REGEXP |
No | Not available in the VAST Query Engine. Instead: regexp_matches |
regexp_escape |
Yes | regexp_escape |
regexp_extract |
Yes | regexp_extract |
regexp_extract_all |
Yes | regexp_extract_all |
regexp_full_match |
Yes | regexp_full_match |
regexp_full_match(s, pattern) |
Yes | regexp_full_match (same as regexp_full_match) |
regexp_like |
No | Not available in the VAST Query Engine. Instead: regexp_matches |
regexp_matches |
Yes | regexp_matches |
regexp_replace |
Yes | regexp_replace |
regexp_split_to_array |
Yes | regexp_split_to_array |
regexp_split_to_table |
Yes | regexp_split_to_table |
regr_avgx |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
regr_avgy |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
regr_count |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
regr_intercept |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
regr_r2 |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
regr_slope |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
regr_sxx |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
regr_sxy |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
regr_syy |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
Regular-expression syntax and options |
Yes | Regular-expression syntax and options |
repeat |
Yes | repeat (BLOB) |
repeat_row |
Yes | repeat_row |
replace |
Yes | replace |
reservoir_quantile |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark, or the list functions on a list column |
reverse |
Yes | reverse |
right |
Yes | right |
right_grapheme |
Yes | right_grapheme |
RLIKE |
No | Not available in the VAST Query Engine. Instead: regexp_matches |
rlike |
No | Not available in the VAST Query Engine. Instead: regexp_matches |
round |
Yes | round |
round_even |
Yes | round_even |
roundbankers |
Yes | round_even (same as round_even) |
row |
Yes | row |
row_number |
Yes | row_number |
row_to_json |
Yes | row_to_json |
rpad |
Yes | rpad |
rtrim |
Yes | rtrim |
s.field |
Yes | struct_extract (same as struct_extract) |
s['field'] |
Yes | struct_extract (same as struct_extract) |
second |
Yes | second |
sem |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
set_bit |
Yes | set_bit |
setseed |
Yes | setseed |
sha1 |
Yes | sha1 |
sha256 |
Yes | sha256 |
sha512 |
No | Not available in the VAST Query Engine. Instead: sha256(), or compute them in your code |
sign |
Yes | sign |
signbit |
Yes | signbit |
SIMILAR TO |
Yes | SIMILAR TO |
sin |
Yes | sin |
sinh |
Yes | sinh |
skewness |
No | Not available as an aggregate in the VAST Query Engine. Instead: Trino or Spark |
sniff_csv |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: None needed: there are no files or secrets to inspect |
soundex |
No | Not available in the VAST Query Engine. Instead: Your client code, or Trino or Spark |
split |
Yes | string_split (same as string_split) |
split_part |
Yes | split_part |
split_to_table |
No | Not available in the VAST Query Engine. Instead: unnest(string_split(s, sep)) |
sqrt |
Yes | sqrt |
starts_with |
Yes | starts_with |
stddev |
Yes | stddev_samp (same as stddev_samp) |
stddev_pop |
Yes | stddev_pop |
stddev_samp |
Yes | stddev_samp |
str_split |
Yes | string_split (same as string_split) |
str_split_regex |
Yes | regexp_split_to_array (same as regexp_split_to_array) |
strftime |
Yes | strftime |
string_agg |
No | Not available as an aggregate in the VAST Query Engine. Instead: Read the column with the Python SDK and collect it in your code |
string_split |
Yes | string_split |
string_split_regex |
Yes | regexp_split_to_array (same as regexp_split_to_array) |
string_to_array |
Yes | string_split (same as string_split) |
strip_accents |
Yes | strip_accents |
strlen |
Yes | strlen |
strpos |
Yes | strpos |
strptime |
Yes | strptime |
struct_concat |
Yes | struct_concat |
struct_extract |
Yes | struct_extract |
struct_extract_at |
Yes | struct_extract_at |
struct_insert |
Yes | struct_insert |
struct_pack |
Yes | struct_pack |
substr |
Yes | substring (same as substring) |
substring |
Yes | substring |
SUBSTRING(s FROM start FOR length) |
Yes | substring (same as substring) |
substring(s, start, length) |
Yes | substring (same as substring) |
substring_grapheme |
Yes | substring_grapheme |
subtract(a) |
Yes | - (subtraction and negation) (same as -) |
subtract(a, b) |
Yes | - (subtract a date or interval) (same as -) |
subtract(interval) |
Yes | - (subtract a date or interval) (same as -) |
suffix |
Yes | ends_with (same as ends_with) |
sum |
Yes | sum |
sum_no_overflow |
No | Not available in the VAST Query Engine. |
sumkahan |
No | Not available as an aggregate in the VAST Query Engine. Instead: sum() on DECIMAL values, which is exact |
tan |
Yes | tan |
tanh |
Yes | tanh |
TIME |
No | Not available in the VAST Query Engine. Instead: Cast the value to TIMESTAMP first |
Time zones |
Yes | Time zones |
time_bucket |
Yes | time_bucket |
TIMESTAMP |
No | Not available in the VAST Query Engine. Instead: Not needed: TIMESTAMP values have no zone |
TIMESTAMPTZ |
No | Not available in the VAST Query Engine. Instead: Use TIMESTAMP values, or Trino or Spark |
to_base |
Yes | to_base |
to_base64 |
Yes | to_base64 |
to_binary |
Yes | bin (same as bin) |
to_centuries |
Yes | to_centuries |
to_days |
Yes | to_days |
to_decades |
Yes | to_decades |
to_hex |
Yes | hex (same as hex) |
to_hours |
Yes | to_hours |
to_json |
Yes | to_json |
to_microseconds |
Yes | to_microseconds |
to_millennia |
Yes | to_millennia |
to_milliseconds |
Yes | to_milliseconds |
to_minutes |
Yes | to_minutes |
to_months |
Yes | to_months |
to_quarters |
Yes | to_quarters |
to_seconds |
Yes | to_seconds |
to_timestamp |
Yes | to_timestamp |
to_weeks |
Yes | to_weeks |
to_years |
Yes | to_years |
today |
No | Needs time-zone or collation support, which the VAST Query Engine doesn't have. Instead: CAST(CAST(now() AS TIMESTAMP) AS DATE), or CAST(now() AS TIMESTAMP) |
transaction_timestamp |
Yes | now (same as now) |
translate |
Yes | translate |
trim |
Yes | trim |
trunc |
Yes | trunc |
try |
No | Not available in the VAST Query Engine. Instead: TRY_CAST for conversions, or a CASE that tests the value first |
TRY_CAST |
Yes | TRY_CAST |
try_strptime |
Yes | try_strptime |
txid_current |
No | Fails in the VAST Query Engine. |
typeof |
Yes | typeof |
ucase |
Yes | upper (same as upper) |
unbin |
Yes | from_binary (same as from_binary) |
unhex |
Yes | from_hex (same as from_hex) |
unicode |
Yes | ord (same as ord) |
union_extract |
Yes | union_extract |
union_tag |
No | Fails in the VAST Query Engine. |
union_value |
Yes | union_value |
unnest |
Yes | unnest |
upper |
Yes | upper |
url_decode |
Yes | url_decode |
url_encode |
Yes | url_encode |
uuid |
Yes | gen_random_uuid (same as gen_random_uuid) |
UUID values and casts |
Yes | UUID values and casts |
uuid_extract_version |
No | Not available in the VAST Query Engine. Instead: gen_random_uuid() for version 4; generate other versions in your code |
uuidv4 |
No | Not available in the VAST Query Engine. Instead: gen_random_uuid() for version 4; generate other versions in your code |
uuidv7 |
No | Not available in the VAST Query Engine. Instead: gen_random_uuid() for version 4; generate other versions in your code |
var_pop |
Yes | var_pop |
var_samp |
Yes | var_samp |
VARCHAR |
No | Not available in the VAST Query Engine. Instead: min(length(s)), or Trino or Spark |
variance |
Yes | var_samp (same as var_samp) |
wavg |
Yes | wavg |
week |
Yes | week |
weekday |
Yes | dayofweek (same as dayofweek) |
weekofyear |
Yes | week (same as week) |
weighted_avg |
Yes | wavg (same as wavg) |
which_secret |
No | Reads files or the network, which the VAST Query Engine can't do. Instead: None needed: there are no files or secrets to inspect |
Window functions |
Yes | Window functions |
write_log |
Yes | write_log |
xor |
Yes | xor |
xxhash64 |
No | Not available in the VAST Query Engine. Instead: sha256(), or compute them in your code |
year |
Yes | year |
yearweek |
Yes | yearweek |
zeroifnull |
No | Not available in the VAST Query Engine. Instead: coalesce or ifnull; nvl2(x, a, b) is CASE WHEN x IS NOT NULL THEN a ELSE b END; zeroifnull(x) is coalesce(x, 0) |
{'name': value, ...} |
Yes | struct_pack (same as struct_pack) |
| |
Yes | | (bitwise OR) |
|| |
Yes | list_concat (same as list_concat) |
~ |
Yes | ~ (bitwise NOT) |
~~ |
Yes | LIKE and NOT LIKE (same as LIKE and NOT LIKE) |
~~* |
Yes | ILIKE and NOT ILIKE (same as ILIKE and NOT ILIKE) |
~~~ |
Yes | GLOB (same as GLOB) |