Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Return Type

Name(Signature)

Description

OSS

int

size(Map<K.V>)

Returns the number of elements in the map type.


int

size(Array<T>)

Returns the number of elements in the array type.


array<K>

map_keys(Map<K.V>)

Returns an unordered array containing the keys of the input map.


array<V>

map_values(Map<K.V>)

Returns an unordered array containing the values of the input map.


boolean

array_contains(Array<T>, value)

Returns TRUE if the array contains the provided parameter value.


array<t>

sort_array(Array<T>)

Sorts the input array in ascending order according to the natural ordering of the array elements and returns it.


array<t>

array(obj1, obj2, ....  objN)

Status
colourGreen
titleNew
The function returns an array of the same type as the input array with distinct values. Example: array('b', 'd', 'd', 'a') reurtns ['b', 'd', 'a'] 

GenericUDFArrayDistinct.java

array<t>

array_slice(array, start, length)

Status
colourGreen
titleNew
Returns the subset or range of elements. 

GenericUDFArraySlice *

t

array_min((array(obj1, obj2, obj3...))

Status
colourGreen
titleNew
The function returns the minimum value in the array with elements for which order is supported. Example: array_min(array(1, 3, 0, NULL)) Result: 0

GenericUDFArrayMin

t

array_max((array(obj1, obj2, obj3...))

Status
colourGreen
titleNew
The function returns the maximum value in the array with elements for which order is supported. Example: array_max(array(1, 3, 0, NULL)) Result: 3

GenericUDFArrayMax

t

array_distinct(array(obj1, obj2, obj3...))

Status
colourGreen
titleNew
The function returns an array of the same type as the input array with distinct values. Example: array_distinct(array('b', 'd', 'd', 'a')) Result:  ['b', 'd', 'a']

GenericUDFArrayDistinct

string

array_join(array, delimiter, replaceNull)

Status
colourGreen
titleNew

array_expect

Status
colourGreen
titleNew

Concatenate the elements of an array with a specified delimiter. Example: 

array_join(array(1, 2, NULL, 4), ',',':') Result:  1,2,:,4

GenericUDFArrayJoin

array<t>

array_expect(array1, array2)
array_intersect

Status
colourGreen
titleNew

array_union

Status
colourGreen
titleNew
Returns an array

_remove

of the elements in array1 but not in array2. Example: array_expect(array(1, 2, 3,4), array(2,3)) Result: [1,4]

GenericUDFArrayExcept

array<t>

array_intersect(array1, array2)

Status
colour
Status
colourGreen
titleNew
Returns an array of the elements in the intersection of array1 and array2, without duplicates. Example: array_intersect(array(1, 2, 3,4), array(1,2,3)) Result: [1,2,3]

GenericUDFArrayIntersect

array<t>

array_union(array1, array2)

Status
colourGreen
titleNew
Returns an array of the elements in the union of array1 and array2 without duplicates. Example: array_union(array(1, 2, 2, 4), array(2, 3)) Result: [1, 2, 3, 4]

GenericUDFArrayUnion

array<t>

array_remove(array, element)

Status
colourGreen
titleNew
Removes all occurrences of elements from the array. Example: array_remove(array(1, 2, 3, 4, 2), 2) Result: [1, 3, 4]

GenericUDFArrayRemove

Type Conversion Functions

...