Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Nifi Substring : index out of bounds error

Hi There,

I was looking into nifi examples and I am getting the below error.

I am trying to split this date

20181119112100

I am getting my expected results. Not sure why I am getting the error and warning.

93312-2018-11-20-08-04-13-nif1i.png

93313-2018-11-20-08-30-08-nif2i.png

1 REPLY 1

Super Guru
@Jacob Paul

I believe your flowfiles having source-date1 attribute with value 20181119112100.

Then change your update attribute property values as

source-date as

${source-date1:substring(0,8)}

source-time as

${source-date1:substring(8,13)}

Then update attribute adds these flowfile attributes for all outgoing flowfiles from UpdateAttribute processor.

In addition you can also perform same kind of operation without extracting as attributes using QueryRecord processor.

Configure/Enable Record Reader/Writer controller services and use apache-calcite's Substring function to create source-date,source-time columns in the flowfile.