sedona icon indicating copy to clipboard operation
sedona copied to clipboard

Read Geometry Type from Jdbc/beeline

Open MyqueWooMiddo opened this issue 2 years ago • 0 comments

Expected behavior

I can access Geometry colmn via JDBC / beeline consistent with Spark-shell , it prints it's WKT automatically.

Actual behavior

When I execute "select st_point(111,22) " via JDBC , It returns "java.lang.String cannot be cast to [B (state=,code=0)"

Hive-serde treats the Geometry as BINARY_TYPE , but it failed to be cast to byte[] .

Settings

Sedona version = 1.5.0

Apache Spark version = 3.2.2

API type = JDBC

Scala version = 2.12

JRE version = 1.8

Environment = Spark Thrift Server

MyqueWooMiddo avatar Nov 02 '23 11:11 MyqueWooMiddo