Hi Rob This is very weird ! Is that the entire JSON? I'm wondering if the JSON document by any chance has a different end-of-line character that *might* be causing this. Windows uses CarriageReturn+LineFeed, while Linux (HDFS) has only Linefeed and MacOS using CarriageReturn.
Linux has a dos2unix util that you could run on that file and try again. In the meanwhile, if you can share a test document along with a stack trace (if any), that would be really helpful to debug this issue. ~ Kunal On 3/12/2019 12:34:11 PM, Robert Vantol <[email protected]> wrote: This is our Json, as you see the imp node is an array of other json: { "id":"21D66BC4F2BA7E24", "imp":[ { "id":"1", "banner":{ "w":160, "h":600, "pos":1, "topframe":1 }, "sessiondepth":22 } ], "site":{ "id":"288491", "cat":[ "IAB5" ], "page":"http://www.history101.com/discovered-photo-album-reveals-the-real-reason-why-the-titanic-sank/19/ [http://www.history101.com/discovered-photo-album-reveals-the-real-reason-why-the-titanic-sank/19/]";, "ref":"http://www.history101.com/discovered-photo-album-reveals-the-real-reason-why-the-titanic-sank/18/ [http://www.history101.com/discovered-photo-album-reveals-the-real-reason-why-the-titanic-sank/18/]";, "publisher":{ "id":"184621" }, "content":{ "keywords":"2" } } When we drill locally on a windows machine with the json sitting on the file system using: Select t.id [http://t.id], t.imp[0].banner.w, t.imp[0].banner.h from rv.`bid.json` t; It returns the information correctly. When we take that same json and place it on our HDF the imp node is returned as null we are able to pull out other nodes, and even the other Simple array (site.cat [http://site.cat][0]), just not the imp node. We have tried to flatten it and have tried: ALTER SESSION SET `store.json.all_text_mode` = true; But nothing is working. We are using newly downloaded Drill 1.15 Is there any help you can give me? I am at a loss… Rob [sm_eq_works_logo] Robert VanTol Digital Consultant & Information Architect [email protected] [mailto:[email protected]] | T 416 260 4759 1235 Bay Street, Suite 401, Toronto ON, M5R 2A9 EQ Digital | www.EQworks.com [http://www.eqworks.com/] Follow us: [cid:[email protected]] [https://twitter.com/eqworkscorp] [cid:[email protected]] [https://www.facebook.com/eqworkscorp] [cid:[email protected]] [https://www.linkedin.com/company/3202191?trk=tyah]
