Open
Description
Postgres has a column type called HSTORE which is represented as a CSV string with "key1"=>"value1", "key2"=>"value2"
pairs. While this can be parsed with a Python UDF once in Exasol, it is inefficient compared to parsing JSON in Pyton since the cjson
library is include with Exasol.
Postgres has a hstore_to_json()
function which would convert an HSTORE column a JSON string. This Issue is a feature request to use that function so that when migrated to Exasol, HSTORE columns become JSON strings for more efficient parsing.
Metadata
Metadata
Assignees
Labels
No labels