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

Broken SQL on where condition involving timestamp and time string.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.4.1
    • Component/s: SQL
    • Labels:

      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

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

              Dates

              • Created:
                Updated:
                Resolved: