Skip to main content
Skip to main content

Doris Error Table

Doris Error Table

Error CodeInfo
1005Failed to create the table, give the specific reason in the returned error message
1007The database already exists, you cannot create a database with the same name
1008The database does not exist and cannot be deleted
1044The database is not authorized to the user and cannot be accessed
1045The user name and password do not match, and the system cannot be accessed
1046The target database to be queried is not specified
1047The user entered an invalid operation instruction
1049The user specified an invalid database
1050Data table already exists
1051The user specified an unknown table
1052The specified column name is ambiguous, and the corresponding column cannot be uniquely determined
1053Illegal data column is specified for Semi-Join/Anti-Join query
1054The specified column does not exist in the table
1058The number of columns selected in the query statement is inconsistent with the number of columns in the query result
1060Duplicate column name
1064No alive Backend node
1066A duplicate table alias appears in the query statement
1094Invalid thread ID
1095The owner of a non-thread cannot terminate the running of the thread
1096The query statement does not specify the data table to be queried or operated
1102Incorrect database name
1104Incorrect data table name
1105Other errors
1109The user specified an unknown table in the current database
1110Duplicate columns specified in the subquery
1111Illegal use of aggregate functions in the Where clause
1113The column set of the newly created table cannot be empty
1115Unsupported character set used
1130The client used an unauthorized IP address to access the system
1132No permission to modify user password
1141When revoking user permissions, the permissions that the user does not have are specified
1142The user performed an unauthorized operation
1166Incorrect column name
1193Invalid system variable name used
1203The number of active connections used by the user exceeds the limit
1211Not allowed to create new users
1227Access denied, the user performed an unauthorized operation
1228Session variables cannot be modified by the SET GLOBAL command
1229Global variables should be modified by the SET GLOBAL instruction
1230Related system variables have no default values
1231An invalid value is set to a system variable
1232A value of the wrong data type is set to a system variable
1248No alias is set for the inline view
1251The client does not support the authentication protocol requested by the server; please upgrade the MySQL client
1286The configured storage engine is incorrect
1298The configured time zone is incorrect
1347The object does not match the expected type
1353SELECT and view field lists have different number of columns
1364The field does not allow NULL values, but no default value is set
1372Password length is not enough
1396The operation performed by the user failed to run
1471The specified table does not allow data to be inserted
1507Delete a partition that does not exist, and no condition is specified to delete it if it exists
1508Unable to delete all partitions, please use DROP TABLE instead
1517Duplicate partition name appeared
1567The partition name is incorrect
1621The specified system variable is read-only
1735The specified partition name does not exist in the table
1748You cannot insert data into a table with empty partitions. Use "SHOW PARTITIONS FROM tbl" to view the current partition of this table
1749Table partition does not exist
5000The specified table is not an OLAP table
5001The specified PROC path is invalid
5002The column name must be explicitly specified in the column substitution
5003The Key column should be sorted before the Value column
5004The table should contain at least 1 Key column
5005Invalid cluster ID
5006Invalid query plan
5007Conflicting query plan
5008Data insertion tips: only applicable to partitioned data tables
5009The PARTITION clause is invalid for INSERT into an unpartitioned table
5010The number of columns is not equal to the number of select lists in the SELECT statement
5011Unable to resolve table reference
5012The specified value is not a valid number
5013Unsupported time unit
5014Table status is abnormal
5015Partition status is abnormal
5016There is a data import task on the partition
5017The specified column is not a key column
5018Invalid value format
5019Data copy does not match the version
5021BE node is offline
5022The number of partitions in a non-partitioned table is not 1
5023Nothing in the alter statement
5024Task execution timeout
5025Data insertion operation failed
5026An unsupported data type was used when creating a table with a SELECT statement
5027The specified parameter is not set
5028The specified cluster was not found
5030A user does not have permission to access the cluster
5031No parameter specified or invalid parameter
5032The number of cluster instances is not specified
5034Cluster name already exists
5035Cluster already exists
5036Insufficient BE nodes in the cluster
5037Before deleting the cluster, all databases in the cluster must be deleted
5037The BE node with this ID does not exist in the cluster
5038No cluster name specified
5040Unknown cluster
5041No cluster name
5042Permission denied
5043The number of instances should be greater than 0
5046The source cluster does not exist
5047The target cluster does not exist
5048The source database does not exist
5049The target database does not exist
5050No cluster selected, please enter the cluster
5051The source database should be connected to the target database first
5052Cluster internal error: BE node error message
5053There is no migration task from the source database to the target database
5054The specified database is connected to the target database, or data is being migrated
5055Data connection or data migration cannot be performed in the same cluster
5056The database cannot be deleted: it is linked to another database or data is being migrated
5056The database cannot be renamed: it is linked to another database or data is being migrated
5056Insufficient BE nodes in the cluster
5056The specified number of BE nodes already exist in the cluster
5059There are BE nodes that are offline in the cluster
5062Incorrect cluster name (the name'default_cluster' is a reserved name)
5063Type name is incorrect
5064General error message
5063Colocate function has been disabled by the administrator
5063Colocate data table does not exist
5063The Colocate table must be an OLAP table
5063Colocate table should have the same number of copies
5063Colocate table should have the same number of buckets
5063The number of partition columns of the Colocate table must be the same
5063The data types of the partition columns of the Colocate table must be consistent
5064The specified table is not a colocate table
5065The specified operation is invalid
5065The specified time unit is illegal. The correct units include: HOUR / DAY / WEEK / MONTH
5066The starting value of the dynamic partition should be less than 0
5066The dynamic partition start value 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 empty
5067The number of dynamic partition buckets should be greater than 0
5067The dynamic partition bucket value is not a valid number
5066Dynamic partition bucket value is empty
5068Whether to allow the value of dynamic partition is not a valid Boolean value: true or false
5069The specified dynamic partition name prefix is illegal
5070The specified operation is forbidden
5071The number of dynamic partition replicas should be greater than 0
5072The dynamic partition copy value is not a valid number
5073The original created table stmt is empty
5074Create historical dynamic partition parameters: create_history_partition is invalid, what is expected is: true or false
5076The specified dynamic partition reserved_history_periods is null or empty
5077The specified dynamic partition reserved_history_periods is invalid
5078The length of specified dynamic partition reserved_history_periods must have pairs of date value
5079The specified dynamic partition reserved_history_periods' first date is larger than the second one