For example, in SQL Server, when reading, I want to call a built-in function: 
STAsText()

SELECT id, shape.STAsText() FROM SpatialTable

val df = _sparkSession
        .read
        .jdbc(url, "dbo.SpatialTable", props)
        .select("shape.STAsText()")  // No, this doesn't work.
        .as("shape")

Also when writing, I want to be able to call a built-in function: 
STGeomFromText like this:
INSERT INTO SpatialTable (GeomCol1) VALUES (geometry::STGeomFromText('POLYGON 
((0 0, 150 0, 150 150, 0 150, 0 0))', 0));

How would go about doing this?

Thanks,
Kyunam

Reply via email to