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"?

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 http://grepcode.com/file/repository.grepcod

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 -1