Add support for geometry and geography in postgres connector data typ…
Added support for the GEOMETRY type in postgres connector.
Description
Motivation and Context
To enable reading geometry data from postgres tables using Presto.
Impact
Test Plan
Contributor checklist
- [ ] Please make sure your submission complies with our contributing guide, in particular code style and commit standards.
- [ ] PR description addresses the issue accurately and concisely. If the change is non-trivial, a GitHub Issue is referenced.
- [ ] Documented new properties (with its default value), SQL syntax, functions, or other functionality.
- [ ] If release notes are required, they follow the release notes guidelines.
- [ ] Adequate tests were added if applicable.
- [ ] CI passed.
Release Notes
Please follow release notes guidelines and fill in the release notes below.
== RELEASE NOTES ==
Postgres Connector Changes
* Add support for `GEOMETRY <https://prestodb.io/docs/current/language/types.html#geospatial>`_ type in the Postgres connector.
The committers listed above are authorized under a signed CLA.
- :white_check_mark: login: Mariamalmesfer / name: Mariam AlMesfer (4d15916d07430efce42b97cd26d5d6dd7a3fb4d0)
Will https://github.com/prestodb/presto/blob/master/presto-docs/src/main/sphinx/connector/postgresql.rst#type-mapping need to be updated?
Thanks for the release note entry! A couple of suggestions.
== RELEASE NOTES ==
MySQL Connector Changes
* Add support for `GEOMETRY <https://prestodb.io/docs/current/language/types.html#geospatial>`_ type in the Postgres connector.
Please resolve the conflicts.
Please resolve the conflicts.
Resolved the conflicts.
The commit message can be simplified to Add read support for geometry and geography data types in postgres connector
@prestodb/committers can someone please review this?