S02024
Error Code
S02024
Error Message
Array vector does not support SYMBOL or STRING type.
RefId:S02024
Probable Causes
For a query with a GROUP BY clause, if you attempt to apply a function that generates a STRING or SYMBOL array vector in the SELECT statement, an error will be thrown. The reason for this is that array vectors do not natively support STRING or SYMBOL data types.
For example, toArray
applied to the "val" column (of STRING type)
will result in an error.
t = table([1,1] as id, ["A", "B"] as val)
select toArray(val) from t group by id
Solutions
Avoid using a function to generate a STRING or SYMBOL array vector in the SELECT statement for a query with GROUP BY clause.