I've heard and experienced that the array at the root level can cause a problem. Remove square brackets at the root of the object
Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn On Thu, Mar 19, 2015 at 9:49 AM, Andries Engelbrecht < [email protected]> wrote: > See if you can use a prerelease 0.8 (if possible for your environment). > > On Mar 19, 2015, at 9:39 AM, Jim Bates <[email protected]> wrote: > > > mapr-drill-0.7.0.29774-1 > > > > On Thu, Mar 19, 2015 at 11:36 AM, Andries Engelbrecht < > > [email protected]> wrote: > > > >> Which Drill version are you using? > >> > >> —Andries > >> > >> > >> On Mar 19, 2015, at 9:22 AM, Jim Bates <[email protected]> wrote: > >> > >>> I constantly, constantly, constantly hit this. > >>> > >>> I have json files that are just a huge collection of an array of json > >>> objects > >>> > >>> example > >>> "MyArrayInTheFile": > >>> [{"a":"1","b":"2","c":"3"},{"a":"1","b":"2","c":"3"},...] > >>> > >>> My issue is in exploring the data, I hit this. > >>> > >>> Query failed: Query stopped., Record was too large to copy into > vector. [ > >>> 39186288-2e01-408c-b886-dcee0a2c25c5 on maprdemo:31010 ] > >>> > >>> I can explore csv, tab, maprdb, hive at fairly large data sets and > limit > >>> the response to what fits in my system limitations but not json in this > >>> format. > >>> > >>> The two options I have come up with to move forward are.. > >>> > >>> 1. I strip out 90% of the array values in a file and explore that to > >> get > >>> to my view. then go to a larger system and see if I have enough to get > >> the > >>> job done. > >>> 2. Move to the larger system and explore there taking resources that > >>> don't need to be spent on a science project. > >>> > >>> Hoping the smart people have a different option for me, > >>> > >>> Jim > >> > >> > >
