database-migration
database-migration copied to clipboard
Postgres to Exasol HSTORE type not efficiently usable
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.