Apache Drill
  1. Apache Drill
  2. DRILL-585

timestamp and time data not showing up correctly in sqlline

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Client - CLI
    • Labels:
      None

      Description

      Executing the following query -
      select first, last, age, sex, salary, registered, cast(join_date as timestamp) TIMEST, cast(join_date as date) DT, cast(join_time as TIME) TM from dfs.`testTypes.json`

      returned the following results in sqlline-
      --------------------------------------------------------------------------------------------

      first last age sex salary registered TIMEST DT TM

      --------------------------------------------------------------------------------------------

      Jimmy James 29 M 6300.1 false 2011-11-30 2011-11-30 00:00:00
      anderson carr null M 6300.1 false null null null
      John James 29 M 6300.1 true 2011-11-30 2011-11-30 00:00:00

      --------------------------------------------------------------------------------------------

      The timestamp column does not have time, and the time column has incorrect values.

      Data file contains the following data -

      { "first": "Jimmy", "last": "James", "age": 29, "sex": "M", "salary": 6300.10, "registered": false, "join_date": "2011-11-30", "join_time": "9:11:10.000" } { "first": "anderson", "last": "carr", "sex": "M", "salary": 6300.10, "registered": false } { "first": "John", "last": "James", "age": 29, "sex": "M", "salary": 6300.10, "registered": true, "join_date": "2011-11-30", "join_time": "8:59:32.000" }
      1. DRILL-585.patch
        6 kB
        Cliff Buchanan

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              DrillCommitter
              Reporter:
              Parth Chandra
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development