[SPARK-17355] Work around exception thrown by HiveResultSetMetaData.isSigned

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.1, 2.1.0
• Component/s: SQL
• Assignee: Josh Rosen
• Reporter: Josh Rosen
• Created: 01/Sep/16 05:48
• Updated: 01/Sep/16 23:46
• Resolved: 01/Sep/16 23:46

Description

Attempting to use Spark SQL's JDBC data source against the Hive ThriftServer results in a java.sql.SQLException: Method not supported exception from org.apache.hive.jdbc.HiveResultSetMetaData.isSigned. Here are two user reports of this issue:

• https://stackoverflow.com/questions/34067686/spark-1-5-1-not-working-with-hive-jdbc-1-2-0
• https://stackoverflow.com/questions/32195946/method-not-supported-in-spark

I have filed HIVE-14684 to attempt to fix this in Hive by implementing the isSigned method, but in the meantime / for compatibility with older JDBC drivers I think we should add special-case error handling to work around this bug.

Issue Links

• relates to: HIVE-14684 HiveResultSetMetaData.isSigned throws "Method not supported" exception
• links to: [Github] Pull Request #14911 (JoshRosen)