false true false srv 127.0.0.1 = rest_port 9081 = mqtt_srv 127.0.0.1 = continue false 1 1 1 false true false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true false false ${mqtt_srv} 1883 3.1 10 false 10 TCP false conn_ true 300 0 0 true true false { "sql" : "create table lookupTable (id bigint, name string, size bigint) WITH (FORMAT=\"JSON\", DATASOURCE=\"lookup.json\", CONF_KEY=\"test\" )" } = ${srv} ${rest_port} /tables POST true false true false Table lookupTable is created. Assertion.response_data true 16 true false { "sql" : "create stream demo (id bigint, temperature float, humidity bigint) WITH (FORMAT=\"JSON\", DATASOURCE=\"messages\" )" } = ${srv} ${rest_port} /streams POST true false true false Stream demo is created. Assertion.response_data true 16 true false { "id": "ruleTableStatic", "sql": "SELECT * FROM demo INNER JOIN lookupTable on demo.id = lookupTable.id WHERE temperature > 30", "actions": [ { "mqtt": { "server": "tcp://${mqtt_srv}:1883", "topic": "devices/result", "qos": 1, "clientId": "demo_001" } } ] } = ${srv} ${rest_port} /rules POST true false true false Rule ruleTableStatic was created Assertion.response_data true 16 ${srv} ${rest_port} /rules/ruleTableStatic/status GET true false true false $.source_demo_0_records_in_total 0 true false false false true 10 , iot_data_with_id.txt false false true shareMode.thread false id,temperature,humidity messages 0 false String 1024 {"id": ${id}, "temperature": ${temperature}, "humidity" : ${humidity}} false ${srv} ${rest_port} /rules/ruleTableStatic/status GET true false true false $.source_demo_0_records_in_total 10 true false false false $.sink_mqtt_0_0_records_in_total 6 true false false false 5000 ${srv} ${rest_port} /rules/ruleTableStatic DELETE true false true false Rule ruleTableStatic is dropped. Assertion.response_data false 16 ${srv} ${rest_port} /streams/demo DELETE true false true false Stream demo is dropped. Assertion.response_data false 16 ${srv} ${rest_port} /tables/lookupTable DELETE true false true false Table lookupTable is dropped. Assertion.response_data false 16 500 continue false 6 1 1 false true false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true ${mqtt_srv} 1883 3.1 10 false 10 TCP false conn_ true 300 0 0 true devices/result 0 false true number of received messages 1 $[0].id ${id} true false false false $[0].temperature ${temperature} true false false false $[0].humidity ${humidity} true false false false $[0].name ${name} true false false false , table_static_result_data.txt false false true shareMode.thread false id,temperature,humidity,name