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

Reply via email to