[teiid-issues] [JBoss JIRA] (TEIID-3848) Issue with hive literal timestamps

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3848:
-------------------------------------

             Summary: Issue with hive literal timestamps
                 Key: TEIID-3848
                 URL: https://issues.jboss.org/browse/TEIID-3848
             Project: Teiid
          Issue Type: Bug
          Components: Misc. Connectors
    Affects Versions: 8.11
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 8.13, 8.12.3


With testing TEIID-3847 Hive 1.2.1 failed to compare appropriately with a timestamp string literal in the source sql containing .0 fractional seconds:

t = '2000-01-01 12:00:00.0' -- did not work
But the following does
t = '2000-01-01 12:00:00' 
t = cast('2000-01-01 12:00:00.0' as timestamp)



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)