You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Robbie Zhang (Jira)" <ji...@apache.org> on 2020/09/14 14:03:00 UTC

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

Robbie Zhang created HIVE-24161:
-----------------------------------

             Summary: 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


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)