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

When json records are separated by a 'COMMA'(which drill does not support), we should throw a proper error

    XMLWordPrintableJSON

Details

    Description

      git.commit.id.abbrev=f1b59ed

      Data :

      {
          "int_col":1
      },
      {
          "int_col":2
      }
      

      The error message from running the below query does not indicate where the problem is. Since some of the publicly found JSON's use a COMMA to separate records, we should throw a proper error message

      select count(*) from `temp.json`;
      +------------+
      |   EXPR$0   |
      +------------+
      Query failed: RemoteRpcException: Failure while running fragment., You tried to do a batch data read operation when you were in a state of STOP.  You can only do this type of operation when you are in a state of OK or OK_NEW_SCHEMA. [ 1541e79c-6570-416c-8ab5-e5922bdc0599 on qa-node190.qa.lab:31010 ]
      [ 1541e79c-6570-416c-8ab5-e5922bdc0599 on qa-node190.qa.lab:31010 ]
      
      
      java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
      	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
      	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
      	at sqlline.SqlLine.print(SqlLine.java:1809)
      	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
      	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
      	at sqlline.SqlLine.dispatch(SqlLine.java:889)
      	at sqlline.SqlLine.begin(SqlLine.java:763)
      	at sqlline.SqlLine.start(SqlLine.java:498)
      	at sqlline.SqlLine.main(SqlLine.java:460)
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: