Expand description
Comparison kernels for Arrays.
Traits§
- String
Array Type - A trait for Arrow String Arrays, currently three types are supported:
Functions§
- contains
- Perform SQL
CONTAINS(left, right) - ends_
with - Perform SQL
ENDSWITH(left, right) - ilike
- Perform SQL
left ILIKE right - in_list
- Checks if a
GenericListArraycontains a value in thePrimitiveArray - in_
list_ utf8 - Checks if a
GenericListArraycontains a value in theGenericStringArray - like
- Perform SQL
left LIKE right - nilike
- Perform SQL
left NOT ILIKE right - nlike
- Perform SQL
left NOT LIKE right - regexp_
is_ match - Return BooleanArray indicating which strings in an array match an array of regular expressions.
- regexp_
is_ match_ scalar - Return BooleanArray indicating which strings in an array match a single regular expression.
- regexp_
is_ match_ utf8 Deprecated - Perform SQL
array ~ regex_arrayoperation onStringArray/LargeStringArray. Ifregex_arrayelement has an empty value, the corresponding result value is always true. - regexp_
is_ match_ utf8_ scalar Deprecated - Perform SQL
array ~ regex_arrayoperation onStringArray/LargeStringArrayand a scalar. - starts_
with - Perform SQL
STARTSWITH(left, right)