Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-9087

Broken SQL on where condition involving timestamp and time string.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.4.0
    • 1.4.1
    • SQL

    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'

      Attachments

        Activity

          People

            marmbrus Michael Armbrust
            zwu.net@gmail.com Paul Wu
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: