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)