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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3848.
-----------------------------------
    Resolution: Done


Added an explicit cast which is supported by both impala and hive.

> 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)