Relative Content

Tag Archive for databaseapache-iotdbiotdb

Why did the real-time data synchronization process of Apache IoTDB took longer time than stated?

After configuring data synchronization setting in Apache IoTDB, how long does it usually take for real-time data to be synchronized? Currently, it takes me about 10 minutes to synchronize, which I checked and should not be the case (to wait this long). Is it because of any configuration mistake I made? Or are there any process I missed?
My configuration command is create pipe p21to22 WITH EXTRACTOR ('extractor' = 'iotdb-extractor','extractor.pattern' = 'root.**', 'extractor.history.enable' = 'true','extractor.history.start-time' = '2024-04-15T16:57:31.750+08:00','extractor.history.end-time' = '2024-04-15T17:12:31.750+08:00','extractor.realtime.enable' = 'true') with connector ('connector'='iotdb-thrift-connector','connector.ip'='192.168.0.122','connector.port'='6667').

How to set the system.nanoTime() time settings in Apache IoTDB to avoid time duplication?

I am trying to change the time precision of Apache IoTDB from milliseconds to nanoseconds. Since I am using java to compile the settings, I found that if using java’s system.nanoTime() tool to change the time units of IoTDB, the new generated time data set does not start from 1970 (which should be the start point of all time values to avoid time duplication). Will the time value be repeated and overwrite the data from different timestamps if this is implemented? Or what should I do using IoTDB to change the settings now?

How to add time condition to the `count` query statement of the total fields for certain path in Apache IoTDB?

Can time conditions be added to the syntax for counting the total amount of fields under a certain path in Apache IoTDB? I tried command count TIMESERIES root.OLC, and this query is executed successfully, but when I tried count TIMESERIES root.OLC WHERE time >= NOW() -10h and time <= now(), this query is failed to execute. The error message of this query is 700: Error occurred while parsing SQL to physical plan: line 1:59 mismatched input 'time' expecting, prompting that the time keyword is incorrect. If I need to add time condition to this kind of query, how can I write the query statement alternatively?