row

Description

Creates a named STRUCT or ROW value from the given values. It supports unnamed struct. You do not need to specify the field names. CelerData automatically generates column names, such as col1, col2,....

struct() is the alias of row().

Syntax

STRUCT row(ANY val, ...)

Parameters

val: an expression of any supported type.

This function is a variable argument function. You must pass at least one argument. value is nullable. Separate multiple values with a comma (,).

Return value

Returns a STRUCT value which consists of the input values.

Examples

select row(1,"Apple","Pear");
+-----------------------------------------+
| row(1, 'Apple', 'Pear')                 |
+-----------------------------------------+
| {"col1":1,"col2":"Apple","col3":"Pear"} |
+-----------------------------------------+

select row("Apple", NULL);
+------------------------------+
| row('Apple', NULL)           |
+------------------------------+
| {"col1":"Apple","col2":null} |
+------------------------------+

select struct(1,2,3);
+------------------------------+
| row(1, 2, 3)                 |
+------------------------------+
| {"col1":1,"col2":2,"col3":3} |
+------------------------------+

References

In this article
Copyright © 2024 CelerData