TDengine Error Codes | TDengine TSDB Docs
Suggested Actions for Users0x80002600syntax error nearSQL syntax errorCheck and correct the SQL statement0x80002601Incomplete SQL statementIncomplete SQL statementCheck and correct the SQL statement0x80002602Invalid column nameIllegal or non-existent column nameCheck and correct the SQL statement0x80002603Table does not existTable does not existCheck and confirm the existence of the table in the SQL statement0x80002604Column ambiguously definedColumn (alias) redefinedCheck and correct the SQL statement0x80002605Invalid value typeIllegal constant valueCheck and correct the SQL statement0x80002608There mustn't be aggregationAggregation function used in illegal clauseCheck and correct the SQL statement0x80002609ORDER BY item must be the number of a SELECT-list expressionIllegal position specified in Order byCheck and correct the SQL statement0x8000260ANot a GROUP BY expressionIllegal group by statementCheck and correct the SQL statement0x8000260BNot SELECTed expressionIllegal expressionCheck and correct the SQL statement0x8000260CNot a single-group group functionIllegal use of column and functionCheck and correct the SQL statement0x8000260DTags number not matchedMismatched number of tag columnsCheck and correct the SQL statement0x8000260EInvalid tag nameInvalid or non-existent tag nameCheck and correct the SQL statement0x80002610Value is too longValue length exceeds limitCheck and correct the SQL statement or API parameters0x80002611Password too short or emptyPassword is empty or less than 8 charsUse a valid password0x80002612Port should be an integer that is less than 65535 and greater than 0Illegal port numberCheck and correct the port number0x80002613Endpoint should be in the format of 'fqdn:port'Incorrect address formatCheck and correct the address information0x80002614This statement is no longer supportedFeature has been deprecatedRefer to the feature documentation0x80002615Interval too smallInterval value exceeds the allowed minimumChange the INTERVAL value0x80002616Database not specifiedDatabase not specifiedSpecify the database for the current operation0x80002617Invalid identifier nameIllegal or invalid length IDCheck the names of related libraries, tables, columns, TAGs, etc. in the statement0x80002618Corresponding supertable not in this dbSupertable does not existCheck if the corresponding supertable exists in the database0x80002619Invalid database optionIllegal database option valueCheck and correct the database option values0x8000261AInvalid table optionIllegal table option valueCheck and correct the table option values0x80002624GROUP BY and WINDOW-clause can't be used togetherGroup by and window cannot be used togetherCheck and correct the SQL statement0x80002627Aggregate functions do not support nestingFunctions do not support nested useCheck and correct the SQL statement0x80002628Only support STATE_WINDOW on integer/bool/varchar columnUnsupported STATE_WINDOW data typeCheck and correct the SQL statement0x80002629Not support STATE_WINDOW on tag columnSTATE_WINDOW not supported on tag columnCheck and correct the SQL statement0x8000262ASTATE_WINDOW not support for supertable querySTATE_WINDOW not supported for supertableCheck and correct the SQL statement0x8000262BSESSION gap should be fixed time window, and greater than 0Illegal SESSION window valueCheck and correct the SQL statement0x8000262COnly support SESSION on primary timestamp columnIllegal SESSION window columnCheck and correct the SQL statement0x8000262DInterval offset cannot be negativeIllegal INTERVAL offset valueCheck and correct the SQL statement0x8000262ECannot use 'year' as offset when interval is 'month'Illegal INTERVAL offset unitCheck and correct the SQL statement0x8000262FInterval offset should be shorter than intervalIllegal INTERVAL offset valueCheck and correct the SQL statement0x80002630Does not support sliding when interval is natural month/yearIllegal sliding unitCheck and correct the SQL statement0x80002631sliding value no larger than the interval valueIllegal sliding valueCheck and correct the SQL statement0x80002632sliding value can not less than 1%% of interval valueIllegal sliding valueCheck and correct the SQL statement0x80002633Only one tag if there is a json tagOnly single JSON tag column supportedCheck and correct the SQL statement0x80002634Query block has incorrect number of result columnsMismatched number of columnsCheck and correct the SQL statement0x80002635Incorrect TIMESTAMP valueIllegal primary timestamp column valueCheck and correct the SQL statement0x80002637soffset/offset can not be less than 0Illegal soffset/offset valueCheck and correct the SQL statement0x80002638slimit/soffset only available for PARTITION/GROUP BY queryslimit/soffset only supported for PARTITION BY/GROUP BY statementsCheck and correct the SQL statement0x80002639Invalid topic queryUnsupported TOPIC query0x8000263ACannot drop supertable in batchBatch deletion of supertables not supportedCheck and correct the SQL statement0x8000263BStart(end) time of query range required or time range too largeWindow count exceeds limitCheck and correct the SQL statement0x8000263CDuplicated column namesDuplicate column namesCheck and correct the SQL statement0x8000263DTags length exceeds max lengthtag value length exceeds maximum supported rangeCheck and correct the SQL statement0x8000263ERow length exceeds max lengthRow length check and correct SQL statementCheck and correct the SQL statement0x8000263FIllegal number of columnsIncorrect number of columnsCheck and correct the SQL statement0x80002640Too many columnsNumber of columns exceeds limitCheck and correct the SQL statement0x80002641First column must be timestampThe first column must be the primary timestamp columnCheck and correct the SQL statement0x80002642Invalid binary/nchar column/tag lengthIncorrect length for binary/ncharCheck and correct the SQL statement0x80002643Invalid number of tag columnsIncorrect number of tag columnsCheck and correct the SQL statement0x80002644Permission deniedPermission errorCheck and confirm user permissions0x80002645Invalid stream queryIllegal stream statementCheck and correct the SQL statement0x80002646Invalid _c0 or_rowts expressionIllegal use of _c0 or_rowtsCheck and correct the SQL statement0x80002647Invalid timeline functionFunction depends on non-existent primary timestampCheck and correct the SQL statement0x80002648Invalid passwordPassword does not meet standardsCheck and change the password0x80002649Invalid alter table statementIllegal modify table statementCheck and correct the SQL statement0x8000264APrimary timestamp column cannot be droppedPrimary timestamp column cannot be deletedCheck and correct the SQL statement0x8000264BOnly binary/nchar column length could be modified, and the length can only be increased, not decreasedIllegal column modificationCheck and correct the SQL statement0x8000264CInvalid tbname pseudocolumnIllegal use of tbname columnCheck and correct the SQL statement0x8000264DInvalid function nameIllegal function nameCheck and correct the function name0x8000264EComment too longComment length exceeds limitCheck and correct the SQL statement0x8000264FFunction(s) only allowed in SELECT list, cannot mixed with non scalar functions or columnsIllegal mixing of functionsCheck and correct the SQL statement0x80002650Window query not supported, since no valid timestamp column included in the result of subqueryWindow query depends on non-existent primary timestamp columnCheck and correct the SQL statement0x80002651No columns can be droppedEssential columns cannot be deletedCheck and correct the SQL statement0x80002652Only tag can be json typeNormal columns do not support JSON typeCheck and correct the SQL statement0x80002655The DELETE statement must have a definite time window rangeIllegal WHERE condition in DELETE statementCheck and correct the SQL statement0x80002656The REDISTRIBUTE VGROUP statement only support 1 to 3 dnodesIllegal number of DNODEs specified in REDISTRIBUTE VGROUPCheck and correct the SQL statement0x80002657Fill now allowedFunction does not allow FILL featureCheck and correct the SQL statement0x80002658Invalid windows pcIllegal use of window pseudocolumnCheck and correct the SQL statement0x80002659Window not allowedFunction cannot be used in windowCheck and correct the SQL statement0x8000265AStream not allowedFunction cannot be used in stream computationCheck and correct the SQL statement0x8000265BGroup by not allowedFunction cannot be used in groupingCheck and correct the SQL statement0x8000265DInvalid interp clauseIllegal INTERP or related statementCheck and correct the SQL statement0x8000265ENot valid function ion windowIllegal window statementCheck and correct the SQL statement0x8000265FOnly support single tableFunction only supported in single table queriesCheck and correct the SQL statement0x80002660Invalid sma indexIllegal creation of SMA statementCheck and correct the SQL statement0x80002661Invalid SELECTed expressionInvalid query statementCheck and correct the SQL statement0x80002662Fail to get table infoFailed to retrieve table metadata informationPreserve the scene and logs, report issue on GitHub0x80002663Not unique table/aliasTable name (alias) conflictCheck and correct the SQL statement0x80002664Join requires valid time-series inputUnsupported JOIN query without primary timestamp column output in subqueryCheck and correct the SQL statement0x80002665The _TAGS pseudocolumn can only be used for subtable and supertable queriesIllegal tag column queryCheck and correct the SQL statement0x80002666Subquery does not output primary timestamp columnCheck and correct the SQL statement0x80002667Invalid usage of expr: %sIllegal expressionCheck and correct the SQL statement0x80002687True_for duration cannot be negativeUse negative value as true_for durationCheck and correct the SQL statement0x80002688Cannot use 'year' or 'month' as true_for durationUse year or month as true_for_durationCheck and correct the SQL statement0x80002689Invalid using cols functionIllegal using cols functionCheck and correct the SQL statement0x8000268ACols function's first param must be a select function that output a single rowThe first parameter of the cols function should be a selection functionCheck and correct the SQL statement0x8000268BInvalid using alias for cols functionIllegal cols function aliasCheck and correct the SQL statement0x8000268CJoin primary key col must be timestamp typeJoin primary key data type errorCheck and correct the SQL statement0x8000268DInvalid virtual table's ref columnCreate/Update Virtual table using incorrect data source columnCheck and correct the SQL statement0x8000268EInvalid table typeIncorrect Table typeCheck and correct the SQL statement0x8000268FInvalid ref column typeVirtual table's column type and data source column's type are differentCheck and correct the SQL statement0x80002690Create child table using virtual super tableCreate non-virtual child table using virtual super tableCheck and correct the SQL statement0x80002696Invalid sliding offsetInvalid sliding offsetCheck and correct the SQL statement0x80002697Invalid interval offsetInvalid interval offsetCheck and correct the SQL statement0x80002698Invalid extend valueInvalid extend valueCheck and correct the SQL statement0x80002699Algorithm ID too long, max length is 63 characterInvalid algorithm id valueCheck and correct the SQL statement0x8000269AAlgorithm name too long, max length is 63 characterInvalid algorithm name valueCheck and correct the SQL statement0x8000269BAlgorithm description too long, max length is 127 characterInvalid algorithm description valueCheck and correct the SQL statement0x8000269CAlgorithm type too long, max length is 63 characterInvalid algorithm type valueCheck and correct the SQL statement0x8000269DAlgorithm OpenSSL name too long, max length is 63 characterInvalid algorithm OpenSSL name valueCheck and correct the SQL statement0x8000269EOption duplicatedOption is only allowed to appear once but appeared twice or moreCheck and correct the SQL statement0x8000269FInvalid option valueInvalid option valueCheck and correct the SQL statement0x800026A0Option value too longOption value too longCheck and correct the SQL statement0x800026A1Option value too shortOption value too shortCheck and correct the SQL statement0x800026A2Option value too bigOption value too bigCheck and correct the SQL statement0x800026A3Option value too smallOption value too smallCheck and correct the SQL statement0x800026AAAggregate functions cannot be used for sorting in non-aggregate queriesInvalid ORDER BY clause clauseCheck and correct the SQL statement0x800026ABTRUE_FOR COUNT must be a non-negative integer not exceeding INT32_MAXThe value for COUNT in a TRUE_FOR expr is invalidCheck and correct the SQL statement0x800026ACInvalid fill modeUsing fill(near) mode in interval windowUse supported fill modes for interval window0x800026ADInvalid fill valuesIncorrect use of fill values parameterUse the correct fill mode with fill values parameter0x800026AEInvalid surrounding time valuesIncorrect surrounding time value providedUse correct and valid time range and time unit0x800026AFInvalid offset unitInvalid time unit used in offset clauseCheck and correct the SQL statement0x800026B0Invalid offset valueInvalid offset value in time windowCheck and correct the SQL statement0x800026B1WHERE clause cannot reference EXTERNAL_WINDOW columnThe WHERE clause references a column from the EXTERNAL_WINDOW subquery aliasMove the filter condition to the SELECT list or use HAVING, do not reference EXTERNAL_WINDOW columns in WHERE0x800026FFParser internal errorInternal error in parserPreserve the scene and logs, report issue on GitHub0x80002700Planner internal errorInternal error in plannerPreserve the scene and logs, report issue on GitHub0x80002701Expect ts equalJOIN condition validation failedPreserve the scene and logs, report issue on GitHub0x80002702Cross join not supportCROSS JOIN not supportedCheck and correct the SQL statement0x80002704Planner slot key not foundPlanner cannot find slotId during making physic planPreserve the scene and logs, report issue on GitHub0x80002705Planner invalid table typePlanner get invalid table typePreserve the scene and logs, report issue on GitHub0x80002706Planner invalid query control plan typePlanner get invalid query control plan type during making physic planPreserve the scene and logs, report issue on GitHub0x80002707Planner invalid window typePlanner get invalid window type during making physic planPreserve the scene and logs, report issue on GitHub