1 | initial version |
The method for computing the average of time series data at two measuring locations in Apache IoTDB Version 0.12 is as follows:
USE <device>
command.SELECT
statement to retrieve the data from both time series.AVG
function to the retrieved data to compute the average.FETCH
statement or export it to a file using the EXPORT
statement.For example, assume that we have two time series, voltage
and current
, located under the device sensor1
. We can compute the average of these series as follows:
USE sensor1;
SELECT AVG(voltage), AVG(current) FROM voltage, current;
This will retrieve the average value of voltage
and current
at all timestamps and display the result.