メインコンテンツまでスキップ

INVALID_INTERVAL_FORMAT error condition

SQLSTATE: 22006

Error parsing '<input>' to interval. Please ensure that the value provided is in a valid format for defining an interval. You can reference the documentation for the correct format.

ARITHMETIC_EXCEPTION​

Uncaught arithmetic exception while parsing '<input>'.

DAY_TIME_PARSING​

Error parsing interval day-time string: <msg>.

INPUT_IS_EMPTY​

Interval string cannot be empty.

INPUT_IS_NULL​

Interval string cannot be null.

INTERVAL_PARSING​

Error parsing interval <interval> string.

INVALID_FRACTION​

<unit> cannot have fractional part.

INVALID_PRECISION​

Interval can only support nanosecond precision, <value> is out of range.

INVALID_PREFIX​

Invalid interval prefix <prefix>.

INVALID_UNIT​

Invalid unit <unit>.

INVALID_VALUE​

Invalid value <value>.

MISSING_NUMBER​

Expect a number after <word> but hit EOL.

MISSING_UNIT​

Expect a unit name after <word> but hit EOL.

SECOND_NANO_FORMAT​

Interval string does not match second-nano format of ss.nnnnnnnnn.

TIMEZONE_INTERVAL_OUT_OF_RANGE​

The interval value must be in the range of [-18, +18] hours with second precision.

UNKNOWN_PARSING_ERROR​

Unknown error when parsing <word>.

UNMATCHED_FORMAT_STRING​

Interval string does not match <intervalStr> format of <supportedFormat> when cast to <typeName>: <input>.

UNMATCHED_FORMAT_STRING_WITH_NOTICE​

Interval string does not match <intervalStr> format of <supportedFormat> when cast to <typeName>: <input>. Set "spark.sql.legacy.fromDayTimeString.enabled" to "true" to restore the behavior before Spark 3.0.

UNRECOGNIZED_NUMBER​

Unrecognized number <number>.

UNSUPPORTED_FROM_TO_EXPRESSION​

Cannot support (interval '<input>' <from> to <to>) expression.