- Introduction
- Quick Start
- Table Design
- Data Loading
- Overview of data loading
- Load data from a local file system or a streaming data source using HTTP push
- Load data from HDFS or cloud storage
- Routine Load
- Spark Load
- Insert Into
- Change data through loading
- Transform data at loading
- Json Loading
- Synchronize data from MySQL
- Load data by using flink-connector-starrocks
- DataX Writer
- Data Export
- Using StarRocks
- Reference
- SQL Reference
- User Account Management
- Cluster Management
- ADMIN CANCEL REPAIR
- ADMIN CHECK TABLET
- ADMIN REPAIR
- ADMIN SET CONFIG
- ADMIN SET REPLICA STATUS
- ADMIN SHOW CONFIG
- ADMIN SHOW REPLICA DISTRIBUTION
- ADMIN SHOW REPLICA STATUS
- ALTER SYSTEM
- CANCEL DECOMMISSION
- CREATE FILE
- DROP FILE
- INSTALL PLUGIN
- SHOW BACKENDS
- SHOW BROKER
- SHOW FILE
- SHOW FRONTENDS
- SHOW FULL COLUMNS
- SHOW INDEX
- SHOW PLUGINS
- SHOW TABLE STATUS
- UNINSTALL PLUGIN
- DDL
- ALTER DATABASE
- ALTER TABLE
- ALTER VIEW
- BACKUP
- CANCEL BACKUP
- CANCEL RESTORE
- CREATE DATABASE
- CREATE INDEX
- CREATE MATERIALIZED VIEW
- CREATE REPOSITORY
- CREATE RESOURCE
- CREATE TABLE AS SELECT
- CREATE TABLE LIKE
- CREATE TABLE
- CREATE VIEW
- CREATE FUNCTION
- DROP DATABASE
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP REPOSITORY
- DROP RESOURCE
- DROP TABLE
- DROP VIEW
- DROP FUNCTION
- HLL
- RECOVER
- RESTORE
- SHOW RESOURCES
- SHOW FUNCTION
- TRUNCATE TABLE
- DML
- ALTER ROUTINE LOAD
- BROKER LOAD
- CANCEL LOAD
- DELETE
- EXPORT
- GROUP BY
- INSERT
- PAUSE ROUTINE LOAD
- RESUME ROUTINE LOAD
- ROUTINE LOAD
- SELECT
- SHOW ALTER
- SHOW BACKUP
- SHOW DATA
- SHOW DATABASES
- SHOW DELETE
- SHOW DYNAMIC PARTITION TABLES
- SHOW EXPORT
- SHOW LOAD
- SHOW PARTITIONS
- SHOW PROPERTY
- SHOW REPOSITORIES
- SHOW RESTORE
- SHOW ROUTINE LOAD
- SHOW ROUTINE LOAD TASK
- SHOW SNAPSHOT
- SHOW TABLES
- SHOW TABLET
- SHOW TRANSACTION
- SPARK LOAD
- STOP ROUTINE LOAD
- STREAM LOAD
- Data Types
- Auxiliary Commands
- Function Reference
- Java UDFs
- Window Function
- Date Functions
- convert_tz
- curdate
- current_timestamp
- curtime
- datediff
- date_add
- date_format
- date_sub
- date_trunc
- day
- dayname
- dayofmonth
- dayofweek
- dayofyear
- from_days
- from_unixtime
- hour
- minute
- month
- monthname
- now
- quarter
- second
- str_to_date
- timediff
- timestampadd
- timestampdiff
- to_date
- to_days
- unix_timestamp
- utc_timestamp
- weekofyear
- year
- hours_diff
- minutes_diff
- months_diff
- seconds_diff
- weeks_diff
- years_diff
- Aggregate Functions
- Geographic Functions
- String Functions
- JSON Functions
- Overview of JSON functions and operators
- JSON constructor functions
- JSON query and processing functions
- JSON operators
- Aggregate Functions
- Bitmap Functions
- Array Functions
- cast function
- hash function
- Cryptographic Functions
- Math Functions
- Utility Functions
- System variables
- Error code
- System limits
- SQL Reference
- Administration
- FAQ
- Deploy
- Data Migration
- SQL
- Other FAQs
- Benchmark
- Developers
- Contribute to StarRocks
- Code Style Guides
- Use the debuginfo file for debugging
- Development Environment
- Trace Tools
- Integration
Edit
Error Codes
This section describes the common error codes for query requests.
| Serial number | Error code | Error message |
|---|---|---|
| 1 | 1005 | Table creation failed. Returns a specific reason. |
| 2 | 1007 | Cannot create a database with the same name. |
| 3 | 1008 | Cannot delete non-existent database. |
| 4 | 1044 | Cannot access unauthorized database. |
| 5 | 1045 | Username and password do not match and therefore cannot access the system. |
| 6 | 1046 | The target database is not specified. |
| 7 | 1047 | An invalid command is specified. |
| 8 | 1049 | An invalid database is specified. |
| 9 | 1050 | A table with the same name already exists. |
| 10 | 1051 | An invalid table is specified. |
| 11 | 1052 | The specified column name is ambiguous and therefore the corresponding column cannot be uniquely identified. |
| 12 | 1053 | An illegal data column was specified for the Semi-Join/Anti-Join query. |
| 13 | 1054 | The specified column does not exist in the table. |
| 14 | 1058 | The number of columns selected in the query statement does not match the number of columns in the query result. |
| 15 | 1060 | There are duplicate column names. |
| 16 | 1064 | There is no surviving BE node. |
| 17 | 1066 | Duplicate table alias appears in the query statement. |
| 18 | 1094 | Thread ID is invalid. |
| 19 | 1095 | The non-owner of a thread cannot terminate the thread. |
| 20 | 1096 | The query statement does not specify the table to be queried. |
| 21 | 1102 | The database name is incorrect. |
| 22 | 1104 | The table name is incorrect. |
| 23 | 1105 | Other errors. |
| 24 | 1110 | Duplicate columns were specified in the subquery. |
| 25 | 1111 | Illegal use of aggregation function in WHERE clause |
| 26 | 1113 | The set of columns in the new table cannot be empty. |
| 27 | 1115 | Unsupported character sets are used. |
| 28 | 1130 | An unauthorized IP address is used by the client. |
| 29 | 1132 | No permission to change user password. |
| 30 | 1141 | Specified entries don’t have privileges to revoke. |
| 31 | 1142 | An unauthorized action was performed. |
| 32 | 1166 | The data column name is incorrect. |
| 33 | 1193 | System variable has invalid name |
| 34 | 1203 | The number of active connections used exceeded the limit. |
| 35 | 1211 | Not allowed to create new users. |
| 36 | 1227 | The user has performed an out-of-authority operation. |
| 37 | 1228 | Session variables cannot be modified by the SET GLOBAL command. |
| 38 | 1229 | Global variables should be modified by the SET GLOBAL command. |
| 39 | 1230 | Related system variables do not have default values. |
| 40 | 1231 | An invalid value was set for a system variable. |
| 41 | 1232 | A value of the wrong data type was set for a system variable. |
| 42 | 1248 | No alias was set for an inline view. |
| 43 | 1251 | The client does not support the user authentication protocol required by the server. |
| 44 | 1286 | The storage engine is incorrectly configured. |
| 45 | 1298 | The time zone is incorrectly configured. |
| 46 | 1347 | The object does not match the expected type. |
| 47 | 1353 | The specified column number in the Select clause of the view is not equal to the defined column number. |
| 48 | 1364 | No default value is set for columns that do not allow NULL values. |
| 49 | 1372 | The password is not long enough. |
| 50 | 1396 | The performed operation failed. |
| 51 | 1471 | The specified table is not allowed to insert data. |
| 52 | 1507 | Delete nonexistent partition, and no condition is specified to only delete existing partitions. |
| 53 | 1508 | All partitions should be deleted by a delete table operation. |
| 54 | 1517 | There are duplicate partition names. |
| 55 | 1524 | The specified plugin has not been loaded. |
| 56 | 1567 | The name of the partition is incorrect. |
| 57 | 1621 | The specified system variable is read-only. |
| 58 | 1735 | The specified partition name does not exist in the table. |
| 59 | 1748 | Data cannot be inserted into a table that does not have a partition. |
| 60 | 1749 | The specified partition does not exist. |
| 61 | 5000 | The specified table is not an OLAP table. |
| 62 | 5001 | The specified storage path is invalid. |
| 63 | 5002 | The name of the specified column should be displayed. |
| 64 | 5003 | The dimension column should be preceded by the index column. |
| 65 | 5004 | The table should contain at least 1 dimension column. |
| 66 | 5005 | The cluster ID is invalid. |
| 67 | 5006 | Invalid query plan. |
| 68 | 5007 | Conflicting query plans. |
| 69 | 5008 | The data insert is only available for data tables with partitions. |
| 70 | 5009 | The PARTITION clause cannot be used to insert data into tables without partitions. |
| 71 | 5010 | The number of columns in the table to be created is not equal to the number of columns in the SELECT clause. |
| 72 | 5011 | Table reference could not be accessed. |
| 73 | 5012 | The specified value is not a valid number. |
| 74 | 5013 | The time unit is not supported. |
| 75 | 5014 | The table status is not normal. |
| 76 | 5015 | The partition status is not normal. |
| 77 | 5016 | A data import job exists in the partition. |
| 78 | 5017 | The specified column is not a dimension column. |
| 79 | 5018 | The format of the value is invalid. |
| 80 | 5019 | The data replica does not match the version. |
| 81 | 5021 | The BE node is offline. |
| 82 | 5022 | The number of partitions in a non-partitioned table is not 1 |
| 83 | 5023 | No action was specified in the statement used to modify the table or data. |
| 84 | 5024 | Job execution timed out. |
| 85 | 5025 | Data insertion failed. |
| 86 | 5026 | An unsupported data type was used when creating a table via the SELECT statement. |
| 87 | 5027 | The specified parameter was not set. |
| 88 | 5028 | The specified cluster was not found. |
| 89 | 5030 | The user does not have permission to access the cluster. |
| 90 | 5031 | No parameter specified or invalid parameter. |
| 91 | 5032 | The number of cluster instances was not specified. |
| 92 | 5034 | A cluster with the same name already exists. |
| 93 | 5035 | The number of cluster instances is incorrectly configured. |
| 94 | 5036 | Insufficient BE nodes in the cluster. |
| 95 | 5037 | All databases should be deleted before deleting the cluster. |
| 97 | 5038 | The BE node with the specified ID does not exist in the cluster. |
| 98 | 5040 | No cluster with the same name exists. |
| 99 | 5041 | No cluster name specified. |
| 100 | 5042 | No permissions. |
| 101 | 5043 | The number of instances should be greater than 0. |
| 102 | 5046 | Source cluster does not exist. |
| 103 | 5047 | Destination cluster does not exist. |
| 104 | 5048 | Source database does not exist. |
| 105 | 5049 | Destination database does not exist. |
| 106 | 5050 | No cluster selected. |
| 107 | 5051 | The source database should be associated with the destination database first. |
| 108 | 5052 | Intra-cluster error: BE node information is incorrect. |
| 109 | 5053 | There is no migration task from the source database to the destination database. |
| 110 | 5054 | The specified database has been associated with the destination database, or data is being migrated. |
| 111 | 5055 | Database associations or data migrations cannot be performed within the same cluster. |
| 112 | 5056 | Database cannot be deleted: it is associated with another database or data is being migrated. |
| 113 | 5056 | Database cannot be renamed: it is associated with another database or data is being migrated. |
| 114 | 5056 | Insufficient BE nodes in the cluster. |
| 115 | 5056 | The specified number of BE nodes already exists in the cluster. |
| 116 | 5059 | There are BE nodes in the cluster that are in the offline state. |
| 117 | 5062 | The cluster name is illegal: default_cluster is the reserved name. |
| 118 | 5063 | The type name is incorrect. |
| 119 | 5064 | Generic error message. |
| 120 | 5063 | The Colocate feature has been disabled by the administrator. |
| 121 | 5063 | A colocate data table with the same name does not exist. |
| 122 | 5063 | The Colocate table must be an OLAP table. |
| 123 | 5063 | Colocate tables should have the same number of replicas. |
| 124 | 5063 | Colocate tables should have the same number of split buckets. |
| 125 | 5063 | Colocate tables should have the same number of partition columns. |
| 126 | 5063 | Colocate tables should have the same data type of partitioned columns. |
| 127 | 5064 | The specified table is not a colocate table. |
| 128 | 5065 | The specified operation is invalid. |
| 129 | 5065 | The specified time unit is illegal. The correct units are DAY, WEEK, and MONTH. |
| 130 | 5066 | The start value of the dynamic partition should be less than 0. |
| 131 | 5066 | The start value of the dynamic partition is not a valid number. |
| 132 | 5066 | The end value of the dynamic partition should be greater than 0. |
| 133 | 5066 | The end value of the dynamic partition is not a valid number. |
| 134 | 5066 | The end value of the dynamic partition is null. |
| 135 | 5067 | The bucket number of the dynamic partition should be greater than 0. |
| 136 | 5067 | The bucket number of the dynamic partition is not a valid number. |
| 137 | 5066 | The bucket number of the dynamic partition is empty. |
| 138 | 5068 | Whether to allow dynamic partition where the value is not a valid boolean: true or false. |
| 139 | 5069 | The name of the specified dynamic partition has an illegal prefix. |
| 140 | 5070 | The specified operation is disabled. |
| 141 | 5071 | The number of replicas of the dynamic partition should be greater than 0. |
| 142 | 5072 | The number of replicas of the dynamic partition is not a valid number. |
Edit
In this article