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.