[ https://issues.apache.org/jira/browse/DRILL-1245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Deneche A. Hakim closed DRILL-1245. ----------------------------------- Resolution: Fixed This was fixed by DRILL-2675. The same query now returns the following error message: {noformat} 0: jdbc:drill:zk=local> select * from dfs.tmp.`t.json`; Query failed: DATA_READ ERROR: Error parsing JSON. - Invalid numeric value: Leading zeroes not allowed Filename /tmp/t.json Record 4 Column 24 Fragment 0:0 [245cba11-e428-4cbf-9d3b-6ca165b864bc on abdel-11.qa.lab:31010] Error: exception while executing query: Failure while executing query. (state=,code=0) {noformat} > Drill should pinpoint to the "Problem Record" when it fails to parse a json > file > -------------------------------------------------------------------------------- > > Key: DRILL-1245 > URL: https://issues.apache.org/jira/browse/DRILL-1245 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON > Reporter: Rahul Challapalli > Assignee: Deneche A. Hakim > Fix For: 1.0.0 > > Attachments: DRILL-1245.1.patch.txt > > > git.commit.id.abbrev=98b208e > Data : > {code} > {"name":"name1", "id":1} > {"name":"name2", "id":2} > {"name":"name3", "id":3} > {"name":"name4", "id":04} > {"name":"name5", "id":5} > {code} > Query : > {code} > 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) > {code} > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)