{"record":{"id":"1e899b58a3fb6abf","repo":"apache/flink","slug":"unsupported-value-s-for-s-supported-values-ar","errorCode":null,"errorMessage":"Unsupported value '%s' for %s. Supported values are [SQL, ISO-8601].","messagePattern":"Unsupported value '(.+?)' for (.+?)\\. Supported values are \\[SQL, ISO-8601\\]\\.","errorType":"validation","errorClass":"ValidationException","httpStatus":null,"severity":"error","filePath":"flink-formats/flink-json/src/main/java/org/apache/flink/formats/json/JsonFormatOptionsUtil.java","lineNumber":139,"sourceCode":"                Arrays.stream(JsonFormatOptions.MapNullKeyMode.values())\n                        .map(Objects::toString)\n                        .collect(Collectors.toSet());\n        if (!nullKeyModes.contains(tableOptions.get(MAP_NULL_KEY_MODE).toUpperCase())) {\n            throw new ValidationException(\n                    String.format(\n                            \"Unsupported value '%s' for option %s. Supported values are %s.\",\n                            tableOptions.get(MAP_NULL_KEY_MODE),\n                            MAP_NULL_KEY_MODE.key(),\n                            nullKeyModes));\n        }\n        validateTimestampFormat(tableOptions);\n    }\n\n    /** Validates timestamp format which value should be SQL or ISO-8601. */\n    static void validateTimestampFormat(ReadableConfig tableOptions) {\n        String timestampFormat = tableOptions.get(TIMESTAMP_FORMAT);\n        if (!TIMESTAMP_FORMAT_ENUM.contains(timestampFormat)) {\n            throw new ValidationException(\n                    String.format(\n                            \"Unsupported value '%s' for %s. Supported values are [SQL, ISO-8601].\",\n                            timestampFormat, TIMESTAMP_FORMAT.key()));\n        }\n    }\n\n    private JsonFormatOptionsUtil() {}\n}\n","sourceCodeStart":121,"sourceCodeEnd":148,"githubUrl":"https://github.com/apache/flink/blob/2f3c205e9266cb30240eb7f4fdab15cad629a70f/flink-formats/flink-json/src/main/java/org/apache/flink/formats/json/JsonFormatOptionsUtil.java#L121-L148","documentation":"ValidationException from validateTimestampFormat when 'timestamp-format' is not exactly 'SQL' or 'ISO-8601' (exact, case-sensitive membership in TIMESTAMP_FORMAT_ENUM). Thrown during both decoding and encoding option validation, i.e., at CREATE TABLE time.","triggerScenarios":"'timestamp-format' = 'sql' (lowercase), 'iso8601', or any variant spelling in a JSON-format DDL.","commonSituations":"Copy from docs that normalized case; locale-specific config tooling rewriting values; mixing up with other formats' option names.","solutions":["Set 'json.timestamp-format' to exactly 'SQL' or 'ISO-8601'","Pick ISO-8601 for 'yyyy-MM-ddTHH:mm:ss.SSSZ' style, SQL for 'yyyy-MM-dd HH:mm:ss.S{precision}'","Re-run the DDL after the fix"],"exampleFix":"-- before\n'timestamp-format' = 'iso-8601'\n\n-- after\n'timestamp-format' = 'ISO-8601'","handlingStrategy":"validation","validationCode":"JsonFormatOptionsUtil.validateTimestampFormat(tableOptions); // exact-match SQL / ISO-8601","typeGuard":null,"tryCatchPattern":null,"preventionTips":["Remember 'ISO-8601' is case-sensitive with a hyphen; 'sql' lowercase is rejected","Add a pre-deploy check that greps DDL for known option spellings"],"tags":["flink","json","options","timestamp","validation"],"backgroundTag":null,"analyzedSha":"2f3c205e9266cb30240eb7f4fdab15cad629a70f","analyzedAt":"2026-08-14T08:48:24.518Z","schemaVersion":2},"datasetVersion":"2026-08-14T10:17:34.591Z"}