[ https://issues.apache.org/jira/browse/SPARK-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Armbrust resolved SPARK-3173. ------------------------------------- Resolution: Fixed Fix Version/s: 1.1.1 > 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 > Fix For: 1.1.1 > > > 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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org