[teiid-issues] [JBoss JIRA] (TEIID-2814) HIVE: quote is removed for TIMESTAMP field in where clause

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2814:
---------------------------------------

Ivan,

If you are still having issues with timestamp comparison after 0.13, please open up a new issue and we'll figure out what translator changes would be needed.

> 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 was sent by Atlassian JIRA
(v6.2.3#6260)