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
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"?
ext.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.SQLExcept
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.OracleD
