]
Juraj Duráni commented on TEIID-3616:
-------------------------------------
There is also one issue with teiid's insert statement. It translates it as UPSERT
which is an "alias" for both insert and update. Does teiid distinguish between
those statements?
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));
}