Re: What is java.sql.SQLException: Unsupported type -101?

2015-07-17 Thread Ted Yu
Looking at getCatalystType(): * Maps a JDBC type to a Catalyst type. This function is called only when * the JdbcDialect class corresponding to your database driver returns null. sqlType was carrying value of -101 However, I couldn't find -101 in

What is java.sql.SQLException: Unsupported type -101?

2015-07-17 Thread Sambit Tripathy (RBEI/EDS1)
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 at

RE: What is java.sql.SQLException: Unsupported type -101?

2015-07-17 Thread Sambit Tripathy (RBEI/EDS1)
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