S02010
Error Code
S02010
Error Message
All columns must be of the same length. RefId:S02010
Probable Causes
DolphinDB enforces that all columns in a table must have equal lengths. This error may occur in the following cases:
-
When constructing a table by passing vectors of mismatched lengths, e.g.,
t = table(1..10 as id, rand(1..10, 100000) as col2)
. -
When executing SQL queries where the SELECT columns produce results of different lengths, e.g.,
select id, distinct(val) from t
.
Solutions
-
Verify that the columns being used to construct the table have equal lengths.
table(1..10 as id, rand(1..10, 100000) as val) ==> table(1..10 as id, rand(1..10, 10) as val);
-
For SQL queries, confirm that the columns or expressions specified in the SELECT statement will produce results of matching lengths.
select id, distinct(val) from t ==> select id, val from t;