{"record":{"id":"415305cae910a1b3","repo":"apache/seatunnel","slug":"common-17-415305","errorCode":"COMMON-17","errorMessage":"'${identifier}' unsupported convert type '${dataType}' of '${field}' to SeaTunnel data type.","messagePattern":"'(.+?)' unsupported convert type '(.+?)' of '(.+?)' to SeaTunnel data type\\.","errorType":"error_code","errorClass":"SeaTunnelRuntimeException","httpStatus":null,"severity":"error","filePath":"seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/vertica/VerticaTypeMapper.java","lineNumber":170,"sourceCode":"                return LocalTimeType.LOCAL_TIME_TYPE;\n            case VERTICA_DATETIME:\n            case VERTICA_TIMESTAMP:\n                return LocalTimeType.LOCAL_DATE_TIME_TYPE;\n\n            case VERTICA_TINYBLOB:\n            case VERTICA_MEDIUMBLOB:\n            case VERTICA_BLOB:\n            case VERTICA_LONGBLOB:\n            case VERTICA_VARBINARY:\n            case VERTICA_BINARY:\n                return PrimitiveByteArrayType.INSTANCE;\n\n                // Doesn't support yet\n            case VERTICA_GEOMETRY:\n            case VERTICA_UNKNOWN:\n            default:\n                final String jdbcColumnName = metadata.getColumnName(colIndex);\n                throw CommonError.convertToSeaTunnelTypeError(\n                        DatabaseIdentifier.VERTICA, type, jdbcColumnName);\n        }\n    }\n}\n","sourceCodeStart":152,"sourceCodeEnd":175,"githubUrl":"https://github.com/apache/seatunnel/blob/cf67b549a7a6c35fa0beb12d83c62892427ea919/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/vertica/VerticaTypeMapper.java#L152-L175","documentation":"VerticaTypeMapper.mapping() maps a Vertica column type to a SeaTunnel type while reading. Spatial types (VERTICA_GEOMETRY), VERTICA_UNKNOWN and any unrecognized type hit the default branch and throw CommonError.convertToSeaTunnelTypeError with the type and column name.","triggerScenarios":"Reading a Vertica table containing GEOMETRY/GEOGRAPHY columns, or columns whose reported type is unknown/unrecognized by the mapper.","commonSituations":"GIS workloads with spatial columns in Vertica; tables created by third-party tools with exotic types; connector version lacking mappings for newer Vertica types.","solutions":["Cast spatial columns to text in the query: SELECT ST_AsText(geom) AS geom_wkt FROM t.","Create a view excluding/casting unsupported columns and read from the view.","Restrict the query to supported columns only.","Add a mapper case for the type if it can be represented and contribute upstream."],"exampleFix":"// before: SELECT * FROM shapes (has GEOMETRY col)\n// after\nSELECT id, ST_AsText(shape) AS shape_wkt FROM shapes","handlingStrategy":"validation","validationCode":"-- Find spatial/unsupported Vertica columns before reading\nSELECT column_name, data_type\nFROM v_catalog.columns\nWHERE table_name = 'my_table'\n  AND data_type IN ('GEOMETRY','GEOGRAPHY');","typeGuard":null,"tryCatchPattern":"try {\n    sourceReader.read();\n} catch (SeaTunnelRuntimeException e) {\n    if (e.getMessage().contains(\"unsupported convert type\")) {\n        // rewrite query with ST_AsText(geom) or a view, then retry\n    } else { throw e; }\n}","preventionTips":["Export spatial columns as WKT (ST_AsText) rather than reading raw GEOMETRY types.","Check v_catalog.columns during pipeline onboarding.","Keep GIS data in dedicated tables and join by ID in ETL queries.","Prefer explicit column lists over SELECT *."],"tags":["jdbc","vertica","type-conversion","source","unsupported-type"],"backgroundTag":"unsupported-dtype","analyzedSha":"cf67b549a7a6c35fa0beb12d83c62892427ea919","analyzedAt":"2026-09-10T21:44:55.265Z","contentChangedAt":"2026-09-10T21:44:55.265Z","schemaVersion":2},"datasetVersion":"2026-09-14T11:17:12.474Z"}