[jira] [Resolved] (HIVE-24161) Support Oracle CLOB type in beeline

["Zoltan Haindrich (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-24161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zoltan Haindrich resolved HIVE-24161.
-------------------------------------
    Fix Version/s: 4.0.0
       Resolution: Fixed

merged into master. Thank you [~robbiezhang]!

> Support Oracle CLOB type in beeline
> -----------------------------------
>
>                 Key: HIVE-24161
>                 URL: https://issues.apache.org/jira/browse/HIVE-24161
>             Project: Hive
>          Issue Type: Improvement
>          Components: Beeline
>            Reporter: Robbie Zhang
>            Assignee: Robbie Zhang
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> We can use beeline as a JDBC client to access RDBMS such as Oracle. Sometimes Oracle JDBC driver will return a CLOB object instead of a String object if the string is too long. Beeline used to work well with CLOB type but it's broken by HIVE-14786:
> [https://github.com/apache/hive/blob/2a760dd607e206d7f1061c01075767ecfff40d0c/beeline/src/java/org/apache/hive/beeline/Rows.java#L169]
> In the above line, when Oracle JDBC driver returns a CLOB object, it returns a string like "oracle.sql.CLOB@2f7c7260". In this case, we should use ResultSet.getString() rather than ResultSet.getObject().toString().



--
This message was sent by Atlassian Jira
(v8.3.4#803005)