Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Proper use of nifi-csv-bundle

Proper use of nifi-csv-bundle

New Contributor

I have downloaded @Andrew Grande's nifi-csv-bundle and had a few questions about its use. Can someone explain the relationship between the attributes "Record Source From Attribute", "Input Schema Attribute Prefix", and "Output Attribute Prefix" along with their proper use? I am parsing individual CSV lines that aren't being sent with a header, but they're in a fixed-order which I'd like to map to individual attribute names corresponding to SQL column names.

I was also wondering if all attributes are cast as strings by default? I want the attributes to correspond to their respective mysql datatype for when I prepare the INSERT statement. Does the ParseCSVRecord processor support Nifi expression language? If so I could coerce the input to its proper datatype.