[SPARK-9087] Broken SQL on where condition involving timestamp and time string.

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.4.1
• Component/s: SQL
• Labels: sparksql
• Assignee: Michael Armbrust
• Reporter: Paul Wu
• Created: 15/Jul/15 23:47
• Updated: 16/Jul/15 22:26
• Resolved: 16/Jul/15 22:09

Description

Suppose mytable has a field called greenwich, which is in timestamp type. The table is registered through a java bean. The following code used to work in 1.3 and 1.3.1, now it is broken: there are records having time newer 01/14/2015 , but it now returns nothing. This is a block issue for us. Is there any workaround?

SELECT * FROM mytable WHERE greenwich > '2015-01-14'