Edit
Feedback

Error Codes

This section describes the common error codes for query requests.

Serial numberError codeError message
1005Table creation failed. Returns a specific reason.
1007Cannot create a database with the same name.
1008Cannot delete non-existent database.
1044Cannot access unauthorized database.
1045Username and password do not match and therefore cannot access the system.
1046The target database is not specified.
1047An invalid command is specified.
1049An invalid database is specified.
1050A table with the same name already exists.
1051An invalid table is specified.
1052The specified column name is ambiguous and therefore the corresponding column cannot be uniquely identified.
1053An illegal data column was specified for the Semi-Join/Anti-Join query.
1054The specified column does not exist in the table.
1058The number of columns selected in the query statement does not match the number of columns in the query result.
1060There are duplicate column names.
1064There is no surviving BE node.
1066Duplicate table alias appears in the query statement.
1094Thread ID is invalid.
1095The non-owner of a thread cannot terminate the thread.
1096The query statement does not specify the table to be queried.
1102The database name is incorrect.
1104The table name is incorrect.
1105Other errors.
1110Duplicate columns were specified in the subquery.
1111Illegal use of aggregation function in WHERE clause
1113The set of columns in the new table cannot be empty.
1115Unsupported character sets are used.
1130An unauthorized IP address is used by the client.
1132No permission to change user password.
1141Specified entries don’t have privileges to revoke.
1142An unauthorized action was performed.
1166The data column name is incorrect.
1193System variable has invalid name
1203The number of active connections used exceeded the limit.
1211Not allowed to create new users.
1227The user has performed an out-of-authority operation.
1228Session variables cannot be modified by the SET GLOBAL command.
1229Global variables should be modified by the SET GLOBAL command.
1230Related system variables do not have default values.
1231An invalid value was set for a system variable.
1232A value of the wrong data type was set for a system variable.
1248No alias was set for an inline view.
1251The client does not support the user authentication protocol required by the server.
1286The storage engine is incorrectly configured.
1298The time zone is incorrectly configured.
1347The object does not match the expected type.
1353The specified column number in the Select clause of the view is not equal to the defined column number.
1364No default value is set for columns that do not allow NULL values.
1372The password is not long enough.
1396The performed operation failed.
1471The specified table is not allowed to insert data.
1507Delete nonexistent partition, and no condition is specified to only delete existing partitions.
1508All partitions should be deleted by a delete table operation.
1517There are duplicate partition names.
1524The specified plugin has not been loaded.
1567The name of the partition is incorrect.
1621The specified system variable is read-only.
1735The specified partition name does not exist in the table.
1748Data cannot be inserted into a table that does not have a partition.
1749The specified partition does not exist.
5000The specified table is not an OLAP table.
5001The specified storage path is invalid.
5002The name of the specified column should be displayed.
5003The dimension column should be preceded by the index column.
5004The table should contain at least 1 dimension column.
5005The cluster ID is invalid.
5006Invalid query plan.
5007Conflicting query plans.
5008The data insert is only available for data tables with partitions.
5009The PARTITION clause cannot be used to insert data into tables without partitions.
5010The number of columns in the table to be created is not equal to the number of columns in the SELECT clause.
5011Table reference could not be accessed.
5012The specified value is not a valid number.
5013The time unit is not supported.
5014The table status is not normal.
5015The partition status is not normal.
5016A data import job exists in the partition.
5017The specified column is not a dimension column.
5018The format of the value is invalid.
5019The data replica does not match the version.
5021The BE node is offline.
5022The number of partitions in a non-partitioned table is not 1
5023No action was specified in the statement used to modify the table or data.
5024Job execution timed out.
5025Data insertion failed.
5026An unsupported data type was used when creating a table via the SELECT statement.
5027The specified parameter was not set.
5028The specified cluster was not found.
5030The user does not have permission to access the cluster.
5031No parameter specified or invalid parameter.
5032The number of cluster instances was not specified.
5034A cluster with the same name already exists.
5035The number of cluster instances is incorrectly configured.
5036Insufficient BE nodes in the cluster.
5037All databases should be deleted before deleting the cluster.
5038The BE node with the specified ID does not exist in the cluster.
5040No cluster with the same name exists.
5042No permissions.
5043The number of instances should be greater than 0.
5046Source cluster does not exist.
5047Destination cluster does not exist.
5048Source database does not exist.
5049Destination database does not exist.
5050No cluster selected.
5051The source database should be associated with the destination database first.
5052Intra-cluster error: BE node information is incorrect.
5053There is no migration task from the source database to the destination database.
5054The specified database has been associated with the destination database, or data is being migrated.
5055Database associations or data migrations cannot be performed within the same cluster.
5056Database cannot be deleted: it is associated with another database or data is being migrated.
5056Database cannot be renamed: it is associated with another database or data is being migrated.
5056Insufficient BE nodes in the cluster.
5056The specified number of BE nodes already exists in the cluster.
5059There are BE nodes in the cluster that are in the offline state.
5063The type name is incorrect.
5064Generic error message.
5063The Colocate feature has been disabled by the administrator.
5063A colocate data table with the same name does not exist.
5063The Colocate table must be an OLAP table.
5063Colocate tables should have the same number of replicas.
5063Colocate tables should have the same number of split buckets.
5063Colocate tables should have the same number of partition columns.
5063Colocate tables should have the same data type of partitioned columns.
5064The specified table is not a colocate table.
5065The specified operation is invalid.
5065The specified time unit is illegal. The correct units are DAY, WEEK, and MONTH.
5066The start value of the dynamic partition should be less than 0.
5066The start value of the dynamic partition is not a valid number.
5066The end value of the dynamic partition should be greater than 0.
5066The end value of the dynamic partition is not a valid number.
5066The end value of the dynamic partition is null.
5067The bucket number of the dynamic partition should be greater than 0.
5067The bucket number of the dynamic partition is not a valid number.
5066The bucket number of the dynamic partition is empty.
5068Whether to allow dynamic partition where the value is not a valid boolean: true or false.
5069The name of the specified dynamic partition has an illegal prefix.
5070The specified operation is disabled.
5071The number of replicas of the dynamic partition should be greater than 0.
5072The number of replicas of the dynamic partition is not a valid number.
Edit
Feedback
In this article