07b2cb23-015d-1000-9ca0-7941d88e968b
SQLFromJSON
b8c29602-7a64-305f-0000-000000000000
c0033eee-a190-37dc-0000-000000000000
0.0
0.0
b2183133-1415-3774-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
1 GB
10000
1357.47314453125
661.2102661132812
b8c29602-7a64-305f-0000-000000000000
d692df41-7226-3f49-0000-000000000000
PROCESSOR
0 sec
0
failure
unmatched
b8c29602-7a64-305f-0000-000000000000
5d221f8b-bdfb-3b30-0000-000000000000
PROCESSOR
0
d044074d-3116-3adb-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
1 GB
10000
b8c29602-7a64-305f-0000-000000000000
5d221f8b-bdfb-3b30-0000-000000000000
PROCESSOR
0 sec
1
split
b8c29602-7a64-305f-0000-000000000000
d426ea1c-0444-3c6a-0000-000000000000
PROCESSOR
0
04ffb73c-a0df-37c0-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
1 GB
10000
978.6563110351562
377.4419860839844
b8c29602-7a64-305f-0000-000000000000
d426ea1c-0444-3c6a-0000-000000000000
PROCESSOR
0 sec
0
success
b8c29602-7a64-305f-0000-000000000000
266a29a1-8ee2-387f-0000-000000000000
PROCESSOR
0
2a799b10-0875-3eeb-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
1 GB
10000
b8c29602-7a64-305f-0000-000000000000
15a45395-7d28-3a69-0000-000000000000
PROCESSOR
0 sec
1
matched
b8c29602-7a64-305f-0000-000000000000
5d221f8b-bdfb-3b30-0000-000000000000
PROCESSOR
0
c7e95f89-fece-34c8-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
244.8497452887368
471.5224891485574
35.406002044677734
363.2547607421875
d7c1333a-4160-3d07-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
423.92683269108056
267.65014417785426
36.98822021484375
251.8807373046875
073f62f2-683f-31fa-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
799.5792374762368
157.03944166320582
41.32547378540039
373.30682373046875
430e93cf-9174-3ef1-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
951.3106827887368
469.94027479308863
35.61069869995117
356.5719299316406
d426ea1c-0444-3c6a-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
438.956298828125
312.6190490722656
nifi-standard-nar
org.apache.nifi
1.4.0-SNAPSHOT
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
org.apache.nifi.processors.standard.SplitJson
d692df41-7226-3f49-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
887.7401575342961
665.3428203082949
nifi-standard-nar
org.apache.nifi
1.4.0-SNAPSHOT
WARN
1
Log Level
Log Level
Log Payload
Log Payload
Attributes to Log
Attributes to Log
Attributes to Ignore
Attributes to Ignore
Log prefix
Log prefix
character-set
character-set
ALL
false
30 sec
Log Level
info
Log Payload
false
Attributes to Log
Attributes to Ignore
Log prefix
character-set
UTF-8
0
0 sec
TIMER_DRIVEN
1 sec
LogAttribute
false
success
org.apache.nifi.processors.standard.LogAttribute
15a45395-7d28-3a69-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
253.57388305664062
517.2214050292969
nifi-standard-nar
org.apache.nifi
1.4.0-SNAPSHOT
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
SQL select query
select '${ID}' as ID from Device
where DeviceID = ${DeviceID}
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
false
failure
false
success
org.apache.nifi.processors.standard.ExecuteSQL
266a29a1-8ee2-387f-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
808.110595703125
211.0854377746582
nifi-standard-nar
org.apache.nifi
1.4.0-SNAPSHOT
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
ALL
false
30 sec
File Size
0B
Batch Size
1
Data Format
Text
Unique FlowFiles
false
generate-ff-custom-text
[ {
"ID" : 14733307,
"DeviceID" : "40d71f9776cbdca1a39b6f8c5493219f16ce5e8ac77a537f3936d5b81c367320",
"LogDate" : "2017-07-03 12:27:26.327",
"Latitude" : -29.98709106445312,
"Longitude" : -51.1904296875
} ]
0
1d
TIMER_DRIVEN
1 sec
GenerateFlowFile
false
success
org.apache.nifi.processors.standard.GenerateFlowFile
5d221f8b-bdfb-3b30-0000-000000000000
b8c29602-7a64-305f-0000-000000000000
886.3625845125343
520.7035739498886
nifi-standard-nar
org.apache.nifi
1.4.0-SNAPSHOT
WARN
1
Destination
Destination
Return Type
Return Type
Path Not Found Behavior
Path Not Found Behavior
Null Value Representation
Null Value Representation
DeviceID
DeviceID
ID
ID
Latitude
Latitude
LogDate
LogDate
Longitude
Longitude
ALL
false
30 sec
Destination
flowfile-attribute
Return Type
auto-detect
Path Not Found Behavior
ignore
Null Value Representation
empty string
DeviceID
$.DeviceID
ID
$.ID
Latitude
$.Latitude
LogDate
$.LogDate
Longitude
$.Longitude
0
0 sec
TIMER_DRIVEN
1 sec
EvaluateJsonPath
false
failure
false
matched
false
unmatched
org.apache.nifi.processors.standard.EvaluateJsonPath
SQLFromJSON
07/04/2017 09:14:04 JST