array
function
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above
Returns an array with the elements in expr
.
Syntax
array(expr [, ...])
Arguments
exprN
: Elements of any type that share a least common type.
Returns
An array of elements of exprNs
least common type.
If the array is empty or all elements are NULL the result type is an array of type null.
Examples
-- an array of integers
> SELECT array(1, 2, 3);
[1,2,3]
-- an array of strings
> SELECT array(1.0, 1, 'hello');
[1.0,1,hello]
Related
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for