[DRILL-2817] Drill should throw a more meaningful error message when we have json records separated by ',' in a file

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Storage - JSON
• Labels: error_message_must_fix
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 18/Apr/15 00:00
• Updated: 01/Oct/15 16:37

Description

git.commit.id.abbrev=5cd36c5

Data Set contains records separated by ',':

{
  "id" : 1
},
{
  "id" : 2
}

Query from Drill :

select * from `temp.json`;
Query failed: DATA_READ ERROR: Error parsing JSON. - Unexpected character (',' (code 44)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')

Filename /drill/testdata/complex/json/temp.json
Record 2
Column 3
Fragment 0:0

[9803ff81-7329-4e13-ae7d-b1004502384f on qa-node191.qa.lab:31010]
Error: exception while executing query: Failure while executing query. (state=,code=0)

We should improve the error message to iindicate that we should not use ',' to separate json records.