Hi
I'm not able to read "Oracle Table - TIMESTAMP(6) WITH TIME ZONE datatype"
column using Spark SQL.
I'm getting below exception. Please let me know how to resolve this issue.
*Exception :-*
Exception in thread "main" java.sql.SQLException: U
...@host.com:1517:sid, dbtable -
USER.TABLE,driver - oracle.jdbc.OracleDriver))
and got the error below
java.sql.SQLException: Unsupported type -101
at
org.apache.spark.sql.jdbc.JDBCRDD$.getCatalystType(JDBCRDD.scala:78)
at
org.apache.spark.sql.jdbc.JDBCRDD$.resolveTable
Hi,
I was trying to get a oracle table using JDBC datasource
val jdbcDF = sqlContext.load(jdbc, Map( url -
jdbc:oracle:thin:USER/p...@host.com:1517:sid, dbtable -
USER.TABLE,driver - oracle.jdbc.OracleDriver))
and got the error below
java.sql.SQLException: Unsupported type -101
Does this mean there is a possible mismatch of jdbc driver with oracle?
From: Ted Yu [mailto:yuzhih...@gmail.com]
Sent: Friday, July 17, 2015 2:09 PM
To: Sambit Tripathy (RBEI/EDS1)
Cc: user@spark.apache.org
Subject: Re: What is java.sql.SQLException: Unsupported type -101?
Looking