Complex queries in Influxdb using Python language
Budget: $25 – $50 USD
I need an expert in writing scripting language for influxdb.
Influxdb is a time series database. I need to pull a subset of records from a large set of data in one table.
Data was logged one record every 0.5 seconds.
Example of some of the work.
In other db's this would work:
1)
SELECT * FROM table_x
GROUP BY
DATEPART(YEAR, DT.[Date]),
DATEPART(MONTH, DT.[Date]),
DATEPART(DAY, DT.[Date]),
DATEPART(HOUR, DT.[Date]),
(DATEPART(MINUTE, DT.[Date]) / 10)
2) or
SELECT * FROM table_x
GROUP BY DATEDIFF(MINUTE, '2000', date_column) / 10
The result would be a sampling of data every 20 minutes across the entire _start_time to _end_time
Influxdb is a time series database. I need to pull a subset of records from a large set of data in one table.
Data was logged one record every 0.5 seconds.
Example of some of the work.
In other db's this would work:
1)
SELECT * FROM table_x
GROUP BY
DATEPART(YEAR, DT.[Date]),
DATEPART(MONTH, DT.[Date]),
DATEPART(DAY, DT.[Date]),
DATEPART(HOUR, DT.[Date]),
(DATEPART(MINUTE, DT.[Date]) / 10)
2) or
SELECT * FROM table_x
GROUP BY DATEDIFF(MINUTE, '2000', date_column) / 10
The result would be a sampling of data every 20 minutes across the entire _start_time to _end_time