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) | 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) | Returns the subset or range of elements. Example: array-slice(array(1, 2, 3, 4), 2 , 2) Result: 3,4 | GenericUDFArraySlice * |
t | array_min((array(obj1, obj2, obj3...)) | 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...)) | 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...)) | 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) | Concatenate the elements of an array with a specified delimiter. Example: array_join(array(1, 2, NULL, 4), ',',':') Result: 11,2,:,4 | GenericUDFArrayJoin |
array<t> | array_expect(array1, array2) | Returns an array 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) | 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) | 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) | Removes all occurrences of elements from the array. Example: array_remove(array(1, 2, 3, 4, 2), 2) Result: [1, 3, 4] | GenericUDFArrayRemove |