Edit

Error Codes

This section describes the common error codes for query requests.

Serial numberError codeError message
11005Table creation failed. Returns a specific reason.
21007Cannot create a database with the same name.
31008Cannot delete non-existent database.
41044Cannot access unauthorized database.
51045Username and password do not match and therefore cannot access the system.
61046The target database is not specified.
71047An invalid command is specified.
81049An invalid database is specified.
91050A table with the same name already exists.
101051An invalid table is specified.
111052The specified column name is ambiguous and therefore the corresponding column cannot be uniquely identified.
121053An illegal data column was specified for the Semi-Join/Anti-Join query.
131054The specified column does not exist in the table.
141058The number of columns selected in the query statement does not match the number of columns in the query result.
151060There are duplicate column names.
161064There is no surviving BE node.
171066Duplicate table alias appears in the query statement.
181094Thread ID is invalid.
191095The non-owner of a thread cannot terminate the thread.
201096The query statement does not specify the table to be queried.
211102The database name is incorrect.
221104The table name is incorrect.
231105Other errors.
241110Duplicate columns were specified in the subquery.
251111Illegal use of aggregation function in WHERE clause
261113The set of columns in the new table cannot be empty.
271115Unsupported character sets are used.
281130An unauthorized IP address is used by the client.
291132No permission to change user password.
301141Specified entries don’t have privileges to revoke.
311142An unauthorized action was performed.
321166The data column name is incorrect.
331193System variable has invalid name
341203The number of active connections used exceeded the limit.
351211Not allowed to create new users.
361227The user has performed an out-of-authority operation.
371228Session variables cannot be modified by the SET GLOBAL command.
381229Global variables should be modified by the SET GLOBAL command.
391230Related system variables do not have default values.
401231An invalid value was set for a system variable.
411232A value of the wrong data type was set for a system variable.
421248No alias was set for an inline view.
431251The client does not support the user authentication protocol required by the server.
441286The storage engine is incorrectly configured.
451298The time zone is incorrectly configured.
461347The object does not match the expected type.
471353The specified column number in the Select clause of the view is not equal to the defined column number.
481364No default value is set for columns that do not allow NULL values.
491372The password is not long enough.
501396The performed operation failed.
511471The specified table is not allowed to insert data.
521507Delete nonexistent partition, and no condition is specified to only delete existing partitions.
531508All partitions should be deleted by a delete table operation.
541517There are duplicate partition names.
551524The specified plugin has not been loaded.
561567The name of the partition is incorrect.
571621The specified system variable is read-only.
581735The specified partition name does not exist in the table.
591748Data cannot be inserted into a table that does not have a partition.
601749The specified partition does not exist.
615000The specified table is not an OLAP table.
625001The specified storage path is invalid.
635002The name of the specified column should be displayed.
645003The dimension column should be preceded by the index column.
655004The table should contain at least 1 dimension column.
665005The cluster ID is invalid.
675006Invalid query plan.
685007Conflicting query plans.
695008The data insert is only available for data tables with partitions.
705009The PARTITION clause cannot be used to insert data into tables without partitions.
715010The number of columns in the table to be created is not equal to the number of columns in the SELECT clause.
725011Table reference could not be accessed.
735012The specified value is not a valid number.
745013The time unit is not supported.
755014The table status is not normal.
765015The partition status is not normal.
775016A data import job exists in the partition.
785017The specified column is not a dimension column.
795018The format of the value is invalid.
805019The data replica does not match the version.
815021The BE node is offline.
825022The number of partitions in a non-partitioned table is not 1
835023No action was specified in the statement used to modify the table or data.
845024Job execution timed out.
855025Data insertion failed.
865026An unsupported data type was used when creating a table via the SELECT statement.
875027The specified parameter was not set.
885028The specified cluster was not found.
895030The user does not have permission to access the cluster.
905031No parameter specified or invalid parameter.
915032The number of cluster instances was not specified.
925034A cluster with the same name already exists.
935035The number of cluster instances is incorrectly configured.
945036Insufficient BE nodes in the cluster.
955037All databases should be deleted before deleting the cluster.
975038The BE node with the specified ID does not exist in the cluster.
985040No cluster with the same name exists.
995041No cluster name specified.
1005042No permissions.
1015043The number of instances should be greater than 0.
1025046Source cluster does not exist.
1035047Destination cluster does not exist.
1045048Source database does not exist.
1055049Destination database does not exist.
1065050No cluster selected.
1075051The source database should be associated with the destination database first.
1085052Intra-cluster error: BE node information is incorrect.
1095053There is no migration task from the source database to the destination database.
1105054The specified database has been associated with the destination database, or data is being migrated.
1115055Database associations or data migrations cannot be performed within the same cluster.
1125056Database cannot be deleted: it is associated with another database or data is being migrated.
1135056Database cannot be renamed: it is associated with another database or data is being migrated.
1145056Insufficient BE nodes in the cluster.
1155056The specified number of BE nodes already exists in the cluster.
1165059There are BE nodes in the cluster that are in the offline state.
1175062The cluster name is illegal: default_cluster is the reserved name.
1185063The type name is incorrect.
1195064Generic error message.
1205063The Colocate feature has been disabled by the administrator.
1215063A colocate data table with the same name does not exist.
1225063The Colocate table must be an OLAP table.
1235063Colocate tables should have the same number of replicas.
1245063Colocate tables should have the same number of split buckets.
1255063Colocate tables should have the same number of partition columns.
1265063Colocate tables should have the same data type of partitioned columns.
1275064The specified table is not a colocate table.
1285065The specified operation is invalid.
1295065The specified time unit is illegal. The correct units are DAY, WEEK, and MONTH.
1305066The start value of the dynamic partition should be less than 0.
1315066The start value of the dynamic partition is not a valid number.
1325066The end value of the dynamic partition should be greater than 0.
1335066The end value of the dynamic partition is not a valid number.
1345066The end value of the dynamic partition is null.
1355067The bucket number of the dynamic partition should be greater than 0.
1365067The bucket number of the dynamic partition is not a valid number.
1375066The bucket number of the dynamic partition is empty.
1385068Whether to allow dynamic partition where the value is not a valid boolean: true or false.
1395069The name of the specified dynamic partition has an illegal prefix.
1405070The specified operation is disabled.
1415071The number of replicas of the dynamic partition should be greater than 0.
1425072The number of replicas of the dynamic partition is not a valid number.
In this article