[teiid-issues] [JBoss JIRA] (TEIID-3848) Issue with hive literal timestamps
Steven Hawkins (JIRA)
issues at jboss.org
Mon Jun 6 10:32:01 EDT 2016
[ https://issues.jboss.org/browse/TEIID-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-3848.
---------------------------------
> 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.12.3, 8.13
>
>
> 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)
More information about the teiid-issues
mailing list