- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2022 12:07 AM
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-19-2022 12:15 PM
The only method I have been able to successfully write in geography data was to have the table schema already defined with a geography column and then 'APPEND' the data to it. Anytime I would try with OVERWRITE it seemingly changed the data type to string.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2022 12:54 AM
Hi @Ayushi Pandey are you looking for Geomesa library support? If so please refer this notebook.
https://www.databricks.com/notebooks/geomesa-h3-notebook.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2022 02:15 AM
No, I want to know if Databricks supports writing Geography/Geometry data back into BigQuery? When I try to write it to BQ, it shows as incorrect BYTES data.
I performed the below statement and it ran successfully in Databricks:
val wktDF = wktDFText.withColumn("bq_geography", st_geomFromWKT(col("bq_geography"))).cache
But when loading this wktDF to BigQuery, data is seen like this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2022 02:19 AM
Do let me know if this is an expected behaviour since Spark does not natively support Geography/Geometry types.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-19-2022 12:15 PM
The only method I have been able to successfully write in geography data was to have the table schema already defined with a geography column and then 'APPEND' the data to it. Anytime I would try with OVERWRITE it seemingly changed the data type to string.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2022 03:37 AM
Thanks a lot! That worked 🙂

