Hi,
I am trying to read data into Spark from Oracle using ojdb7 driver. The
data is in JSON format. I am getting below error. Any idea on how to
resolve it?
ava.sql.SQLException: Unsupported type -101
at
org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$getCatalystTy
====
My code is very simple
SparkSession spark = SparkSession
.builder()
.appName("Oracle Example")
.master("local[4]")
.getOrCreate();
final Properties connectionProperties = new Properties();
connectionProperties.put("user",*"XXX"*);
connectionProperties.put("password", "XXX"));
final String dbTable =
"(select * from MyTable)";
Dataset<Row> jdbcDF = spark.read().jdbc(*XXXXX*, dbTable, connectionProperties);
//jdbcDF.show();