{"record":{"id":"2047873da0e5604e","repo":"prestodb/presto","slug":"pinot-unsupported-column-type-204787","errorCode":"PINOT_UNSUPPORTED_COLUMN_TYPE","errorMessage":"Not support type conversion for pinot data type: %s","messagePattern":"Not support type conversion for pinot data type: (.+?)","errorType":"error_code","errorClass":"PinotException","httpStatus":null,"severity":"error","filePath":"presto-pinot-toolkit/src/main/java/com/facebook/presto/pinot/PinotColumnUtils.java","lineNumber":153,"sourceCode":"                return DoubleType.DOUBLE;\n            case INT:\n                return IntegerType.INTEGER;\n            case LONG:\n                return BigintType.BIGINT;\n            case STRING:\n                return VarcharType.VARCHAR;\n            case BYTES:\n                return VarbinaryType.VARBINARY;\n            case TIMESTAMP:\n                return TimestampType.TIMESTAMP;\n            case JSON:\n                return JsonType.JSON;\n            case BIG_DECIMAL:\n                return DecimalType.createDecimalType();\n            default:\n                break;\n        }\n        throw new PinotException(PINOT_UNSUPPORTED_COLUMN_TYPE, Optional.empty(), \"Not support type conversion for pinot data type: \" + dataType);\n    }\n}\n","sourceCodeStart":135,"sourceCodeEnd":156,"githubUrl":"https://github.com/prestodb/presto/blob/55bb57d202de3b926896fa966c2c4a44c779634e/presto-pinot-toolkit/src/main/java/com/facebook/presto/pinot/PinotColumnUtils.java#L135-L156","documentation":"getPrestoTypeFromPinotType hits its default branch when a Pinot column DataType has no mapping to a Presto type. The connector refuses to expose the column rather than guessing a lossy conversion (PINOT_UNSUPPORTED_COLUMN_TYPE).","triggerScenarios":"A Pinot table schema contains a column of a DataType the connector doesn't translate (e.g. newer Pinot types like JSON/BIG_DECIMAL/UNKNOWN on an older connector, or truly unmapped types).","commonSituations":"Upgraded Pinot introduced new column types before the connector supports them; SELECT * pulls in a column with an unsupported type; schema evolved to add exotic types (BYTES variants, GEO types) mid-flight.","solutions":["Upgrade the Presto-Pinot connector to a version whose PinotColumnUtils maps the offending DataType","Exclude the unsupported column from your query (select only supported columns instead of *)","Change the Pinot table schema to use a supported type for that column","Add a mapping case in PinotColumnUtils.getPrestoTypeFromPinotType if you build the connector yourself"],"exampleFix":"// before\nSELECT * FROM pinot.mytable  -- includes unsupported column type\n// after\nSELECT supportedCol1, supportedCol2 FROM pinot.mytable","handlingStrategy":"validation","validationCode":"// Check Pinot schema types before selecting a column\ncurl -s http://<controller>:9000/tables/<table>/schema | jq '.columnDataTypes'","typeGuard":null,"tryCatchPattern":null,"preventionTips":["List explicit columns instead of SELECT * when schema may contain exotic types","Keep connector and Pinot versions aligned (new Pinot DataTypes need newer mappings)","Validate table schemas against supported types before exposing them in Presto","If self-building, extend PinotColumnUtils with a mapping for the new DataType"],"tags":["pinot","type-mapping","schema"],"backgroundTag":"unsupported-column-type","analyzedSha":"55bb57d202de3b926896fa966c2c4a44c779634e","analyzedAt":"2026-09-04T12:50:26.162Z","contentChangedAt":"2026-09-04T12:50:26.162Z","schemaVersion":2},"datasetVersion":"2026-09-11T21:17:09.523Z"}