Hi, team, sqlalchemy does not support the data typ...
# ingestionr
rhythmic-sundown-12093
12/07/2021, 4:38 AMHi, team, sqlalchemy does not support the data type: geometry
Copy code
lib/python3.8/site-packages/sqlalchemy/dialects/mysql/reflection.py:192: SAWarning: Did not recognize type 'geometry' of column 'GeoShape'i
incalculable-ocean-74010
12/07/2021, 10:21 AMHello,
What version of MySQL are you using?
r
rhythmic-sundown-12093
12/08/2021, 9:29 AM@incalculable-ocean-74010 Hi，5.7
👍 1
i
incalculable-ocean-74010
12/08/2021, 9:44 AMI think the issue here is that the datahub needs to use an extension of sqlalchemy to understand spatial properties. For that there is geoalchemy: https://geoalchemy-2.readthedocs.io/en/latest/
incalculable-ocean-74010
12/08/2021, 9:50 AMCan I ask you to please open a ticket in DataHub’s issue tracking so we can take a look at this?
r
rhythmic-sundown-12093
12/09/2021, 1:48 AMHi, Maybe you need to wait, I can't login to github in company
rhythmic-sundown-12093
12/13/2021, 6:17 AM@incalculable-ocean-74010 https://github.com/linkedin/datahub/issues/3704