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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org