Cloudera Community
tulasi_harishku
user rank
Frequent Visitor

Re: create hive table from nested json file in NIF...

by Frequent Visitor in Support Questions
‎05-10-2018 06:03 PM
‎05-10-2018 06:03 PM
@Matt Burgess ... View more

create hive table from nested json file in NIFI

by Frequent Visitor in Support Questions
‎05-10-2018 05:50 PM
‎05-10-2018 05:50 PM
I have a very complex nested JSON file, with atleast six level of nested at some sections. I am trying to load the nested JSON to HIVE table. Could anyone please help me how to do it??? My approaches: 1. Flatten the nested JSON file and load it(wasn't sure what processors to use in NIFI-trying to use JOLT but I am pretty new to it) 2. Load directly the JSON file to HIVE(without flattening) Attached sample JSON file nestedjson.txt ... View more
Labels:

Re: ​NiFi XML to JSON shredding: A generalised sol...

by Frequent Visitor in Community Articles
‎05-08-2018 02:32 PM
‎05-08-2018 02:32 PM
Hi Dan, I am still having trouble creating a HIve table using nested XML file. Coul you please help me. I did include XLST in the XLST tranformation but still unable to load the data.I am having issues with shredding data too Thanks, Harish ... View more
Contact Me
Online
Offline
Last Visited
‎05-17-2022 10:44 AM
Community Statistics
Member Since ‎05-08-2018 01:36 PM
Last Visited ‎05-17-2022 10:44 AM
Posts 4