S02018

Error Code

S02018

Error Message

The grouping column <xxx> cannot be an array vector. RefId:S02018

Probable Causes

The array vector column cannot be grouped. Therefore, this error occurs when using a GROUP BY clause on an array vector column.

For example, if the following query includes a GROUP BY on the "grp" column, which is an array vector, it will trigger the error:

t = table(array(INT[], 0, 10).append!([1 2, 3]) as grp, [1,1] as val)
select sum(val) from t group by grp

Solutions

Ensure that the grouping column is not an array vector.