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

Query against yelp academic dataset causes exception - improve error message

    XMLWordPrintableJSON

Details

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

    Description

      I was following along the tutorial for "Analyzing the Yelp Academic Dataset."
      I tried the first query "Querying Yelp Business Data" WITHOUT the limit clause:
      select * from
      dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json`;

      (Adjust for your own download path).

      A bunch of data comes out, followed by an exception:
      "Dietary Restrictions":{}} | business | null |
      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)
      0: jdbc:drill:zk=local>

      Note that this was tried against the 0.9.0 tarball referred to in the tutorials and download links.

      Attachments

        Activity

          People

            Unassigned Unassigned
            cwestin Chris Westin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: