Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5141

Difference in output date format on sqlline vs Drill's Web UI

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9.0
    • Fix Version/s: 1.15.0
    • Component/s: Execution - Flow
    • Labels:
      None

      Description

      Difference in output date format on sqlline vs Drill's Web UI
      Drill 1.9.0 git commit ID : 4c1b420b

      From sqlline prompt

      0: jdbc:drill:schema=dfs.tmp> SELECT cast('2016/09/22' as date) FROM (VALUES(1));
      +-------------+
      |   EXPR$0    |
      +-------------+
      | 2016-09-22  |
      +-------------+
      1 row selected (0.474 seconds)
      

      The same query returns a date in a different output format on the web UI

      2016-09-22T00:00:00.000Z
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                khfaraaz Khurram Faraaz
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: