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

Select * from json file failed with java.lang.IllegalArgumentException: null

    XMLWordPrintableJSON

Details

    Description

      git.commit.id.abbrev=201280e

      I have a json file that contains nested data. When I do a "select *" , the query failed as follows:

      0: jdbc:drill:schema=dfs.root> select * from `./json/twitter_43.json`;
      Query failed: Query stopped.[ cc231dec-8d28-4532-a938-c5f67592f262 on qa-node114.qa.lab:31010 ]

      Error: exception while executing query: Failure while executing query. (state=,code=0)

      Also, the following select fails:
      0: jdbc:drill:schema=dfs.root> select SUM(1) as `sum_Number_of_Records_ok` from `./json/twitter_43.json` having (COUNT(1) > 0);
      Query failed: Query failed: 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. [ 364d911a-3bc8-4042-b5a2-6ed074c999ce on qa-node114.qa.lab:31010 ]
      [ 364d911a-3bc8-4042-b5a2-6ed074c999ce on qa-node114.qa.lab:31010 ]

      Attachments

        1. DRILL-1832.4.patch.diff
          312 kB
          Parth Chandra
        2. drill-1832.log
          40 kB
          Krystal
        3. twitter_43.json
          154 kB
          Krystal

        Activity

          People

            parthc Parth Chandra
            knguyen Krystal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: