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

timestamp and time data not showing up correctly in sqlline

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: 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

          Hide
          jnadeau Jacques Nadeau added a comment -

          merged on or before f86639c

          Show
          jnadeau Jacques Nadeau added a comment - merged on or before f86639c
          Hide
          mehant Mehant Baid added a comment -

          Changes look good.

          Show
          mehant Mehant Baid added a comment - Changes look good.
          Hide
          cbuchanan 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
          cbuchanan 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/

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development