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.

NiFi: CSVRecordLookupService - Mapping Not Found

NiFi: CSVRecordLookupService - Mapping Not Found

Explorer

If you have ideas for me on how to solve this problem, thanks in  advance - johndcal.

 

I am using a NiFi flow to create single flowfile from two input files. This flow involves the LookupRecord processor, which requires several controller services.  The controller service that is failing is CSVRecordLookupService - it cannot establish the [very simple] mapping; the error reported is below:

johndcal_0-1589912802028.png

 

The first file is a file of ML baseball players - the second column is Loc_ID, which is a 3-letter code for the team's city.  The second file contains the Loc_ID (city) and associated state name.  The first file does not contain the name of the state - the goal is to perform the lookup and create an output flowfile that contains the name of the state.

 

The file schemas and CSVRecordLookupService controller service configuration are shown below.  Samples of the top of the input files, and the process flow, are shown at the bottom of this message.

 

  • baseball player input file schema:

johndcal_1-1589912802034.png

 

  • output file schema (state field added):

johndcal_2-1589912802040.png

 

  • How CSVRecordLookupService is configured:

johndcal_3-1589912802044.png

  • Baseball player input file:

johndcal_4-1589912998083.png

  • [State] lookup file:

johndcal_5-1589913052226.png

  • Process flow:

johndcal_6-1589913123706.png

 

 

Don't have an account?
Coming from Hortonworks? Activate your account here