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

toString of JDBC object return type should do smarter JSON encoding

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • Future
    • Client - CLI
    • None

    Description

      git.commit.id.abbrev=f240ac2

      Data :

      {
        "int_col" : {"$numberLong": 1},
        "date_col" : {"$dateDay": "2012-05-22"},
        "time_col"  : {"$time": "19:20:30.45Z"},
        "date_array" : [{"$dateDay" : "2012-08-01"}, {"$dateDay" : "2033-11-28"}],
        "time_array" : [{"$time": "19:20:30.45Z"}, {"$time": "11:25:01.45Z"}],
        "int_array" : [{"$numberLong": 1}, {"$numberLong": 2}, {"$numberLong": 3}]
      }
      

      Query :

      0: jdbc:drill:schema=dfs_eea> select time_array, date_array from `data1.json`;
      +------------+------------+
      | time_array | date_array |
      +------------+------------+
      | [{"dayOfMonth":1,"dayOfWeek":4,"era":1,"year":1970,"dayOfYear":1,"centuryOfEra":19,"millisOfSecond":450,"millisOfDay":69630450,"secondOfMinute":30,"secondOfDay":69630,"minuteOfHour":20,"minuteOfDay":1160,"hourOfDay":19,"weekOfWeekyear":1,"weekyear":1970,"monthOfYear":1,"yearOfEra":1970,"yearOfCentury":70,"zone":{"fixed":true,"id":"UTC"},"millis":69630450,"chronology":{"zone":{"fixed":true,"id":"UTC"}},"afterNow":false,"equalNow":false,"beforeNow":true},{"dayOfMonth":1,"dayOfWeek":4,"era":1,"year":1970,"dayOfYear":1,"centuryOfEra":19,"millisOfSecond":450,"millisOfDay":41101450,"secondOfMinute":1,"secondOfDay":41101,"minuteOfHour":25,"minuteOfDay":685,"hourOfDay":11,"weekOfWeekyear":1,"weekyear":1970,"monthOfYear":1,"yearOfEra":1970,"yearOfCentury":70,"zone":{"fixed":true,"id":"UTC"},"millis":41101450,"chronology":{"zone":{"fixed":true,"id":"UTC"}},"afterNow":false,"equalNow":false,"beforeNow":true}] | [{"dayOfMonth":1,"dayOfWeek":3,"era":1,"year":2012,"dayOfYear":214,"centuryOfEra":20,"millisOfSecond":0,"millisOfDay":0,"secondOfMinute":0,"secondOfDay":0,"minuteOfHour":0,"minuteOfDay":0,"hourOfDay":0,"weekOfWeekyear":31,"weekyear":2012,"monthOfYear":8,"yearOfEra":2012,"yearOfCentury":12,"zone":{"fixed":true,"id":"UTC"},"millis":1343779200000,"chronology":{"zone":{"fixed":true,"id":"UTC"}},"afterNow":false,"equalNow":false,"beforeNow":true},{"dayOfMonth":28,"dayOfWeek":1,"era":1,"year":2033,"dayOfYear":332,"centuryOfEra":20,"millisOfSecond":0,"millisOfDay":0,"secondOfMinute":0,"secondOfDay":0,"minuteOfHour":0,"minuteOfDay":0,"hourOfDay":0,"weekOfWeekyear":48,"weekyear":2033,"monthOfYear":11,"yearOfEra":2033,"yearOfCentury":33,"zone":{"fixed":true,"id":"UTC"},"millis":2016748800000,"chronology":{"zone":{"fixed":true,"id":"UTC"}},"afterNow":true,"equalNow":false,"beforeNow":false}] |
      

      Drill could be serializing the whole date object here. Marked it as critical since we are reporting wrong data. Let me know if you have any questions.

      Attachments

        Activity

          People

            Unassigned Unassigned
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: