Module expr_fn

Available on crate feature nested_expressions only.

Fluent-style API for creating Exprs

Functions

array_any_value

returns the first non-null element in the array.

array_append

appends an element to the end of an array.

array_concat

Concatenates arrays.

array_dims

returns an array of the array’s dimensions.

array_distance

returns the Euclidean distance between two numeric arrays.

array_distinct

returns distinct values from the array after removing duplicates.

array_element

extracts the element with the index n from the array.

array_empty

returns true for an empty array or false for a non-empty array.

array_except

returns an array of the elements that appear in the first array but not in the second.

array_has

returns true, if the element appears in the first array, otherwise false.

array_has_all

returns true if each element of the second array appears in the first array; otherwise, it returns false.

array_has_any

returns true if at least one element of the second array appears in the first array; otherwise, it returns false.

array_intersect

returns an array of the elements in the intersection of array1 and array2.

array_length

returns the length of the array dimension.

array_ndims

returns the number of dimensions of the array.

array_pop_back

returns the array without the last element.

array_pop_front

returns the array without the first element.

array_position

searches for an element in the array, returns first occurrence.

array_positions

searches for an element in the array, returns all occurrences.

array_prepend

Prepends an element to the beginning of an array.

array_remove

removes the first element from the array equal to the given value.

array_remove_all

removes all elements from the array equal to the given value.

array_remove_n

removes the first max elements from the array equal to the given value.

array_repeat

returns an array containing element count times.

array_replace

replaces the first occurrence of the specified element with another specified element.

array_replace_all

replaces all occurrences of the specified element with another specified element.

array_replace_n

replaces the first max occurrences of the specified element with another specified element.

array_resize

returns an array with the specified size filled with the given value.

array_reverse

reverses the order of elements in the array.

array_slice

returns a slice of the array.

array_sort

returns sorted array.

array_to_string

converts each element to its text representation.

array_union

returns an array of the elements in the union of array1 and array2 without duplicates.

cardinality

returns the total number of elements in the array or map.

flatten

flattens an array of arrays into a single array.

gen_series

create a list of values in the range between start and stop, include upper bound

make_array

Returns an Arrow array using the specified input expressions.

map_extract

Return a list containing the value for a given key or an empty list if the key is not contained in the map.

map_keys

Return a list of all keys in the map.

map_values

Return a list of all values in the map.

range

create a list of values in the range between start and stop

string_to_array

splits a string based on a delimiter and returns an array of parts. Any parts matching the optional null_string will be replaced with NULL