Member since
10-13-2017
12
Posts
0
Kudos Received
0
Solutions
10-21-2017
09:37 PM
@Shu <?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="myfile.xsl" ?> <bookstore specialty="novel"> <book style="autobiography"> <author>
<first-name>Joe</first-name> <last-name>Bob</last-name>
<award>Trenton Literary Review Honorable Mention</award>
</author>
<price>12</price> </book> </bookstore>
... View more
10-21-2017
09:17 PM
@Shu : I just created output as .txt files for better understanding purpose. But i need to store data in Hive or HDFS location.
... View more
10-21-2017
09:14 PM
@Shu Thank you for response, here are my input file(xml.xml). And i attached my expected output files output-author.txt, output-books.txt, output-bookstore.txt . Hope you will understand my problem.
... View more
10-13-2017
03:41 PM
Hello, I’m very new for nifi and new for programming language. Here are my scenario I’m getting different type of nested XML files from HTTP or SFTP or local drives. I have to split the those XML files based on nested (child elements). Same child elements will have to save in same file and they have some primary key or unique key have to know the relationship of the parent and child. EX: A(root)-> B(Child)-> C (Child of B)-> D(Child of C) A(root)-> B(Child) C (Child of B) D(Child of C) B(Child) C (Child of B) D(Child of C) Now I need all data of B’s have to save in one table and C’s in another table and so on.., And must have to maintain the relationship between the child and parents with some unique key (if you have use otherwise we have to generate the unique keys for identification of relationship between the tables.). Same as the below example: <customer> <group> <site> <userline></userline> <userline></userline> <userline></userline> </site> </group> <group> <site> <userline></userline> <userline></userline> <userline></userline> </site> </group> </customer> I saw already same solution for above in "https://community.hortonworks.com/questions/70087/complex-xml-to-hive-table-using-nifi.html" BUt i didn't understand solution so can someone help me the step by step to split XML for separate files. Thank you in Advance..
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache NiFi