database-migration icon indicating copy to clipboard operation
database-migration copied to clipboard

Postgres to Exasol HSTORE type not efficiently usable

Open hamx0r opened this issue 6 years ago • 0 comments

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.

hamx0r avatar Oct 03 '19 18:10 hamx0r