Module datafusion::functions_array::expr_fn

Fluent-style API for creating Exprs

Functions

• 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_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.
• 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.
• 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