[DRILL-1243] Drill's error message not clear when it fails reading json files containing arrays of hetrogeneous types

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Component/s: Storage - JSON
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 01/Aug/14 23:49
• Updated: 28/Feb/19 06:26
• Resolved: 28/Feb/19 06:26

Description

git.commit.id.abbrev=98b208e

Below is a simple json record which contains arrays holding different types of values

{"coordinates": [168.01,5]}

Query :

select * from `repeated_hetrogeneous_types.json`;

Query failed: Screen received stop request sent. Needed to be in state INIT or IN_BIGINT but in mode IN_FLOAT8

When I tried adding a string to the above json array, the error message from sqlline was even wierder.

Manually debugging this is challenging as we have to nail it down to the specific record which is failing

Issue Links

• supercedes: DRILL-1245 Drill should pinpoint to the "Problem Record" when it fails to parse a json file