Skip to main content
Version: 3.2

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. StarRocks automatically generates column names, such as col1, col2,....

This function is supported from v3.1 onwards.

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