Expand description
Comparison kernels for Array
s.
Functions§
- Perform SQL
CONTAINS(left, right)
- Perform SQL
ENDSWITH(left, right)
- eqDeprecatedPerform
left == right
operation on twoPrimitiveArray
s. - eq_binaryDeprecated
- eq_binary_scalarDeprecated
- eq_boolDeprecatedPerform
left == right
operation onBooleanArray
- eq_bool_scalarDeprecatedPerform
left == right
operation onBooleanArray
and a scalar - eq_dynDeprecatedPerform
left == right
operation on two (dynamic)Array
s. - eq_dyn_binary_scalarDeprecatedPerform
left == right
operation on an array and a numeric scalar value. Supports BinaryArray and LargeBinaryArray - eq_dyn_bool_scalarDeprecatedPerform
left == right
operation on an array and a numeric scalar value. - eq_dyn_scalarDeprecatedPerform
left == right
operation on an array and a numeric scalar value. Supports PrimitiveArrays, and DictionaryArrays that have primitive values. - eq_dyn_utf8_scalarDeprecatedPerform
left == right
operation on an array and a numeric scalar value. Supports StringArrays, and DictionaryArrays that have string values - eq_scalarDeprecatedPerform
left == right
operation on aPrimitiveArray
and a scalar value. - eq_utf8Deprecated
- eq_utf8_scalarDeprecated
- gtDeprecatedPerform
left > right
operation on twoPrimitiveArray
s. Non-null values are greater than null values. - gt_binaryDeprecated
- gt_binary_scalarDeprecated
- gt_boolDeprecatedPerform
left > right
operation onBooleanArray
- gt_bool_scalarDeprecatedPerform
left > right
operation onBooleanArray
and a scalar - gt_dynDeprecatedPerform
left > right
operation on two (dynamic)Array
s. - gt_dyn_binary_scalarDeprecatedPerform
left > right
operation on an array and a numeric scalar value. Supports BinaryArray and LargeBinaryArray - gt_dyn_bool_scalarDeprecatedPerform
left > right
operation on an array and a numeric scalar value. Supports BooleanArrays. - gt_dyn_scalarDeprecatedPerform
left > right
operation on an array and a numeric scalar value. Supports PrimitiveArrays, and DictionaryArrays that have primitive values. - gt_dyn_utf8_scalarDeprecatedPerform
left > right
operation on an array and a numeric scalar value. Supports StringArrays, and DictionaryArrays that have string values - gt_eqDeprecatedPerform
left >= right
operation on twoPrimitiveArray
s. Non-null values are greater than null values. - gt_eq_binaryDeprecated
- gt_eq_binary_scalarDeprecated
- gt_eq_boolDeprecatedPerform
left >= right
operation onBooleanArray
- gt_eq_bool_scalarDeprecatedPerform
left >= right
operation onBooleanArray
and a scalar - gt_eq_dynDeprecatedPerform
left >= right
operation on two (dynamic)Array
s. - gt_eq_dyn_binary_scalarDeprecatedPerform
left >= right
operation on an array and a numeric scalar value. Supports BinaryArray and LargeBinaryArray - gt_eq_dyn_bool_scalarDeprecatedPerform
left >= right
operation on an array and a numeric scalar value. Supports BooleanArrays. - gt_eq_dyn_scalarDeprecatedPerform
left >= right
operation on an array and a numeric scalar value. Supports PrimitiveArrays, and DictionaryArrays that have primitive values. - gt_eq_dyn_utf8_scalarDeprecatedPerform
left >= right
operation on an array and a numeric scalar value. Supports StringArrays, and DictionaryArrays that have string values - gt_eq_scalarDeprecatedPerform
left >= right
operation on aPrimitiveArray
and a scalar value. Non-null values are greater than null values. - gt_eq_utf8Deprecated
- gt_eq_utf8_scalarDeprecated
- gt_scalarDeprecatedPerform
left > right
operation on aPrimitiveArray
and a scalar value. Non-null values are greater than null values. - gt_utf8Deprecated
- gt_utf8_scalarDeprecated
- Perform SQL
left ILIKE right
- Checks if a
GenericListArray
contains a value in thePrimitiveArray
- Checks if a
GenericListArray
contains a value in theGenericStringArray
- Perform SQL
left LIKE right
- ltDeprecatedPerform
left < right
operation on twoPrimitiveArray
s. Null values are less than non-null values. - lt_binaryDeprecated
- lt_binary_scalarDeprecated
- lt_boolDeprecatedPerform
left < right
operation onBooleanArray
- lt_bool_scalarDeprecatedPerform
left < right
operation onBooleanArray
and a scalar - lt_dynDeprecatedPerform
left < right
operation on two (dynamic)Array
s. - lt_dyn_binary_scalarDeprecatedPerform
left < right
operation on an array and a numeric scalar value. Supports BinaryArray and LargeBinaryArray - lt_dyn_bool_scalarDeprecatedPerform
left < right
operation on an array and a numeric scalar value. Supports BooleanArrays. - lt_dyn_scalarDeprecatedPerform
left < right
operation on an array and a numeric scalar value. Supports PrimitiveArrays, and DictionaryArrays that have primitive values. - lt_dyn_utf8_scalarDeprecatedPerform
left < right
operation on an array and a numeric scalar value. Supports StringArrays, and DictionaryArrays that have string values - lt_eqDeprecatedPerform
left <= right
operation on twoPrimitiveArray
s. Null values are less than non-null values. - lt_eq_binaryDeprecated
- lt_eq_binary_scalarDeprecated
- lt_eq_boolDeprecatedPerform
left <= right
operation onBooleanArray
- lt_eq_bool_scalarDeprecatedPerform
left <= right
operation onBooleanArray
and a scalar - lt_eq_dynDeprecatedPerform
left <= right
operation on two (dynamic)Array
s. - lt_eq_dyn_binary_scalarDeprecatedPerform
left <= right
operation on an array and a numeric scalar value. Supports BinaryArray and LargeBinaryArray - lt_eq_dyn_bool_scalarDeprecatedPerform
left <= right
operation on an array and a numeric scalar value. Supports BooleanArrays. - lt_eq_dyn_scalarDeprecatedPerform
left <= right
operation on an array and a numeric scalar value. Supports PrimitiveArrays, and DictionaryArrays that have primitive values. - lt_eq_dyn_utf8_scalarDeprecatedPerform
left <= right
operation on an array and a numeric scalar value. Supports StringArrays, and DictionaryArrays that have string values - lt_eq_scalarDeprecatedPerform
left <= right
operation on aPrimitiveArray
and a scalar value. Null values are less than non-null values. - lt_eq_utf8Deprecated
- lt_eq_utf8_scalarDeprecated
- lt_scalarDeprecatedPerform
left < right
operation on aPrimitiveArray
and a scalar value. Null values are less than non-null values. - lt_utf8Deprecated
- lt_utf8_scalarDeprecated
- neqDeprecatedPerform
left != right
operation on twoPrimitiveArray
s. - neq_binaryDeprecated
- neq_binary_scalarDeprecated
- neq_boolDeprecatedPerform
left != right
operation onBooleanArray
- neq_bool_scalarDeprecatedPerform
left != right
operation onBooleanArray
and a scalar - neq_dynDeprecatedPerform
left != right
operation on two (dynamic)Array
s. - neq_dyn_binary_scalarDeprecatedPerform
left != right
operation on an array and a numeric scalar value. Supports BinaryArray and LargeBinaryArray - neq_dyn_bool_scalarDeprecatedPerform
left != right
operation on an array and a numeric scalar value. Supports BooleanArrays. - neq_dyn_scalarDeprecatedPerform
left != right
operation on an array and a numeric scalar value. Supports PrimitiveArrays, and DictionaryArrays that have primitive values. - neq_dyn_utf8_scalarDeprecatedPerform
left != right
operation on an array and a numeric scalar value. Supports StringArrays, and DictionaryArrays that have string values - neq_scalarDeprecatedPerform
left != right
operation on aPrimitiveArray
and a scalar value. - neq_utf8Deprecated
- neq_utf8_scalarDeprecated
- Perform SQL
left NOT ILIKE right
- Perform SQL
left NOT LIKE right
- Perform SQL
array ~ regex_array
operation onStringArray
/LargeStringArray
. Ifregex_array
element has an empty value, the corresponding result value is always true. - Perform SQL
STARTSWITH(left, right)
- unary_cmpDeprecatedApplies an unary and infallible comparison function to a primitive array.