[teiid-issues] [JBoss JIRA] (TEIID-2814) HIVE: quote is removed for TIMESTAMP field in where clause
[
https://issues.jboss.org/browse/TEIID-2814?page=com.atlassian.jira.plugin...
]
Ivan Chan commented on TEIID-2814:
----------------------------------
It doesn't crush now, but it still doesn't return any data. I think you guys
still need to change the syntax a little for HIVE to work.
https://issues.apache.org/jira/browse/HIVE-2558
http://stackoverflow.com/questions/14071589/date-comparison-in-hive
HIVE: quote is removed for TIMESTAMP field in where clause
-----------------------------------------------------------
Key: TEIID-2814
URL: https://issues.jboss.org/browse/TEIID-2814
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.6
Environment: HIVE and Teiid 8.6
Reporter: Ivan Chan
Assignee: Steven Hawkins
Labels: teiid
Fix For: 8.4.2, 8.7
I am running teiid 8.6 against HIVE. And I found out that quote was removed for
TIMESTAMP field in where clause. And it caused java.sql.SQLException: Error while
processing statement: FAILED: ParseException line 1:88 missing EOF
Original SQL:
select "the_date",
"store_sales"
from "hive2"."sales_seq"
where ("the_date" > '1970-05-16 00:10:04')
Teiid generated SQL:
SELECT g_0.the_date, g_0.store_sales FROM sales_seq g_0 WHERE g_0.the_date >
1970-05-16 00:10:04.0
Exception:
Caused by: java.sql.SQLException: Error while processing statement: FAILED:
ParseException line 1:88 missing EOF at '00' near '16'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira