S01014
Error Code
S01014
Error Message
A column with name <xxx> already exists in table.
RefId:S01014
Probable Causes
When using the addColumn
function to add a column, this error is
thrown if any of the colNames already exists in the table.
Solutions
- Use the
schema
function to check the table schema. For example, use the following script to get the columns of table pt1 in the dfs://testDB database:schema(loadTable("dfs://testDB","pt1")).colDefs
name typeString typeInt extra comment id INT 4 x DOUBLE 16 - When using
addColumn
, make sure the specified colNames not conflict with the existing columns in the target table. Note that column names in DolphinDB are case-insensitive.