[LIVY-699] [LIVY-699][THRIFT] Fix resultSet.getBigDecimal throw java.sql.SQLException: Illegal conversion

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: 0.7.0
• Assignee: Jie Wang
• Reporter: Jie Wang
• Created: 21/Oct/19 13:33
• Updated: 12/Nov/19 10:28
• Resolved: 12/Nov/19 10:28

Description

LIVY-699[THRIFT] Fix resultSet.getBigDecimal throw java.sql.SQLException: Illegal conversion.

Follows are steps to reproduce the problem:

1. create table test(id decimal).
2. Then resultSet.getBigDecimal(1) will throw: java.sql.SQLException: Illegal conversion. The reason is getSchema().getColumnDescriptorAt(columnIndex - 1).getType(); at https://github.com/apache/hive/blob/master/jdbc/src/java/org/apache/hive/jdbc/HiveBaseResultSet.java#L415 return string, so cannot pass the check val instanceof BigDecimal at https://github.com/apache/hive/blob/master/jdbc/src/java/org/apache/hive/jdbc/HiveBaseResultSet.java#L133, so throw java.sql.SQLException: Illegal conversion at https://github.com/apache/hive/blob/master/jdbc/src/java/org/apache/hive/jdbc/HiveBaseResultSet.java#L137

Additionally, SparkThrift return decimal instead of string in the same case, so it is necessary to return decimal instead of string in livy. The same to timestamp and date.

Issue Links

• links to: GitHub Pull Request #247