[jira] [Commented] (CALCITE-779) RemoteMeta can't handle Phoenix's TIME datatype

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

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

Lukas Lalinsky commented on CALCITE-779:
----------------------------------------

The same thing happens for TIMESTAMP, but it works for DATE.

> RemoteMeta can't handle Phoenix's TIME datatype
> -----------------------------------------------
>
>                 Key: CALCITE-779
>                 URL: https://issues.apache.org/jira/browse/CALCITE-779
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Lukas Lalinsky
>            Assignee: Julian Hyde
>
> I'm not sure if this is a bug in Calcite or Phoenix, but it seems that RemoteMeta can't read java.sql.Time values from a result set.
> {noformat}
> 0: jdbc:phoenix:thin:url=http://localhost:876> create table test_time (a integer primary key, b time);
> No rows affected (2.548 seconds)
> 0: jdbc:phoenix:thin:url=http://localhost:876> upsert into test_time values (1, current_time());
> 1 row affected (0.101 seconds)
> 0: jdbc:phoenix:thin:url=http://localhost:876> select * from test_time;
> java.lang.AssertionError: bad OBJECT
>         at org.apache.calcite.avatica.util.AbstractCursor.createAccessor(AbstractCursor.java:145)
>         at org.apache.calcite.avatica.util.AbstractCursor.createAccessors(AbstractCursor.java:69)
>         at org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:187)
>         at org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:470)
>         at org.apache.calcite.avatica.remote.RemoteMeta.prepareAndExecute(RemoteMeta.java:165)
>         at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:474)
>         at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:108)
>         at org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:120)
>         at sqlline.Commands.execute(Commands.java:822)
>         at sqlline.Commands.sql(Commands.java:732)
>         at sqlline.SqlLine.dispatch(SqlLine.java:808)
>         at sqlline.SqlLine.begin(SqlLine.java:681)
>         at sqlline.SqlLine.start(SqlLine.java:398)
>         at sqlline.SqlLine.main(SqlLine.java:292)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)