Zdenek Farana created SPARK-3173:
------------------------------------
Summary: Timestamp support in the parser
Key: SPARK-3173
URL: https://issues.apache.org/jira/browse/SPARK-3173
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.0.2, 1.1.0
Reporter: Zdenek Farana
If you have a table with TIMESTAMP column, that column can't be used in WHERE
clause properly - it is not evaluated properly.
F.e., SELECT * FROM a WHERE timestamp='2014-08-21 00:00:00.0', would return
nothing even if there would be a row with such a timestamp. The literal is not
interpreted into a timestamp.
The workaround SELECT * FROM a WHERE timestamp=CAST('2014-08-21 00:00:00.0' AS
TIMESTAMP) fails, because the parser does not allow anything but STRING in the
CAST dataType expression.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
