[DRILL-1594] SQL exception when querying JSON

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.7.0
• Assignee: Hanifi Gunes
• Reporter: Neeraja
• Created: 28/Oct/14 18:27
• Updated: 09/Dec/14 17:47
• Resolved: 08/Nov/14 00:25

Description

I can reproduce this with many queries, but narrowing down, it may actually have to do with the number of rows that are being retrieved or a specific record.
I tried a query as follows (i.e limit 10034). It returns 10033 rows and then fails with an exception. A modified limit 10033 does succeed.

select * from dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json` b limit 10034;
-------------------
java.lang.RuntimeException: java.sql.SQLException: Failure while trying to get next result batch.
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)

I enabled text mode using alter system set `store.json.all_text_mode`=true;
The same error occurs with this configuration as well.

Here is another example where it fails.
select * from dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json` b where review_count > 1000;

Issue Links

• duplicates: DRILL-1602 Enhance Drill to support Heterogeneous fields
• is duplicated by: DRILL-1731 Exception in a query on Yelp business data