Complex queries in Influxdb using Python language

Job ID: 33333543

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
Related categories: Python SQL MongoDB