[teiid-issues] [JBoss JIRA] (TEIID-3616) HBase translator - NPE if date value is 'null'

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13096967#comment-13096967 ] 

Ramesh Reddy commented on TEIID-3616:
-------------------------------------

I believe the HBase translator support is only provided through Pheonix driver, are you using some other JDBC driver for this?

> HBase translator - NPE if date value is 'null'
> ----------------------------------------------
>
>                 Key: TEIID-3616
>                 URL: https://issues.jboss.org/browse/TEIID-3616
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1.6_2
>         Environment: Hbase: 1.1.1
> Phoenix: 4.5.0-HBase-1.1
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>         Attachments: log
>
>
> If the source table in HBase contains a 'NULL' date value, Teiid throws an NPE. I did not encounter any NPE using org.apache.phoenix.jdbc.PhoenixDriver [1]. Other data types seem to be OK too.
> I have tried integer, char, varchar, float, double, tinyint, smallint, bigint, decimal, varbinary, boolean, time, date, timestamp.
> [1]
> Connection con = new org.apache.phoenix.jdbc.PhoenixDriver().connect("jdbc:phoenix:localhost", new Properties())
> ResultSet rs = con.createStatement().executeQuery("select datevalue from smalla");
> while(rs.next()){
>   System.out.println(rs.getDate(1));
> }



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)