[jira] [Commented] (CALCITE-1957) Cannot read HSQLDB CLOBs from avatica

["Mohan (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16808727#comment-16808727 ] 

Mohan commented on CALCITE-1957:
--------------------------------

Hi Josh/ Team,

I've started using Avatica and it surprised with an error that it cannot support blob/clob types. Is there an ongoing activity on fixing this issue in the next release of Avatica?

> Cannot read HSQLDB CLOBs from avatica
> -------------------------------------
>
>                 Key: CALCITE-1957
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1957
>             Project: Calcite
>          Issue Type: Bug
>          Components: avatica
>            Reporter: Francis Chuang
>            Priority: Major
>
> HSQLDB has a CLOB type for storing character LOBs or really long strings.
> I created a table like so:
> {code}
> CREATE TABLE some_table (
> 	int INTEGER PRIMARY KEY,
> 	clob CLOB,
> )
> {code}
> I inserted the CLOB using the STRING rep type. The insert works correctly.
> However, if I execute `SELECT * FROM some_table`, I get this error from avatica:
> {code}
> RuntimeException: Unhandled type in Frame: class org.hsqldb.jdbc.JDBCClobClient
> {code}
> It seems to be thrown here because Avatica is not able to handle the CLOB type: https://github.com/apache/calcite-avatica/blob/4db1fb9c66db8ccebc9e96ce678154ec69c557f0/core/src/main/java/org/apache/calcite/avatica/remote/TypedValue.java#L865



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)