01f0f50a-0164-1000-543a-5c35a57e0059
ExecuteSQLSample
9c6bec96-5570-309f-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
1 GB
10000
8b15fad7-d8a2-3971-0000-000000000000
98b6fadc-43f5-3304-0000-000000000000
PROCESSOR
0 sec
1
success
8b15fad7-d8a2-3971-0000-000000000000
9315d610-8f76-3580-0000-000000000000
PROCESSOR
0
a57889ac-27c9-3622-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
1 GB
10000
8b15fad7-d8a2-3971-0000-000000000000
12fe4197-53ab-3184-0000-000000000000
PROCESSOR
0 sec
1
split
8b15fad7-d8a2-3971-0000-000000000000
b5bbcedf-249c-300c-0000-000000000000
PROCESSOR
0
cf2fbab1-86ef-3f35-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
1 GB
10000
8b15fad7-d8a2-3971-0000-000000000000
641c690f-70d8-37f9-0000-000000000000
PROCESSOR
0 sec
1
org.apache.nifi.prioritizer.FirstInFirstOutPrioritizer
org.apache.nifi.prioritizer.OldestFlowFileFirstPrioritizer
success
8b15fad7-d8a2-3971-0000-000000000000
055fe3c0-1497-385d-0000-000000000000
PROCESSOR
0
d755beb2-9ee1-35c2-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
1 GB
10000
8b15fad7-d8a2-3971-0000-000000000000
055fe3c0-1497-385d-0000-000000000000
PROCESSOR
0 sec
1
org.apache.nifi.prioritizer.FirstInFirstOutPrioritizer
org.apache.nifi.prioritizer.OldestFlowFileFirstPrioritizer
matched
8b15fad7-d8a2-3971-0000-000000000000
12fe4197-53ab-3184-0000-000000000000
PROCESSOR
0
2133f797-db3d-3959-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
1 GB
10000
8b15fad7-d8a2-3971-0000-000000000000
9315d610-8f76-3580-0000-000000000000
PROCESSOR
0 sec
1
success
8b15fad7-d8a2-3971-0000-000000000000
2acf937d-5390-3e23-0000-000000000000
PROCESSOR
0
710243bf-4fc1-3bbb-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
1 GB
10000
8b15fad7-d8a2-3971-0000-000000000000
b5bbcedf-249c-300c-0000-000000000000
PROCESSOR
0 sec
1
success
8b15fad7-d8a2-3971-0000-000000000000
e5c137f3-1471-33a9-0000-000000000000
PROCESSOR
0
7a340f76-7d2a-320b-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
1 GB
10000
8b15fad7-d8a2-3971-0000-000000000000
2acf937d-5390-3e23-0000-000000000000
PROCESSOR
0 sec
1
org.apache.nifi.prioritizer.FirstInFirstOutPrioritizer
org.apache.nifi.prioritizer.OldestFlowFileFirstPrioritizer
success
8b15fad7-d8a2-3971-0000-000000000000
641c690f-70d8-37f9-0000-000000000000
PROCESSOR
0
ef4e1da5-93d6-329d-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
nifi-dbcp-service-nar
org.apache.nifi
1.6.0
Database Connection URL
Database Connection URL
Database Driver Class Name
Database Driver Class Name
database-driver-locations
database-driver-locations
Database User
Database User
Password
Password
Max Wait Time
Max Wait Time
Max Total Connections
Max Total Connections
Validation-query
Validation-query
DBCPConnectionPool
false
Database Connection URL
jdbc:sqlserver://localhost:1433;database=northwind
Database Driver Class Name
com.microsoft.sqlserver.jdbc.SQLServerDriver
database-driver-locations
C:\Program Files (x86)\Java\jdbc\sqljdbc_6.0\jpn\jre8\sqljdbc42.jar
Database User
sa
Password
Max Wait Time
Max Total Connections
Validation-query
ENABLED
org.apache.nifi.dbcp.DBCPConnectionPool
9315d610-8f76-3580-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
437.5899668407719
3.0117701586564465
nifi-update-attribute-nar
org.apache.nifi
1.6.0
WARN
1
Delete Attributes Expression
Delete Attributes Expression
Store State
Store State
Stateful Variables Initial Value
Stateful Variables Initial Value
filename
filename
ALL
false
30 sec
Delete Attributes Expression
Store State
Do not store state
Stateful Variables Initial Value
filename
${UUID()}
0
0 sec
TIMER_DRIVEN
1 sec
UpdateAttribute
false
success
STOPPED
org.apache.nifi.processors.attributes.UpdateAttribute
98b6fadc-43f5-3304-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
1070.2424926757812
5.534629628062248
nifi-standard-nar
org.apache.nifi
1.6.0
WARN
1
Directory
Directory
Conflict Resolution Strategy
Conflict Resolution Strategy
Create Missing Directories
Create Missing Directories
Maximum File Count
Maximum File Count
Last Modified Time
Last Modified Time
Permissions
Permissions
Owner
Owner
Group
Group
ALL
false
30 sec
Directory
./data-out
Conflict Resolution Strategy
fail
Create Missing Directories
true
Maximum File Count
Last Modified Time
Permissions
Owner
Group
0
0 sec
TIMER_DRIVEN
1 sec
PutFile
true
failure
true
success
STOPPED
org.apache.nifi.processors.standard.PutFile
b5bbcedf-249c-300c-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
42.667988760909395
296.9333094176966
nifi-standard-nar
org.apache.nifi
1.6.0
WARN
1
JsonPath Expression
JsonPath Expression
Null Value Representation
Null Value Representation
ALL
false
30 sec
JsonPath Expression
$
Null Value Representation
empty string
0
0 sec
TIMER_DRIVEN
1 sec
SplitJson
true
failure
true
original
false
split
STOPPED
org.apache.nifi.processors.standard.SplitJson
e5c137f3-1471-33a9-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
0.0
0.0
nifi-standard-nar
org.apache.nifi
1.6.0
WARN
1
File Size
File Size
Batch Size
Batch Size
Data Format
Data Format
Unique FlowFiles
Unique FlowFiles
generate-ff-custom-text
generate-ff-custom-text
character-set
character-set
ALL
false
30 sec
File Size
0B
Batch Size
1
Data Format
Text
Unique FlowFiles
false
generate-ff-custom-text
[
{
"ShipperID" : 1,
"CompanyName" : "",
"Phone" : ""
},
{
"ShipperID" : 2,
"CompanyName" : "",
"Phone" : ""
},
{
"ShipperID" : 3,
"CompanyName" : "",
"Phone" : ""
}
]
character-set
UTF-8
0
1 sec
TIMER_DRIVEN
1 sec
GenerateFlowFile
false
success
STOPPED
org.apache.nifi.processors.standard.GenerateFlowFile
055fe3c0-1497-385d-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
470.93569834806635
240.9792416917138
nifi-update-attribute-nar
org.apache.nifi
1.6.0
WARN
1
Delete Attributes Expression
Delete Attributes Expression
Store State
Store State
Stateful Variables Initial Value
Stateful Variables Initial Value
sql.args.1.type
sql.args.1.type
ALL
false
30 sec
Delete Attributes Expression
Store State
Do not store state
Stateful Variables Initial Value
sql.args.1.type
4
0
0 sec
TIMER_DRIVEN
1 sec
UpdateAttribute
false
success
STOPPED
org.apache.nifi.processors.attributes.UpdateAttribute
12fe4197-53ab-3184-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
226.90539072856586
504.7139831643958
nifi-standard-nar
org.apache.nifi
1.6.0
WARN
1
Destination
Destination
Return Type
Return Type
Path Not Found Behavior
Path Not Found Behavior
Null Value Representation
Null Value Representation
sql.args.1.value
sql.args.1.value
ALL
false
30 sec
Destination
flowfile-attribute
Return Type
auto-detect
Path Not Found Behavior
ignore
Null Value Representation
empty string
sql.args.1.value
$.ShipperID
0
0 sec
TIMER_DRIVEN
1 sec
EvaluateJsonPath
true
failure
false
matched
true
unmatched
STOPPED
org.apache.nifi.processors.standard.EvaluateJsonPath
2acf937d-5390-3e23-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
908.0436401367189
238.020649433136
nifi-avro-nar
org.apache.nifi
1.6.0
WARN
1
JSON container options
JSON container options
Wrap Single Record
Wrap Single Record
Avro schema
Avro schema
ALL
false
30 sec
JSON container options
array
Wrap Single Record
false
Avro schema
0
0 sec
TIMER_DRIVEN
1 sec
ConvertAvroToJSON
true
failure
false
success
STOPPED
org.apache.nifi.processors.avro.ConvertAvroToJSON
641c690f-70d8-37f9-0000-000000000000
8b15fad7-d8a2-3971-0000-000000000000
679.0664672851562
506.7527356147766
nifi-standard-nar
org.apache.nifi
1.6.0
WARN
1
Database Connection Pooling Service
org.apache.nifi.dbcp.DBCPService
Database Connection Pooling Service
SQL select query
SQL select query
Max Wait Time
Max Wait Time
dbf-normalize
dbf-normalize
dbf-user-logical-types
dbf-user-logical-types
dbf-default-precision
dbf-default-precision
dbf-default-scale
dbf-default-scale
ALL
false
30 sec
Database Connection Pooling Service
ef4e1da5-93d6-329d-0000-000000000000
SQL select query
SELECT * FROM Shippers WHERE ShipperID = ?
Max Wait Time
0 seconds
dbf-normalize
false
dbf-user-logical-types
false
dbf-default-precision
10
dbf-default-scale
0
0
0 sec
TIMER_DRIVEN
1 sec
ExecuteSQL
true
failure
false
success
STOPPED
org.apache.nifi.processors.standard.ExecuteSQL
07/11/2018 17:58:58 JST