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();