Member since
06-24-2020
1
Post
0
Kudos Received
0
Solutions
06-24-2020
09:13 AM
Getting same conversion issues for below schema. root
|-- instance: string (nullable = true)
|-- count(*): long (nullable = true) Error Message: java.sql.SQLDataException: [Simba][JDBC](10140) Error converting value to long.
at com.cloudera.exceptions.ExceptionConverter.toSQLException(Unknown Source)
at com.cloudera.utilities.conversion.TypeConverter.toLong(Unknown Source)
at com.cloudera.jdbc.common.SForwardResultSet.getLong(Unknown Source)
at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$makeGetter$8.apply(JdbcUtils.scala:409)
at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$makeGetter$8.apply(JdbcUtils.scala:408)
at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anon$1.getNext(JdbcUtils.scala:330)
at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anon$1.getNext(JdbcUtils.scala:312) Can anyone please help on resolving this issue in spark java.
... View more