drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aman Sinha <asi...@maprtech.com>
Subject Re: Validate your JSON files
Date Mon, 24 Nov 2014 22:57:05 GMT
BTW, there's a web based validator called jsonlint.com whose source is
available at :  https://github.com/arc90/jsonlintdotcom

On Mon, Nov 24, 2014 at 2:07 PM, Christopher Matta <cmatta@mapr.com> wrote:

> I’ve been running across errors in Drill when a JSON record is invalid. To
> reduce the number of these errors, I wrote this small, simple application
> that will open a specified file, check if each line is a valid JSON record,
> and error if it’s not:
>
> https://github.com/cjmatta/jsonr
>
> Usage:
>
> [cmatta@ip-172-16-1-173 jsonar]$ ./jsonar -f
> ../tweets/2014/11/24/21/tweets.json
> Checking for valid JSON in ../tweets/2014/11/24/21/tweets.json
> CWARNING:root:JSON load error on line 16640 of
> ../tweets/2014/11/24/21/tweets.json
> WARNING:root:JSON load error on line 16641 of
> ../tweets/2014/11/24/21/tweets.json
> WARNING:root:JSON load error on line 16642 of
> ../tweets/2014/11/24/21/tweets.json
> Checking line 17000
> Done.
>
> Please check it out, use it, contribute back if there’s something broken or
> missing.
>
> Chris Matta
> cmatta@mapr.com
> 215-701-3146
> ​
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message