seafowl icon indicating copy to clipboard operation
seafowl copied to clipboard

Add support for PG arrays in remote tables

Open gruuya opened this issue 2 years ago • 0 comments

Currently we can't query remote PG tables with array fields since there's a lack of conversion rules:

PostgresArrowTransportError(ConnectorX(NoConversionRule(\"Int4Array(true)\", \"connectorx::destinations::arrow::typesystem::ArrowTypeSystem\")))")

Maybe there's a recursive way to convert the value to an arrow list, or a wholesale way to convert all unknown types to strings via pg ::varchar casts in our connectorx fork.

gruuya avatar Nov 14 '22 14:11 gruuya