[
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)
