SDF Error codes are designed to simplify debugging. Each error code is a 3-digit number in the range [100, 999], stored as a u16 value. These codes are grouped into ranges. Error codes pertain only to SQL statements, not to networking, YML, or other configuration.

  • [101 -> 200] - Syntax errors
  • [201 -> 300] - Semantic errors
  • [301 -> 400] - Logical Plan Builder
  • [401 -> 400] - Coarse grained errors relating to an entire block or expression
  • [>900] - Internal, unexpected or unknown errors

Error Code Reference

Error CodeError Name
1000Generic
1001IoError
1002EncodingError
1003FileIoError
1004CacheError
1005InvalidConfig
1006InvalidPath
1007InvalidArgument
1008MissingArgument
1009InferenceError
1010InvalidTable
1011AuthenticationError
1012MissingClassifiers
1013SerializationError
1014RemoteError
1015ExecutionError
1016ArrowError
1017ParquetError
1018ObjectStoreError
1019LogicalPlanError
1020ResourceError
1021GenericDatafusionError
1022CyclicDependency
1023UnsupportedFileFormat
1024FileNotFound
1025MissingTable
1026InvalidType
1027MergeConflict
1028MissingSourceLocation
1029TooManyRows
1030TableMissingProvider
1031AmbiguousRenamingSpecification
1032UndefinedField
1033DuplicateColumns
1034MissingWorkspaceFile
1035InvalidEnvironment
1036DuplicateEnvironment
1037UnsupportedWorkspaceEdition
1038CredentialsError
1039LintCheckFailed
1040SubprocessError
1041FmtError
1042FunctionDefinitionError
1043BuildError
1500MacroUnsupportedValueType
1501JinjaError
1502MacroSyntaxError
1503MacroVarNotFound
1504InvalidSeedValue
2000SessionError
2001UnsupportedLocalExecutionDialect
8998InvalidDialect
8999RuntimeError
8997InvalidUserInput
9000NotSupported
9001Unknown
9002Unexpected
9003NotImplemented
9004InvalidTableNameInCLI
101SyntaxError
102SchemaError
103MalformedExpression
104DanglingComma
105AmbiguousColumnReference
106FunctionCaseMismatch
107KeywordCaseMismatch
108BooleanLiteralCaseMismatch
109NullLiteralCaseMismatch
110PrimitiveTypeCaseMismatch
111StatementMustEndWithSemicolon
112InconsistentReference
113PreferCTE
114JoinCriteriaWrongReferenceOrder
115WildcardBeforeSingleTargets
116RequireDereference
117InvalidIdentifierCharacter
118UnnecessaryQuoting
119UnnecessaryElse
120UnnecessaryCase
121UnreferencedCTE
122NestedCase
123DistinctUsedWithParentheses
124BlockedWord
125KeywordUsedAsIdentifier
126ImplicitCoerced
127LinterError
128SubstitutionRequiresTableAlias
129ColumnNameCaseMismatch
199PySparkError
201NameNotFound
202AmbiguousName
203InvalidUnnest
204InvalidLiteral
205InvalidEscape
206InvalidInterval
207InvalidProperty
208UnknownVariable
209FunctionResolutionFailed
210TableFunctionResolutionFailed
211SchemaMismatch
212DuplicateCteName
213UnaggregatedColumn
214TableNotFound
215TableWildcardNotFound
216InvalidGroupByOrdinal
217InvalidAlias
218InvalidHavingClause
219UnresolvedColumnOrdinal
220ColumnAliasMismatch
221InvalidTableName
222InvalidSetOperation
223InvalidPatternRecognition
224InvalidJoinCriteria
225TableMissingLocation
226NonUniformTypeArray
227UnresolvedIdentifier
228IncompatibleTypes
229DuplicateProperty
230IllegalType
231InvalidTimeUnit
232UnresolvedRegex
233UnresolvedGroupBy
234UnresolvedWindow
235InvalidStruct
236UnknownFunctionLanguage
237UnresolvedStage
238InvalidBooleanExpression
239InvalidPartitionBy
240InvalidStageName
241SnowflakeNotSupportTimeUnitAfterInterval
242ImplicitColumnAlias
243InvalidSchemaName
244UnknownType
245CatalogNotFound
246SchemaNotFound
247InvalidSchema
248AsteriskNeedsInput
401BadQueryNoWith
402BadRowCount
403BadInlineTable
404BadQuery
405BadTableFunctionArgument
406InvalidPredicate
407InvalidComparison
408InvalidBetween
409InvalidInList
410InvalidInSubquery
411InvalidArithmetic
412InvalidConcatenation
413InvalidValueExpression
414InvalidListAgg
415InvalidCase
416InvalidCast
417InvalidFunctionCall
418InvalidSubscript
419InvalidDereference
420InvalidJsonExists
421InvalidJsonValue
422InvalidJsonQuery
423InvalidPrimaryExpression
424InvalidJsonObject
425InvalidQualifiedName
426InvalidJsonArray
427InvalidColumnReference
428InvalidSqlFunction
429InvalidDeclare
430InvalidNamedArgument
431InvalidInsertInto
432InvalidPivot
433InvalidExpression
434InvalidCollate
435InvalidRegexp
436InvalidFunctionName
301ProjectionFailed
302JoinFailed
303AggregateFailed
304SetOperationFailed
305SortFailed
306LimitFailed
307CreateViewFailed
308CreateTableFailed
309CreateIndexFailed
310InsertIntoFailed
311DistinctFailed
312ValuesFailed
313HavingFailed
314WindowFailed
315TableAliasFailed
316ScanFailed
317FilterFailed
318RecursiveCTEFailed
892LegacyBinder
893LegacyParser
894LegacyDatafusion
9900FrontendNotSupported
9901FrontendUnknown
9902FrontendUnexpected
9903FrontendNotImplemented
9904FrontendAntlrError
9905FrontendExecutionError