[teiid-issues] [JBoss JIRA] (TEIID-4165) HBase translator - time values are not translated correctly
[
https://issues.jboss.org/browse/TEIID-4165?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4165:
---------------------------------------
I can't say yet if this is our issue. The JDBC/Teiid notion of a time value does
assume a date component of 1970, not 1900. How were the time values created? And if you
can quickly test, does the source support just TIME '05:00:00.0' - without the
date component?
HBase translator - time values are not translated correctly
-----------------------------------------------------------
Key: TEIID-4165
URL: https://issues.jboss.org/browse/TEIID-4165
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12.x
Reporter: Juraj Duráni
Assignee: Steven Hawkins
HBase translator rewrites time values (e.g. \{t '15:00:00'\}) as _TIME
'1970-01-01 15:00:00.0'_. But HBase stores time values with base date
_1900-01-01..._.
Updated source-specific commands returns correct result.
{code:sql}
SELECT g_0.intkey FROM smalla AS g_0 WHERE g_0.timevalue IN (TIME '1900-01-01
05:00:00.0', TIME '1900-01-01 15:00:00.0')
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)