Member since
09-07-2017
3
Posts
0
Kudos Received
0
Solutions
09-11-2017
02:40 PM
Hi, I tried to implement using ConvertRecord Processor and getting below error: SchemaNotFoundException: Flow File did not contain appropriate attributes to determine Schema Name.
... View more
09-08-2017
08:33 AM
Thanks Everyone, I will try and get back to you if any questions , Thanks Raju & Lim, l will try and let you know both if any questions
... View more
09-07-2017
06:26 PM
I am new to Nifi and exploring Nifi to generate CSV file from a database table and as part of this exercise using 'QueryDatabaseTable' processor to extract data and then converting to JSON flowfile-attribute with the following sequence of processors:
QueryDatabaseTable--> ConvertAvrotoJSON-->EvaluateJSONPath-->AttributestoJSON-->ReplaceText-->PutFile And below is the sample records output claim from the data provenance of 'AttributesToJSON' processor {"Code": "ABC", "Desc": "ABC DESC"}
{"Code": "DEF", "Desc": "DEF DESC"}
{"Code": "XYZ", "Desc": "XYZ DESC"} Target CSV file has to be as follows along with header Code, Desc (Header) ABC,ABC DESC DEF,DEF DESC
XYZ,XYZ DESC Can you help me to configure required properties for "ReplaceText" processor like Search Value, Replacement Value Any processor/inputs/examples on how to generate CSV file output directly from Database table?
... View more
Labels:
- Labels:
-
Apache NiFi