From the course: Data Management with Apache NiFi
Unlock this course with a free trial
Join today to access over 24,400 courses taught by industry experts.
Configuring the ReplaceText processor - Apache NiFi Tutorial
From the course: Data Management with Apache NiFi
Configuring the ReplaceText processor
- [Instructor] Before we write out the data to our database table, we need to replace the NA values with empty strings. And we'll do this with a separate processor. So I've gotten rid of the connection between GetFile and PutDatabaseRecord. Let's add a new processor, and this processor is called ReplaceText. ReplaceText will allow you to replace the text within the content of your flow file with some other text of your choosing. Let's add this processor and make it part of our dataflow. I'm going to connect the output of GetFile to ReplaceText. So on success, GetFile will send the flow file to ReplaceText, where we'll replace the NA values that exist in our numeric column. Double-click on ReplaceText to bring up the dialogue to configure this processor. First, Scheduling. Now, you can have this run each time a flow file is available, but I'm only going to run ReplaceText every 20 seconds. So we'll pause a bit before…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Set up a PostgreSQL table3m 11s
-
(Locked)
Add GetFile and PutDatabase processors3m 23s
-
(Locked)
Configuring the CSVReader controller service3m 46s
-
(Locked)
Configuring the DBConnectionPool controller service4m 26s
-
(Locked)
Running and encountering dataflow errors2m 47s
-
(Locked)
Configuring the ReplaceText processor2m 58s
-
(Locked)
Running a dataflow to insert data into PostgreSQL2m 35s
-
(Locked)
Configuring the Run schedule3m 14s
-
(Locked)
Configuring task concurrency2m 58s
-
(Locked)
Configure processors to execute SQL queries4m 25s
-
-
-
-
-