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

          Parth Chandra created issue -
          Jake Farrell made changes -
          Field Original Value New Value
          Workflow no-reopen-closed, patch-avail [ 12858643 ] no-reopen-closed, patch-avail, testing [ 12860109 ]
          Jacques Nadeau made changes -
          Component/s Client - CLI [ 12322933 ]
          Jacques Nadeau made changes -
          Link This issue is duplicated by DRILL-857 [ DRILL-857 ]
          Jacques Nadeau made changes -
          Fix Version/s 1.0.0-BETA1 [ 12324963 ]
          Cliff Buchanan made changes -
          Assignee Cliff Buchanan [ cbuchanan ]
          Hide
          Cliff Buchanan added a comment - - edited

          Patched to the JDBC interface to make getObject and getString more compatible with the JDBC spec (see appendix B), and JDBC javadoc.

          https://reviews.apache.org/r/22475/

          Show
          Cliff Buchanan added a comment - - edited Patched to the JDBC interface to make getObject and getString more compatible with the JDBC spec (see appendix B), and JDBC javadoc . https://reviews.apache.org/r/22475/
          Cliff Buchanan made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Cliff Buchanan made changes -
          Attachment DRILL-585.patch [ 12649867 ]
          Cliff Buchanan made changes -
          Assignee Cliff Buchanan [ cbuchanan ] DrillCommitter [ drillcommitter ]
          Cliff Buchanan made changes -
          Assignee DrillCommitter [ drillcommitter ] Cliff Buchanan [ cbuchanan ]
          Cliff Buchanan made changes -
          Assignee Cliff Buchanan [ cbuchanan ] Mehant Baid [ mehant ]
          Mehant Baid made changes -
          Assignee Mehant Baid [ mehant ] DrillCommitter [ drillcommitter ]
          Hide
          Mehant Baid added a comment -

          Changes look good.

          Show
          Mehant Baid added a comment - Changes look good.
          Jacques Nadeau made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Hide
          Jacques Nadeau added a comment -

          merged on or before f86639c

          Show
          Jacques Nadeau added a comment - merged on or before f86639c

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development