[
https://issues.apache.org/jira/browse/HIVE-4499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13650704#comment-13650704
]
Lukas Eder commented on HIVE-4499:
----------------------------------
The patch fixes the immediate issue encountered in the aforementioned
third-party library, but I really think that data type conversion has to be
implemented more generally, not just for the Double -> BigDecimal and Float ->
BigDecimal conversions
> Implement more versatile data type conversion in Hive JDBC ResultSet
> --------------------------------------------------------------------
>
> Key: HIVE-4499
> URL: https://issues.apache.org/jira/browse/HIVE-4499
> Project: Hive
> Issue Type: Improvement
> Components: JDBC
> Affects Versions: 0.10.0
> Reporter: Lukas Eder
> Attachments: HIVE-4499.patch
>
>
> The Hive JDBC ResultSet cannot convert from Double to BigDecimal, as can be
> seen in this code extract here:
> {code}
> public BigDecimal getBigDecimal(int columnIndex) throws SQLException {
> Object obj = getObject(columnIndex);
> if (obj == null) {
> return null;
> }
> if (obj instanceof BigDecimal) {
> return ((BigDecimal) obj);
> }
> if (obj instanceof HiveDecimal) {
> return ((HiveDecimal) obj).bigDecimalValue();
> }
> throw new SQLException("Cannot convert column " + columnIndex
> + " to BigDecimal. Found data of type: "
> + obj.getClass()+", value: " + obj.toString());
> }
> {code}
> Taken from:
> https://github.com/apache/hive/blob/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveBaseResultSet.java#L107
> This results in interoperability problems with other APIs, such as jOOQ, as
> can be seen in this issue here:
> https://github.com/jOOQ/jOOQ/issues/2442
> It would be nice if Hive could implement more versatile data type conversions
> in its ResultSet (not just for Double/BigDecimal). Some inspiration could be
> taken from
> - Derby (http://db.apache.org/derby)
> - H2 (http://www.h2database.com)
> - HSQLDB (http://hsqldb.org)
> - jOOQ (http://www.jooq.org)
> All of the above implement ResultSets with lots of data type conversion
> capabilities.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
