Forum Discussion
Solved
SQL DB Error with geometry::STGeomFromText
Has anyone else run into an error using geometric functions in SQL Database in Fabric? Are thses functions not yet available in Fabric SQL DB? The STGeomFromText (geometry Data Type) article indica...
When I created the ticket on Friday, it didn't run in the SQL Database or SQL Analytics Endpoint, but it did work in Fabric Warehouse (I tried that statement in all). I will close this out as solved now that it is working in SQL Database.
For what it's worth... I'm converting PostgreSQL query to Fabric and I have two ways to solve the problem I'm working on
- Use recursive cte (must be SQL DB) using the geometry::STGeomFromText() funtion which is the error in this thread
- My preferred method is to use Fabric Warehouse and the geometry::UnionAggregate() funtion, but it returns "Invalid Plan" for any query except the most basic (meaning WKT Linestring hard coded in CTE). If I save the same simple data to a table and try to run, I get "Invalid Plan". My query is more complicated, but I was willing to save to a table to continue processing using the geometry::UnionAggregate().
In US West region the query runs fine against the SQL Database but not against its SQL Analytics Endpoint.