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

Drill should throw a more meaningful error message when we have json records separated by ',' in a file

    XMLWordPrintableJSON

Details

    Description

      git.commit.id.abbrev=5cd36c5

      Data Set contains records separated by ',':

      {
        "id" : 1
      },
      {
        "id" : 2
      }
      

      Query from Drill :

      select * from `temp.json`;
      Query failed: DATA_READ ERROR: Error parsing JSON. - Unexpected character (',' (code 44)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')
      
      Filename /drill/testdata/complex/json/temp.json
      Record 2
      Column 3
      Fragment 0:0
      
      [9803ff81-7329-4e13-ae7d-b1004502384f on qa-node191.qa.lab:31010]
      Error: exception while executing query: Failure while executing query. (state=,code=0)
      

      We should improve the error message to iindicate that we should not use ',' to separate json records.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated: