[DRILL-1245] Drill should pinpoint to the "Problem Record" when it fails to parse a json file

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Storage - JSON
• Assignee: Abdel Hakim Deneche
• Reporter: Rahul Kumar Challapalli
• Due: 11/Aug/14
• Created: 02/Aug/14 00:51
• Updated: 20/Apr/15 15:44
• Resolved: 20/Apr/15 15:44

Description

git.commit.id.abbrev=98b208e

Data :

{"name":"name1", "id":1}
{"name":"name2", "id":2}
{"name":"name3", "id":3}
{"name":"name4", "id":04}
{"name":"name5", "id":5}

Query :

 select * from cp.`file.json`;
Query failed: Screen received stop request sent. Invalid numeric value: Leading zeroes not allowed
 at [Source: java.io.BufferedReader@202fbdb4; line: 1, column: 24] [c11a17bd-1a3a-4eed-a848-6d79225399d3]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)

The msg should point to the exact record which is causing the problem as it will be hard looking into the data and finding out the problem record.

Issue Links

• is related to: DRILL-2430 Improve Error Propagation (Umbrella)
• is superceded by: DRILL-1243 Drill's error message not clear when it fails reading json files containing arrays of hetrogeneous types