Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" ?>
- <template encoding-version="1.0">
- <description>This template illustrates how to populate a DistributedCacheMapServer with values from a RDBMS, and how to use those values as a lookup for incoming flow files.</description>
- <groupId>f962a447-0158-1000-3c38-bc764f9c916d</groupId>
- <name>DatabaseLookupExample</name>
- <snippet>
- <processGroups>
- <id>fe2190e7-0158-1000-0000-000000000000</id>
- <parentGroupId>f962a447-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>0.0</x>
- <y>0.0</y>
- </position>
- <comments></comments>
- <contents>
- <connections>
- <id>fe21cb64-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2190e7-0158-1000-0000-000000000000</groupId>
- <id>fe21cb60-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>fe2190e7-0158-1000-0000-000000000000</groupId>
- <id>fe21cb5f-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>fe21cb65-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2190e7-0158-1000-0000-000000000000</groupId>
- <id>fe21cb62-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>fe2190e7-0158-1000-0000-000000000000</groupId>
- <id>fe21cb60-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>fe21cb66-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2190e7-0158-1000-0000-000000000000</groupId>
- <id>fe21cb63-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>matched</selectedRelationships>
- <source>
- <groupId>fe2190e7-0158-1000-0000-000000000000</groupId>
- <id>fe21cb62-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>fe21cb67-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2190e7-0158-1000-0000-000000000000</groupId>
- <id>fe21cb61-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>fe2190e7-0158-1000-0000-000000000000</groupId>
- <id>fe21cb63-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <controllerServices>
- <id>b28b426b-0156-1000-0000-000000000000</id>
- <parentGroupId>f962a447-0158-1000-0000-000000000000</parentGroupId>
- <comments></comments>
- <descriptors>
- <entry>
- <key>Database Connection URL</key>
- <value>
- <name>Database Connection URL</name>
- </value>
- </entry>
- <entry>
- <key>Database Driver Class Name</key>
- <value>
- <name>Database Driver Class Name</name>
- </value>
- </entry>
- <entry>
- <key>database-driver-locations</key>
- <value>
- <name>database-driver-locations</name>
- </value>
- </entry>
- <entry>
- <key>Database User</key>
- <value>
- <name>Database User</name>
- </value>
- </entry>
- <entry>
- <key>Password</key>
- <value>
- <name>Password</name>
- </value>
- </entry>
- <entry>
- <key>Max Wait Time</key>
- <value>
- <name>Max Wait Time</name>
- </value>
- </entry>
- <entry>
- <key>Max Total Connections</key>
- <value>
- <name>Max Total Connections</name>
- </value>
- </entry>
- <entry>
- <key>Validation-query</key>
- <value>
- <name>Validation-query</name>
- </value>
- </entry>
- </descriptors>
- <name>MySQLConnectionPool</name>
- <properties>
- <entry>
- <key>Database Connection URL</key>
- <value>jdbc:mysql://192.168.99.100:32768/test_schema</value>
- </entry>
- <entry>
- <key>Database Driver Class Name</key>
- <value>com.mysql.jdbc.Driver</value>
- </entry>
- <entry>
- <key>database-driver-locations</key>
- <value>file:///Users/mburgess/jdbc_drivers/mysql-connector-java-5.1.38-bin.jar</value>
- </entry>
- <entry>
- <key>Database User</key>
- <value>root</value>
- </entry>
- <entry>
- <key>Password</key>
- </entry>
- <entry>
- <key>Max Wait Time</key>
- <value>500 millis</value>
- </entry>
- <entry>
- <key>Max Total Connections</key>
- <value>8</value>
- </entry>
- <entry>
- <key>Validation-query</key>
- </entry>
- </properties>
- <state>ENABLED</state>
- <type>org.apache.nifi.dbcp.DBCPConnectionPool</type>
- </controllerServices>
- <processors>
- <id>fe21cb5f-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>1731.002685546875</x>
- <y>-155.8504867553711</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Database Connection Pooling Service</key>
- <value>
- <identifiesControllerService>org.apache.nifi.dbcp.DBCPService</identifiesControllerService>
- <name>Database Connection Pooling Service</name>
- </value>
- </entry>
- <entry>
- <key>db-fetch-db-type</key>
- <value>
- <name>db-fetch-db-type</name>
- </value>
- </entry>
- <entry>
- <key>Table Name</key>
- <value>
- <name>Table Name</name>
- </value>
- </entry>
- <entry>
- <key>Columns to Return</key>
- <value>
- <name>Columns to Return</name>
- </value>
- </entry>
- <entry>
- <key>Maximum-value Columns</key>
- <value>
- <name>Maximum-value Columns</name>
- </value>
- </entry>
- <entry>
- <key>Max Wait Time</key>
- <value>
- <name>Max Wait Time</name>
- </value>
- </entry>
- <entry>
- <key>Fetch Size</key>
- <value>
- <name>Fetch Size</name>
- </value>
- </entry>
- <entry>
- <key>qdbt-max-rows</key>
- <value>
- <name>qdbt-max-rows</name>
- </value>
- </entry>
- <entry>
- <key>qdbt-max-frags</key>
- <value>
- <name>qdbt-max-frags</name>
- </value>
- </entry>
- <entry>
- <key>dbf-normalize</key>
- <value>
- <name>dbf-normalize</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Database Connection Pooling Service</key>
- <value>b28b426b-0156-1000-0000-000000000000</value>
- </entry>
- <entry>
- <key>db-fetch-db-type</key>
- <value>Generic</value>
- </entry>
- <entry>
- <key>Table Name</key>
- <value>lkup</value>
- </entry>
- <entry>
- <key>Columns to Return</key>
- </entry>
- <entry>
- <key>Maximum-value Columns</key>
- <value>id</value>
- </entry>
- <entry>
- <key>Max Wait Time</key>
- <value>0 seconds</value>
- </entry>
- <entry>
- <key>Fetch Size</key>
- <value>0</value>
- </entry>
- <entry>
- <key>qdbt-max-rows</key>
- <value>1</value>
- </entry>
- <entry>
- <key>qdbt-max-frags</key>
- <value>3</value>
- </entry>
- <entry>
- <key>dbf-normalize</key>
- <value>false</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>Get Lookup Map from DB</name>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.QueryDatabaseTable</type>
- </processors>
- <processors>
- <id>fe21cb60-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>1734.012939453125</x>
- <y>50.266109466552734</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>JSON container options</key>
- <value>
- <name>JSON container options</name>
- </value>
- </entry>
- <entry>
- <key>Wrap Single Record</key>
- <value>
- <name>Wrap Single Record</name>
- </value>
- </entry>
- <entry>
- <key>Avro schema</key>
- <value>
- <name>Avro schema</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>JSON container options</key>
- <value>array</value>
- </entry>
- <entry>
- <key>Wrap Single Record</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Avro schema</key>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>ConvertAvroToJSON</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.avro.ConvertAvroToJSON</type>
- </processors>
- <processors>
- <id>fe21cb61-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>1736.5260015634326</x>
- <y>679.4686746536038</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Cache Entry Identifier</key>
- <value>
- <name>Cache Entry Identifier</name>
- </value>
- </entry>
- <entry>
- <key>Distributed Cache Service</key>
- <value>
- <identifiesControllerService>org.apache.nifi.distributed.cache.client.DistributedMapCacheClient</identifiesControllerService>
- <name>Distributed Cache Service</name>
- </value>
- </entry>
- <entry>
- <key>Cache update strategy</key>
- <value>
- <name>Cache update strategy</name>
- </value>
- </entry>
- <entry>
- <key>Max cache entry size</key>
- <value>
- <name>Max cache entry size</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Cache Entry Identifier</key>
- <value>${custId}</value>
- </entry>
- <entry>
- <key>Distributed Cache Service</key>
- <value>fe19347d-0158-1000-0000-000000000000</value>
- </entry>
- <entry>
- <key>Cache update strategy</key>
- <value>replace</value>
- </entry>
- <entry>
- <key>Max cache entry size</key>
- <value>10 MB</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>Populate Lookup Map</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.PutDistributedMapCache</type>
- </processors>
- <processors>
- <id>fe21cb62-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>1738.5345464853076</x>
- <y>252.72290816954836</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Destination</key>
- <value>
- <name>Destination</name>
- </value>
- </entry>
- <entry>
- <key>Return Type</key>
- <value>
- <name>Return Type</name>
- </value>
- </entry>
- <entry>
- <key>Path Not Found Behavior</key>
- <value>
- <name>Path Not Found Behavior</name>
- </value>
- </entry>
- <entry>
- <key>Null Value Representation</key>
- <value>
- <name>Null Value Representation</name>
- </value>
- </entry>
- <entry>
- <key>custId</key>
- <value>
- <name>custId</name>
- </value>
- </entry>
- <entry>
- <key>custName</key>
- <value>
- <name>custName</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Destination</key>
- <value>flowfile-attribute</value>
- </entry>
- <entry>
- <key>Return Type</key>
- <value>auto-detect</value>
- </entry>
- <entry>
- <key>Path Not Found Behavior</key>
- <value>ignore</value>
- </entry>
- <entry>
- <key>Null Value Representation</key>
- <value>empty string</value>
- </entry>
- <entry>
- <key>custId</key>
- <value>$.id</value>
- </entry>
- <entry>
- <key>custName</key>
- <value>$.customer_name</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>EvaluateJsonPath</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>matched</name>
- </relationships>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>unmatched</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.EvaluateJsonPath</type>
- </processors>
- <processors>
- <id>fe21cb63-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2190e7-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>1735.5455375859901</x>
- <y>461.11377038272553</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Regular Expression</key>
- <value>
- <name>Regular Expression</name>
- </value>
- </entry>
- <entry>
- <key>Replacement Value</key>
- <value>
- <name>Replacement Value</name>
- </value>
- </entry>
- <entry>
- <key>Character Set</key>
- <value>
- <name>Character Set</name>
- </value>
- </entry>
- <entry>
- <key>Maximum Buffer Size</key>
- <value>
- <name>Maximum Buffer Size</name>
- </value>
- </entry>
- <entry>
- <key>Replacement Strategy</key>
- <value>
- <name>Replacement Strategy</name>
- </value>
- </entry>
- <entry>
- <key>Evaluation Mode</key>
- <value>
- <name>Evaluation Mode</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Regular Expression</key>
- <value>(?s)(^.*$)</value>
- </entry>
- <entry>
- <key>Replacement Value</key>
- <value>${custName}</value>
- </entry>
- <entry>
- <key>Character Set</key>
- <value>UTF-8</value>
- </entry>
- <entry>
- <key>Maximum Buffer Size</key>
- <value>1 MB</value>
- </entry>
- <entry>
- <key>Replacement Strategy</key>
- <value>Regex Replace</value>
- </entry>
- <entry>
- <key>Evaluation Mode</key>
- <value>Entire text</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>Set Content to Lookup Value</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.ReplaceText</type>
- </processors>
- </contents>
- <name>PopulateLookupTable</name>
- </processGroups>
- <processGroups>
- <id>fe2247bc-0158-1000-0000-000000000000</id>
- <parentGroupId>f962a447-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>1.9945005241725084</x>
- <y>250.30507115895284</y>
- </position>
- <comments></comments>
- <contents>
- <connections>
- <id>fe22bb7d-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe22abc3-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe228354-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>fe230399-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe22f0ea-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>splits</selectedRelationships>
- <source>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe22abc3-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>fe253eaf-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe24b83a-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>matched</selectedRelationships>
- <source>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe22f0ea-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>fe258ea7-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe256e71-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe24b83a-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>fe28af4d-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe28a0c5-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe256e71-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>fe2fe4d3-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe228354-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>fe2247bc-0158-1000-0000-000000000000</groupId>
- <id>fe227563-0158-1000-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <controllerServices>
- <id>fe19347d-0158-1000-0000-000000000000</id>
- <parentGroupId>f962a447-0158-1000-0000-000000000000</parentGroupId>
- <comments></comments>
- <descriptors>
- <entry>
- <key>Server Hostname</key>
- <value>
- <name>Server Hostname</name>
- </value>
- </entry>
- <entry>
- <key>Server Port</key>
- <value>
- <name>Server Port</name>
- </value>
- </entry>
- <entry>
- <key>SSL Context Service</key>
- <value>
- <identifiesControllerService>org.apache.nifi.ssl.SSLContextService</identifiesControllerService>
- <name>SSL Context Service</name>
- </value>
- </entry>
- <entry>
- <key>Communications Timeout</key>
- <value>
- <name>Communications Timeout</name>
- </value>
- </entry>
- </descriptors>
- <name>DistributedMapCacheClientService</name>
- <properties>
- <entry>
- <key>Server Hostname</key>
- <value>localhost</value>
- </entry>
- <entry>
- <key>Server Port</key>
- </entry>
- <entry>
- <key>SSL Context Service</key>
- </entry>
- <entry>
- <key>Communications Timeout</key>
- </entry>
- </properties>
- <state>ENABLED</state>
- <type>org.apache.nifi.distributed.cache.client.DistributedMapCacheClientService</type>
- </controllerServices>
- <processors>
- <id>fe227563-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>282.00000658301235</x>
- <y>-22.00000713365617</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Input Directory</key>
- <value>
- <name>Input Directory</name>
- </value>
- </entry>
- <entry>
- <key>Recurse Subdirectories</key>
- <value>
- <name>Recurse Subdirectories</name>
- </value>
- </entry>
- <entry>
- <key>Input Directory Location</key>
- <value>
- <name>Input Directory Location</name>
- </value>
- </entry>
- <entry>
- <key>File Filter</key>
- <value>
- <name>File Filter</name>
- </value>
- </entry>
- <entry>
- <key>Path Filter</key>
- <value>
- <name>Path Filter</name>
- </value>
- </entry>
- <entry>
- <key>Minimum File Age</key>
- <value>
- <name>Minimum File Age</name>
- </value>
- </entry>
- <entry>
- <key>Maximum File Age</key>
- <value>
- <name>Maximum File Age</name>
- </value>
- </entry>
- <entry>
- <key>Minimum File Size</key>
- <value>
- <name>Minimum File Size</name>
- </value>
- </entry>
- <entry>
- <key>Maximum File Size</key>
- <value>
- <name>Maximum File Size</name>
- </value>
- </entry>
- <entry>
- <key>Ignore Hidden Files</key>
- <value>
- <name>Ignore Hidden Files</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Input Directory</key>
- <value>/Users/mburgess/datasets</value>
- </entry>
- <entry>
- <key>Recurse Subdirectories</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Input Directory Location</key>
- <value>Local</value>
- </entry>
- <entry>
- <key>File Filter</key>
- <value>custNameLookup\.txt</value>
- </entry>
- <entry>
- <key>Path Filter</key>
- </entry>
- <entry>
- <key>Minimum File Age</key>
- <value>0 sec</value>
- </entry>
- <entry>
- <key>Maximum File Age</key>
- </entry>
- <entry>
- <key>Minimum File Size</key>
- <value>0 B</value>
- </entry>
- <entry>
- <key>Maximum File Size</key>
- </entry>
- <entry>
- <key>Ignore Hidden Files</key>
- <value>true</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>ListFile</name>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.ListFile</type>
- </processors>
- <processors>
- <id>fe228354-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>279.00000658301235</x>
- <y>181.99999668104113</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>File to Fetch</key>
- <value>
- <name>File to Fetch</name>
- </value>
- </entry>
- <entry>
- <key>Completion Strategy</key>
- <value>
- <name>Completion Strategy</name>
- </value>
- </entry>
- <entry>
- <key>Move Destination Directory</key>
- <value>
- <name>Move Destination Directory</name>
- </value>
- </entry>
- <entry>
- <key>Move Conflict Strategy</key>
- <value>
- <name>Move Conflict Strategy</name>
- </value>
- </entry>
- <entry>
- <key>Log level when file not found</key>
- <value>
- <name>Log level when file not found</name>
- </value>
- </entry>
- <entry>
- <key>Log level when permission denied</key>
- <value>
- <name>Log level when permission denied</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>File to Fetch</key>
- <value>${absolute.path}/${filename}</value>
- </entry>
- <entry>
- <key>Completion Strategy</key>
- <value>None</value>
- </entry>
- <entry>
- <key>Move Destination Directory</key>
- </entry>
- <entry>
- <key>Move Conflict Strategy</key>
- <value>Rename</value>
- </entry>
- <entry>
- <key>Log level when file not found</key>
- <value>ERROR</value>
- </entry>
- <entry>
- <key>Log level when permission denied</key>
- <value>ERROR</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>FetchFile</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>not.found</name>
- </relationships>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>permission.denied</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.FetchFile</type>
- </processors>
- <processors>
- <id>fe22abc3-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>286.00000658301235</x>
- <y>394.9999966810411</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Line Split Count</key>
- <value>
- <name>Line Split Count</name>
- </value>
- </entry>
- <entry>
- <key>Maximum Fragment Size</key>
- <value>
- <name>Maximum Fragment Size</name>
- </value>
- </entry>
- <entry>
- <key>Header Line Count</key>
- <value>
- <name>Header Line Count</name>
- </value>
- </entry>
- <entry>
- <key>Header Line Marker Characters</key>
- <value>
- <name>Header Line Marker Characters</name>
- </value>
- </entry>
- <entry>
- <key>Remove Trailing Newlines</key>
- <value>
- <name>Remove Trailing Newlines</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Line Split Count</key>
- <value>1</value>
- </entry>
- <entry>
- <key>Maximum Fragment Size</key>
- </entry>
- <entry>
- <key>Header Line Count</key>
- <value>0</value>
- </entry>
- <entry>
- <key>Header Line Marker Characters</key>
- </entry>
- <entry>
- <key>Remove Trailing Newlines</key>
- <value>true</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>Split Lines</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>original</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>splits</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.SplitText</type>
- </processors>
- <processors>
- <id>fe22f0ea-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>289.00000658301235</x>
- <y>612.9999966810411</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Character Set</key>
- <value>
- <name>Character Set</name>
- </value>
- </entry>
- <entry>
- <key>Maximum Buffer Size</key>
- <value>
- <name>Maximum Buffer Size</name>
- </value>
- </entry>
- <entry>
- <key>Maximum Capture Group Length</key>
- <value>
- <name>Maximum Capture Group Length</name>
- </value>
- </entry>
- <entry>
- <key>Enable Canonical Equivalence</key>
- <value>
- <name>Enable Canonical Equivalence</name>
- </value>
- </entry>
- <entry>
- <key>Enable Case-insensitive Matching</key>
- <value>
- <name>Enable Case-insensitive Matching</name>
- </value>
- </entry>
- <entry>
- <key>Permit Whitespace and Comments in Pattern</key>
- <value>
- <name>Permit Whitespace and Comments in Pattern</name>
- </value>
- </entry>
- <entry>
- <key>Enable DOTALL Mode</key>
- <value>
- <name>Enable DOTALL Mode</name>
- </value>
- </entry>
- <entry>
- <key>Enable Literal Parsing of the Pattern</key>
- <value>
- <name>Enable Literal Parsing of the Pattern</name>
- </value>
- </entry>
- <entry>
- <key>Enable Multiline Mode</key>
- <value>
- <name>Enable Multiline Mode</name>
- </value>
- </entry>
- <entry>
- <key>Enable Unicode-aware Case Folding</key>
- <value>
- <name>Enable Unicode-aware Case Folding</name>
- </value>
- </entry>
- <entry>
- <key>Enable Unicode Predefined Character Classes</key>
- <value>
- <name>Enable Unicode Predefined Character Classes</name>
- </value>
- </entry>
- <entry>
- <key>Enable Unix Lines Mode</key>
- <value>
- <name>Enable Unix Lines Mode</name>
- </value>
- </entry>
- <entry>
- <key>Include Capture Group 0</key>
- <value>
- <name>Include Capture Group 0</name>
- </value>
- </entry>
- <entry>
- <key>extract-text-enable-repeating-capture-group</key>
- <value>
- <name>extract-text-enable-repeating-capture-group</name>
- </value>
- </entry>
- <entry>
- <key>column</key>
- <value>
- <name>column</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Character Set</key>
- <value>UTF-8</value>
- </entry>
- <entry>
- <key>Maximum Buffer Size</key>
- <value>1 MB</value>
- </entry>
- <entry>
- <key>Maximum Capture Group Length</key>
- <value>1024</value>
- </entry>
- <entry>
- <key>Enable Canonical Equivalence</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Enable Case-insensitive Matching</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Permit Whitespace and Comments in Pattern</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Enable DOTALL Mode</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Enable Literal Parsing of the Pattern</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Enable Multiline Mode</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Enable Unicode-aware Case Folding</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Enable Unicode Predefined Character Classes</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Enable Unix Lines Mode</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Include Capture Group 0</key>
- <value>true</value>
- </entry>
- <entry>
- <key>extract-text-enable-repeating-capture-group</key>
- <value>false</value>
- </entry>
- <entry>
- <key>column</key>
- <value>([^,]+), ([^,]+), ([^,]+), ([^,]+)</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>Extract Column Values</name>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>matched</name>
- </relationships>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>unmatched</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.ExtractText</type>
- </processors>
- <processors>
- <id>fe24b83a-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>883.0000065830124</x>
- <y>605.9999966810411</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Cache Entry Identifier</key>
- <value>
- <name>Cache Entry Identifier</name>
- </value>
- </entry>
- <entry>
- <key>Distributed Cache Service</key>
- <value>
- <identifiesControllerService>org.apache.nifi.distributed.cache.client.DistributedMapCacheClient</identifiesControllerService>
- <name>Distributed Cache Service</name>
- </value>
- </entry>
- <entry>
- <key>Put Cache Value In Attribute</key>
- <value>
- <name>Put Cache Value In Attribute</name>
- </value>
- </entry>
- <entry>
- <key>Max Length To Put In Attribute</key>
- <value>
- <name>Max Length To Put In Attribute</name>
- </value>
- </entry>
- <entry>
- <key>Character Set</key>
- <value>
- <name>Character Set</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Cache Entry Identifier</key>
- <value>${column.4}</value>
- </entry>
- <entry>
- <key>Distributed Cache Service</key>
- <value>fe19347d-0158-1000-0000-000000000000</value>
- </entry>
- <entry>
- <key>Put Cache Value In Attribute</key>
- <value>column.5</value>
- </entry>
- <entry>
- <key>Max Length To Put In Attribute</key>
- <value>256</value>
- </entry>
- <entry>
- <key>Character Set</key>
- <value>UTF-8</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>Lookup Value</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>not-found</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.FetchDistributedMapCache</type>
- </processors>
- <processors>
- <id>fe256e71-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>882.0000065830122</x>
- <y>351.9999966810411</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Regular Expression</key>
- <value>
- <name>Regular Expression</name>
- </value>
- </entry>
- <entry>
- <key>Replacement Value</key>
- <value>
- <name>Replacement Value</name>
- </value>
- </entry>
- <entry>
- <key>Character Set</key>
- <value>
- <name>Character Set</name>
- </value>
- </entry>
- <entry>
- <key>Maximum Buffer Size</key>
- <value>
- <name>Maximum Buffer Size</name>
- </value>
- </entry>
- <entry>
- <key>Replacement Strategy</key>
- <value>
- <name>Replacement Strategy</name>
- </value>
- </entry>
- <entry>
- <key>Evaluation Mode</key>
- <value>
- <name>Evaluation Mode</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Regular Expression</key>
- <value>(?s)(^.*$)</value>
- </entry>
- <entry>
- <key>Replacement Value</key>
- <value>${column.1}, ${column.2}, ${column.3}, ${column.4}, ${column.5}</value>
- </entry>
- <entry>
- <key>Character Set</key>
- <value>UTF-8</value>
- </entry>
- <entry>
- <key>Maximum Buffer Size</key>
- <value>1 MB</value>
- </entry>
- <entry>
- <key>Replacement Strategy</key>
- <value>Regex Replace</value>
- </entry>
- <entry>
- <key>Evaluation Mode</key>
- <value>Entire text</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>Append Lookup Column</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.ReplaceText</type>
- </processors>
- <processors>
- <id>fe28a0c5-0158-1000-0000-000000000000</id>
- <parentGroupId>fe2247bc-0158-1000-0000-000000000000</parentGroupId>
- <position>
- <x>882.0000065830122</x>
- <y>74.9999966810411</y>
- </position>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Log Level</key>
- <value>
- <name>Log Level</name>
- </value>
- </entry>
- <entry>
- <key>Log Payload</key>
- <value>
- <name>Log Payload</name>
- </value>
- </entry>
- <entry>
- <key>Attributes to Log</key>
- <value>
- <name>Attributes to Log</name>
- </value>
- </entry>
- <entry>
- <key>Attributes to Ignore</key>
- <value>
- <name>Attributes to Ignore</name>
- </value>
- </entry>
- <entry>
- <key>Log prefix</key>
- <value>
- <name>Log prefix</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Log Level</key>
- <value>info</value>
- </entry>
- <entry>
- <key>Log Payload</key>
- <value>false</value>
- </entry>
- <entry>
- <key>Attributes to Log</key>
- </entry>
- <entry>
- <key>Attributes to Ignore</key>
- </entry>
- <entry>
- <key>Log prefix</key>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>LogAttribute</name>
- <relationships>
- <autoTerminate>true</autoTerminate>
- <name>success</name>
- </relationships>
- <style></style>
- <type>org.apache.nifi.processors.standard.LogAttribute</type>
- </processors>
- </contents>
- <name>PerformLookup</name>
- </processGroups>
- </snippet>
- <timestamp>12/14/2016 11:48:15 EST</timestamp>
- </template>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement