AdaFruit Funhouse publishing Temperature, Humidity and Pressure to MQTT / Apache Pulsar

Related tags

Networkingpulsar-adafruit-funhouse
Overview

pulsar-adafruit-funhouse

AdaFruit Funhouse publishing Temperature, Humidity and Pressure to MQTT / Apache Pulsar

Device

Adafruit Funhouse

Get your own from adafruit

Fork of adafruit Funhouse

I removed the mqtt consume, as I just want to produce data. I also lowered the time down to 10 seconds to get more data.

Apache Pulsar / MQTT Server Setup

bin/pulsar-admin topics create persistent://public/default/funhousestate

bin/pulsar-admin topics create persistent://public/default/funhouselightstate

bin/pulsar-admin topics create persistent://public/default/funhouselightset

bin/pulsar-client consume "persistent://public/default/funhousestate" -s "fhs" -n 0

bin/pulsar-client consume "persistent://public/default/funhouselightstate" -s "fhs2" -n 0

Example Consuming


11:02:47.628 [pulsar-client-io-1-1] INFO  org.apache.pulsar.client.impl.ConnectionPool - [[id: 0x3ec5ce7d, L:/127.0.0.1:59610 - R:localhost/127.0.0.1:6650]] Connected to server
11:02:47.628 [pulsar-client-io-1-1] INFO  org.apache.pulsar.client.impl.ClientCnx - [id: 0x3ec5ce7d, L:/127.0.0.1:59610 - R:localhost/127.0.0.1:6650] Connected through proxy to target broker at 127.0.0.1:6650
11:02:47.630 [pulsar-client-io-1-1] INFO  org.apache.pulsar.client.impl.ConsumerImpl - [persistent://public/default/funhousestate][fhs] Subscribing to topic on cnx [id: 0x3ec5ce7d, L:/127.0.0.1:59610 - R:localhost/127.0.0.1:6650], consumerId 0
11:02:47.642 [pulsar-client-io-1-1] INFO  org.apache.pulsar.client.impl.ConsumerImpl - [persistent://public/default/funhousestate][fhs] Subscribed to topic on localhost/127.0.0.1:6650 -- consumer: 0
11:02:47.673 [pulsar-client-io-1-1] INFO  com.scurrilous.circe.checksum.Crc32cIntChecksum - SSE4.2 CRC32C provider initialized
----- got message -----
key:[null], properties:[], content:{"pressure": 1025.05, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1458, "temperature": 77.8455, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 7049}
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.98, "button_sel": "off", "pir_sensor": "off", "humidity": 27.0822, "temperature": 77.9334, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 7784}
11:03:47.607 [pulsar-timer-5-1] INFO  org.apache.pulsar.client.impl.ConsumerStatsRecorderImpl - [persistent://public/default/funhousestate] [fhs] [940a9] Prefetched messages: 0 --- Consume throughput received: 0.03 msgs/s --- 0.00 Mbit/s --- Ack sent rate: 0.03 ack/s --- Failed messages: 0 --- batch messages: 0 ---Failed acks: 0
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.151, "temperature": 77.8507, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9234}
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "on", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9413}
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9413}
11:04:47.608 [pulsar-timer-5-1] INFO  org.apache.pulsar.client.impl.ConsumerStatsRecorderImpl - [persistent://public/default/funhousestate] [fhs] [940a9] Prefetched messages: 0 --- Consume throughput received: 0.05 msgs/s --- 0.00 Mbit/s --- Ack sent rate: 0.05 ack/s --- Failed messages: 0 --- batch messages: 0 ---Failed acks: 0
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.91, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7443, "temperature": 78.4608, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 11180}
11:05:47.609 [pulsar-timer-5-1] INFO  org.apache.pulsar.client.impl.ConsumerStatsRecorderImpl - [persistent://public/default/funhousestate] [fhs] [940a9] Prefetched messages: 0 --- Consume throughput received: 0.02 msgs/s --- 0.00 Mbit/s --- Ack sent rate: 0.02 ack/s --- Failed messages: 0 --- batch messages: 0 ---Failed acks: 0
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.93, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8115, "temperature": 78.1902, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 13365}

Device Output

Connecting to AP WiFi-SSiD
Attempting to connect to 192.168.1.230
Connected to MQTT! Subscribing...
Publishing to funhouselightstate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate

Pulsar SQL (Trino/Presto) Against Our Topic

select from_utf8(__value__), __event_time__ from pulsar."public/default".funhousestate; _col0 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4877, "temperature": 78.4426, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5187, "temperature": 78.3746, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5695, "temperature": 78.3619, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5451, "temperature": 78.4014, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5962, "temperature": 78.4419, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5153, "temperature": 78.4653, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4735, "temperature": 78.5113, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4802, "temperature": 78.5772, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4331, "temperature": 78.5614, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4751, "temperature": 78.5284, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4645, "temperature": 78.4927, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4821, "temperature": 78.5175, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4546, "temperature": 78.5806, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4349, "temperature": 78.5353, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.5181, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4441, "temperature": 78.5205, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.446, "temperature": 78.5514, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 8 {"pressure": 1024.71, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4064, "temperature": 78.5587, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.71, "button_sel": "off", "pir_sensor": "off", "humidity": 26.445, "temperature": 78.489, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 86 {"pressure": 1024.7, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4509, "temperature": 78.4745, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 8 {"pressure": 1024.7, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4372, "temperature": 78.5597, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9 {"pressure": 1024.69, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4294, "temperature": 78.5689, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.69, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3617, "temperature": 78.6016, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.68, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3444, "temperature": 78.629, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.408, "temperature": 78.6046, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3903, "temperature": 78.6146, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3998, "temperature": 78.594, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3886, "temperature": 78.5878, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3589, "temperature": 78.5954, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4276, "temperature": 78.5999, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4165, "temperature": 78.593, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.44, "temperature": 78.572, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 192 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3759, "temperature": 78.5319, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4074, "temperature": 78.5562, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4225, "temperature": 78.5463, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4137, "temperature": 78.5587, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4313, "temperature": 78.6417, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3575, "temperature": 78.7125, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3391, "temperature": 78.6949, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3239, "temperature": 78.7299, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2817, "temperature": 78.7293, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.64, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3036, "temperature": 78.7842, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.64, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2396, "temperature": 78.8216, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1025.05, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1458, "temperature": 77.8455, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.98, "button_sel": "off", "pir_sensor": "off", "humidity": 27.0822, "temperature": 77.9334, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.151, "temperature": 77.8507, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "on", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.91, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7443, "temperature": 78.4608, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.93, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8115, "temperature": 78.1902, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7218, "temperature": 78.364, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.88, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7223, "temperature": 78.4419, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.83, "button_sel": "off", "pir_sensor": "off", "humidity": 26.691, "temperature": 78.4127, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7081, "temperature": 78.2891, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8562, "temperature": 78.217, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8162, "temperature": 78.2222, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.79, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7946, "temperature": 78.1611, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.79, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7673, "temperature": 78.3159, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.6741, "temperature": 78.3077, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.6788, "temperature": 78.2239, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5748, "temperature": 78.3468, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4924, "temperature": 78.5672, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4867, "temperature": 78.7173, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3744, "temperature": 78.8199, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2759, "temperature": 78.8206, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2799, "temperature": 78.8103, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "on", "captouch8": "off", "light": 3 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2799, "temperature": 78.8103, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3747, "temperature": 78.8141, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3929, "temperature": 78.7966, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4026, "temperature": 78.7694, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3921, "temperature": 78.7409, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4369, "temperature": 78.7111, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4217, "temperature": 78.7327, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "on", "captouch8": "off", "light": 7 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "on", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.6932, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 2 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.6932, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4091, "temperature": 78.7592, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4165, "temperature": 78.7471, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4155, "temperature": 78.7636, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3756, "temperature": 78.7626, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3491, "temperature": 78.7262, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.74, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3958, "temperature": 78.7001, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4425, "temperature": 78.5669, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4686, "temperature": 78.5387, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4582, "temperature": 78.5126, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": (87 rows) Query 20211220_163025_00001_jb263, FINISHED, 1 node Splits: 18 total, 18 done (100.00%) 0:01 [87 rows, 36KB] [82 rows/s, 34.1KB/s] "> 
presto> describe pulsar."public/default".funhousestate;
      Column       |   Type    | Extra |                                   Comment                                   
-------------------+-----------+-------+-----------------------------------------------------------------------------
 __value__         | varbinary |       | The value of the message with primitive type schema                         
 __partition__     | integer   |       | The partition number which the message belongs to                           
 __event_time__    | timestamp |       | Application defined timestamp in milliseconds of when the event occurred    
 __publish_time__  | timestamp |       | The timestamp in milliseconds of when event as published                    
 __message_id__    | varchar   |       | The message ID of the message used to generate this row                     
 __sequence_id__   | bigint    |       | The sequence ID of the message used to generate this row                    
 __producer_name__ | varchar   |       | The name of the producer that publish the message used to generate this row 
 __key__           | varchar   |       | The partition key for the topic                                             
 __properties__    | varchar   |       | User defined properties                                                     
(9 rows)

Query 20211220_162305_00000_jb263, FINISHED, 1 node

presto> select from_utf8(__value__), __event_time__ from pulsar."public/default".funhousestate;
                                                                                                               _col0                                                                                                         
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4877, "temperature": 78.4426, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5187, "temperature": 78.3746, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5695, "temperature": 78.3619, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5451, "temperature": 78.4014, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5962, "temperature": 78.4419, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5153, "temperature": 78.4653, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4735, "temperature": 78.5113, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4802, "temperature": 78.5772, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4331, "temperature": 78.5614, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4751, "temperature": 78.5284, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4645, "temperature": 78.4927, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4821, "temperature": 78.5175, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4546, "temperature": 78.5806, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4349, "temperature": 78.5353, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.5181, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4441, "temperature": 78.5205, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.446, "temperature": 78.5514, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 8
 {"pressure": 1024.71, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4064, "temperature": 78.5587, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.71, "button_sel": "off", "pir_sensor": "off", "humidity": 26.445, "temperature": 78.489, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 86
 {"pressure": 1024.7, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4509, "temperature": 78.4745, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 8
 {"pressure": 1024.7, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4372, "temperature": 78.5597, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9
 {"pressure": 1024.69, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4294, "temperature": 78.5689, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.69, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3617, "temperature": 78.6016, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.68, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3444, "temperature": 78.629, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.408, "temperature": 78.6046, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3903, "temperature": 78.6146, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3998, "temperature": 78.594, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3886, "temperature": 78.5878, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3589, "temperature": 78.5954, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4276, "temperature": 78.5999, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4165, "temperature": 78.593, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.44, "temperature": 78.572, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 192
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3759, "temperature": 78.5319, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4074, "temperature": 78.5562, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4225, "temperature": 78.5463, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4137, "temperature": 78.5587, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4313, "temperature": 78.6417, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3575, "temperature": 78.7125, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3391, "temperature": 78.6949, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3239, "temperature": 78.7299, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2817, "temperature": 78.7293, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.64, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3036, "temperature": 78.7842, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.64, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2396, "temperature": 78.8216, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1025.05, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1458, "temperature": 77.8455, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.98, "button_sel": "off", "pir_sensor": "off", "humidity": 27.0822, "temperature": 77.9334, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.151, "temperature": 77.8507, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9
 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "on", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9
 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.91, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7443, "temperature": 78.4608, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.93, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8115, "temperature": 78.1902, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7218, "temperature": 78.364, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.88, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7223, "temperature": 78.4419, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.83, "button_sel": "off", "pir_sensor": "off", "humidity": 26.691, "temperature": 78.4127, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7081, "temperature": 78.2891, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8562, "temperature": 78.217, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8162, "temperature": 78.2222, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.79, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7946, "temperature": 78.1611, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.79, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7673, "temperature": 78.3159, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.6741, "temperature": 78.3077, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.6788, "temperature": 78.2239, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5748, "temperature": 78.3468, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4924, "temperature": 78.5672, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4867, "temperature": 78.7173, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3744, "temperature": 78.8199, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2759, "temperature": 78.8206, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2799, "temperature": 78.8103, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "on", "captouch8": "off", "light": 3
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2799, "temperature": 78.8103, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3747, "temperature": 78.8141, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3929, "temperature": 78.7966, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4026, "temperature": 78.7694, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3921, "temperature": 78.7409, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4369, "temperature": 78.7111, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4217, "temperature": 78.7327, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "on", "captouch8": "off", "light": 7
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "on", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.6932, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 2
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.6932, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4091, "temperature": 78.7592, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4165, "temperature": 78.7471, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4155, "temperature": 78.7636, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3756, "temperature": 78.7626, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3491, "temperature": 78.7262, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.74, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3958, "temperature": 78.7001, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4425, "temperature": 78.5669, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4686, "temperature": 78.5387, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4582, "temperature": 78.5126, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
(87 rows)

Query 20211220_163025_00001_jb263, FINISHED, 1 node
Splits: 18 total, 18 done (100.00%)
0:01 [87 rows, 36KB] [82 rows/s, 34.1KB/s]

Tweaking Python Code

MU

Owner
Timothy Spann
Dev Advocate, Java Dev, Cloud Analytics Dev, Apache NiFi Dev, Data Engineer, IoT Dev, AI, ML, Python Developer, RP, FLANK, FLIP, Apache Pulsar, StreamNative
Timothy Spann
GitHub Repository
API Server for VoIP analysis (CDR + Audio CODECs)

Swagger generated server Overview This server was generated by the swagger-codegen project. By using the OpenAPI-Spec from a remote server, you can ea

Noor Muhammad Malik 1 Jan 11, 2022
EchoDNS - Analyze your DNS traffic super easy, shows all requested DNS traffic

EchoDNS - Analyze your DNS traffic super easy, shows all requested DNS traffic

Oli Zimmermann 1 Jan 11, 2022
Eclipse zenoh Python API

Eclipse zenoh Python API Eclipse zenoh is an extremely efficient and fault-tolerant Named Data Networking (NDN) protocol that is able to scale down to

26 Jan 05, 2023
Light, simple RPC framework for Python

Agileutil是一个Python3 RPC框架。基于微服务架构，封装了rpc/http/orm/log等常用组件，提供了简洁的API，开发者可以很快上手，快速进行业务开发。

16 Nov 22, 2022
Usbkill - an anti-forensic kill-switch that waits for a change on your USB ports and then immediately shuts down your computer.

Usbkill - an anti-forensic kill-switch that waits for a change on your USB ports and then immediately shuts down your computer.

Hephaestos 4.1k Dec 30, 2022
DNS monitoring system built with Python.

DNS monitoring system built with Python.

Andressa Cabistani 7 Sep 28, 2021
PcapXray - A Network Forensics Tool - To visualize a Packet Capture offline as a Network Diagram

PcapXray - A Network Forensics Tool - To visualize a Packet Capture offline as a Network Diagram including device identification, highlight important communication and file extraction

Srinivas P G 1.4k Dec 28, 2022
A simple python script to send cute messages to my boyfriend.

Morning Messages A simple python script to send cute messages to my boyfriend. It gives him the weather and news currently. Installation git clone htt

Sabrina Medwinter 3 Oct 12, 2022
Openconnect VPN RPi Gateway

Openconnect-VPN-RPi-Gateway See the blog (Chinese) for how to build an Openconne

Zhongze Tang 2 Jan 30, 2022
The can package provides controller area network support for Python developers

python-can The Controller Area Network is a bus standard designed to allow microcontrollers and devices to communicate with each other. It has priorit

Brian Thorne 904 Dec 29, 2022
Geowifi 📡 💘 🌎 Search WiFi geolocation data by BSSID and SSID on different public databases.

Geowifi 📡 💘 🌎 Search WiFi geolocation data by BSSID and SSID on different public databases.

GOΠZO 441 Dec 23, 2022
Dshell is a network forensic analysis framework.

Dshell An extensible network forensic analysis framework. Enables rapid development of plugins to support the dissection of network packet captures. K

DEVCOM Army Research Laboratory 5.4k Jan 06, 2023
Take a list of domains and probe for working HTTP and HTTPS servers

httprobe Take a list of domains and probe for working http and https servers. Install ▶ go get -u github.com/tomnomnom/httprobe Basic Usage httprobe

Tom Hudson 2.3k Dec 28, 2022
IP-Escaner - A Python Tool to obtain information from an IP address

IP-Escaner Herramienta para obtener informacion de una direccion IP Opciones de

4 Apr 09, 2022
OptiPLANT is a cloud-based based system that empowers professional and non-professional data scientists to build high-quality predictive models

OptiPLANT OptiPLANT is a cloud-based based system that empowers professional and non-professional data scientists to build high-quality predictive mod

Intellia ICT 1 Jan 26, 2022
Nexum is an open-source, remote administration tool written in Python 3

A full-featured remote administration tool written in Python 3. The goal of this project is to make the use of a remote administration tool as simple

z3phyrus 2 Nov 26, 2021
GitHub action for sspanel automatically checks in to get free traffic quota

SSPanel_Checkin This is a dish chicken script for automatic check-in of sspanel for GitHub action, It is only applicable when there is no verification

FeedCatWithFish 7 Apr 28, 2022
PoC code for stealing the WiFi password of a network with a Lovebox IOT device connected

LoveBoxer PoC code for stealing the WiFi password of a network with a Lovebox IOT device connected. This PoC was is what I used in this blogpost Usage

Graham Helton 10 May 24, 2022
Base on browser-time to get har from network, and use python to analyze the data .

base on browser-time to get har from network, and use python to analyze the data

1 Dec 20, 2021
订阅转换，添加免流host

普通订阅转免流订阅 原理 将原来的订阅解析后添加免流host 使用方法 服务器域名/&&订阅链接&&免流host&&转换后服务器前缀 我这里已经在服务器上搭建好了

163 Apr 01, 2022