When using mqtt to insert data into Apache IoTDB, why unrecoverable_error reported in the system?
I currently use mqtt bridges data to Apache IoTDB, and uses the http rule action method to connect to IoTDB’s RESTful v1 interface. I think the settings are fine, but why can’t I insert the data successfully? The rules can hit, but the insertion actions fail. The log record reported like 2024-04-23T10:39:34.316000+08:00 [error] msg: unrecoverable_error, mfa: emqx_resource_buffer_worker:handle_query_result_pure/3(929), id: <<"action:http:iotDB_RESTful:connector:http:connector_iotDB_RESTful">>, reason: {unrecoverable_error,#{body => <<"<html>n<head>n<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>n<title>. Anyone know what the reason is?
How to simplify the method of querying cumulative data difference in certain collection frequency in Apache IoTDB?
How to quickly query the daily electricity consumption of each day in a year based on time series data of cumulative data electricity meters? My current query method using Apache IoTDB is too complicated and I want to simplify it, but it seems that aggregation by day and the spread function cannot be used, because the data I got from the electricity meter is a cumulative amount. The collection frequency is 5 minutes, and what I need is to subtract the value at 0 o’clock today from the value at 0 o’clock yesterday. See if anyone can provide easier query statement.
My current method in IoTDB is:
How to set Apache IoTDB to query the data based on grouping of two time field sequences stored?
In my scenario, there are two time recorded: data collection time by the device and the data upload time by the data mining program. Now it is necessary to store both times, but I need to generate group by query based on the certain difference of the two time periods. Meaning the query should be something like select two time sequences from root.db.where the third time difference sequence >= value. Does Apache IoTDB support querying data of two time characteristics like my case, and how to do this?