Array — NYXDB

86 Array functions in the NYXDB native function registry, with signatures, briefs, and measured medians where available.

86 functions in the array family. Each name links to its page; … marks the variadic argument list (the engine declares no named parameters). A Measured value appears only where a benchmark corpus case joins by name (server-class hardware, median).

Function	Type	Description	Measured
`array(…) → String`	scalar	Construct an array from input arguments.	—
`array_agg(…) → String`	aggregate	Aggregate values into an array.	—
`array_all(…) → Bool`	scalar	Check if all array elements are truthy.	—
`array_append(…) → String`	scalar	Append one value to an array.	—
`array_auc(…) → Float64`	scalar	Area under ROC curve for array inputs.	—
`array_aucpr(…) → Float64`	scalar	Area under precision-recall curve for array inputs.	—
`array_avg(…) → Float64`	scalar	Average of array elements.	—
`array_cast(…) → String`	scalar	Cast elements of an array to a target type.	—
`array_compact(…) → String`	scalar	Remove consecutive duplicates in an array.	—
`array_concat(…) → String`	scalar	Concatenate arrays into one array.	—
`array_concat_agg(…) → String`	aggregate	Concatenate arrays from all rows.	—
`array_count(…) → UInt64`	scalar	Count elements in an array.	—
`array_cum_sum(…) → String`	scalar	Cumulative sum of array elements.	—
`array_cum_sum_non_negative(…) → String`	scalar	Cumulative sum clamped at zero.	—
`array_difference(…) → String`	scalar	Adjacent differences for array elements.	—
`array_dims(…) → String`	scalar	Textual dimensions for one-dimensional arrays.	—
`array_distinct(…) → String`	aggregate	Distinct values as array.	—
`array_distinct(…) → String`	scalar	Deduplicate array values while preserving first occurrence order.	—
`array_dot_product(…) → Float64`	scalar	Dot product of two numeric arrays.	—
`array_element(…) → String`	scalar	Read one array element by index.	—
`array_enumerate(…) → String`	scalar	Enumerate array positions.	—
`array_enumerate_dense(…) → String`	scalar	Dense ids per distinct value in array order.	—
`array_enumerate_dense_ranked(…) → String`	scalar	Dense ranked ids for array elements.	—
`array_enumerate_uniq(…) → String`	scalar	Occurrence counter for each array value.	—
`array_enumerate_uniq_ranked(…) → String`	scalar	Ranked occurrence counter for each array value.	—
`array_except(…) → String`	scalar	Remove values of subsequent arrays from the first array.	—
`array_exists(…) → Bool`	scalar	Check whether any array element matches.	—
`array_fill(…) → String`	scalar	Forward fill null array elements.	—
`array_filter(…) → String`	scalar	Filter array values by truthy mask or equality.	—
`array_first(…) → String`	scalar	Return the first element of an array.	—
`array_first_index(…) → UInt64`	scalar	First matching position in an array.	—
`array_first_or_null(…) → String`	scalar	Return first element or null for empty arrays.	—
`array_flatten(…) → String`	scalar	Flatten one nesting level of array elements.	—
`array_fold(…) → Float64`	scalar	Reduce array elements into one numeric accumulator.	—
`array_intersect(…) → String`	scalar	Intersect array values across all input arrays.	—
`array_jaccard_index(…) → Float64`	scalar	Jaccard similarity of two arrays as sets.	—
`array_join(…) → String`	stream	Expand an array into a stream of rows.	—
`array_last(…) → String`	scalar	Return the last element of an array.	—
`array_last_index(…) → UInt64`	scalar	Last matching position in an array.	—
`array_last_or_null(…) → String`	scalar	Return last element or null for empty arrays.	—
`array_length(…) → UInt64`	scalar	Length of an array.	—
`array_lower(…) → UInt64`	scalar	Lower bound for an array dimension.	—
`array_map(…) → String`	scalar	Apply a per-element transform to array values.	—
`array_max(…) → Float64`	scalar	Maximum numeric value in an array.	—
`array_min(…) → Float64`	scalar	Minimum array element.	—
`array_ndims(…) → UInt64`	scalar	Number of array dimensions.	—
`array_normalized_gini(…) → Float64`	scalar	Normalized Gini coefficient.	—
`array_partial_shuffle(…) → String`	scalar	Partially shuffle an array.	—
`array_pop_back(…) → String`	scalar	Remove the last array element.	—
`array_pop_front(…) → String`	scalar	Remove the first array element.	—
`array_position(…) → UInt64`	scalar	Position of a value in an array.	—
`array_positions(…) → String`	scalar	Positions of a value in an array.	—
`array_prauc(…) → Float64`	scalar	Precision-recall AUC for array inputs.	—
`array_prepend(…) → String`	scalar	Prepend an element to an array.	—
`array_product(…) → Float64`	scalar	Product of array elements.	—
`array_random_sample(…) → String`	scalar	Random sample from an array.	—
`array_reduce(…) → Float64`	scalar	Apply an aggregate function to an array.	—
`array_reduce_in_ranges(…) → String`	scalar	Reduce array over ranges.	—
`array_remove(…) → String`	scalar	Remove elements equal to a value.	—
`array_replace(…) → String`	scalar	Replace values in an array.	—
`array_resize(…) → String`	scalar	Resize an array.	—
`array_reverse(…) → String`	scalar	Reverse array.	—
`array_reverse_fill(…) → String`	scalar	Backward-fill missing values.	—
`array_reverse_sort(…) → String`	scalar	Sort array descending.	—
`array_reverse_split(…) → String`	scalar	Split array from the end.	—
`array_rocauc(…) → Float64`	scalar	ROC AUC.	—
`array_rotate_left(…) → String`	scalar	Rotate array left.	—
`array_rotate_right(…) → String`	scalar	Rotate array right.	—
`array_sample(…) → String`	scalar	Sample elements from an array.	—
`array_shift_left(…) → String`	scalar	Shift array left.	—
`array_shift_right(…) → String`	scalar	Shift array right.	—
`array_shingles(…) → String`	scalar	Generate shingles (n-grams).	—
`array_shuffle(…) → String`	scalar	Shuffle array.	—
`array_slice(…) → String`	scalar	Slice an array.	—
`array_sort(…) → String`	scalar	Sort array.	—
`array_split(…) → String`	scalar	Split an array.	—
`array_sum(…) → Float64`	scalar	Sum array elements.	—
`array_symmetric_difference(…) → String`	scalar	Array symmetric difference.	—
`array_to_json(…) → JSON`	scalar	Convert an array to JSON.	—
`array_to_string(…) → String`	scalar	Join array elements into a string.	—
`array_union(…) → String`	scalar	Array union.	—
`array_uniq(…) → UInt64`	scalar	Count distinct elements.	—
`array_upper(…) → UInt64`	scalar	Upper bound of an array dimension.	—
`array_with_constant(…) → String`	scalar	Create an array filled with a constant.	—
`array_zip(…) → String`	scalar	Zip arrays.	—
`array_zip_unaligned(…) → String`	scalar	Zip arrays with different lengths.	—