mqtt - 如何将传感器中的数据加载到 CrateDB 中？

Question

我们有一个将数据发布到 TCP 套接字的传感器。

我们如何在 CrateDB 中创建一个摄取规则以从该特定套接字读取？

我们是否需要使用 MQTT 从 Socket 读取数据，然后将其发布为主题，以便 CrateDB 摄取规则可以读取它？

这种方法听起来效率低下。我们想直接用来自 TCP 套接字的数据填充表。那可能吗？

标签： mqttcratecratedb

Answer 1

No this is currently not possible inside CrateDB. Also please aware that the MQTT implementation at CrateDB is deprecated and will be removed in future versions, https://crate.io/docs/crate/reference/en/latest/admin/ingestion/sources/mqtt.html. Main reasons are that the current implementation was very limited (e.g only implements MQTT Quality of Service (QoS) level one), using a dedicated MQTT ingest service is much more flexible in rule definition and protocol support, etc...