S02020

Error Code

S02020

Error Message

The grouping column <xxx> must be a vector. RefId:S02020

Probable Causes

This error occurs when the grouping column is not specified as a vector.

For example, if the following query includes a GROUP BY clause on "1", which is a scalar, it will trigger the error:

t = table([1] as val)
select sum(val) from t group by 1

Solutions

Ensure that the grouping column is a vector that has the same size as the SELECT column.