You can still use the second way by querying against the list indexes. It will work for your input json file.
Yash On Sun, Aug 10, 2014 at 11:23 AM, Luca Morandini <[email protected]> wrote: > On 10/08/14 15:45, Yash Sharma wrote: > >> Hi Luca, >> the 'features' is a list inside a single json record so is referenced by >> Index. >> >> Having all the features as separate json records will let you query the >> json for >> all locations. >> > > Hmm... I suspected this by looking at other JSON samples used by Drill. > > The trouble with this format is that it is not valid GeoJSON, and, > actually, not even valid JSON. > > How to feed valid JSON in Drill then ? > > Regards, > > > Luca Morandini > Data Architect - AURIN project > Melbourne eResearch Group > Department of Computing and Information Systems > University of Melbourne > Tel. +61 03 903 58 380 > Skype: lmorandini > >
