python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - influxdb

Trying to convert influxdb timestamp in a csv to date and time columns

I am migrating an InfluxDB database to mySQL. I have managed to export the influx data to a CSV file, which is great, but now I am stuck with the date and time field which has been given to me. I have...
test-img

Isaac

python

datetime

influxdb

Votes: 0

Answers: 1

Latest Answer

According to the influxdb docs they store timestamp values with nanoseconds precision. However the datetime.fromtimestamp method expects a floating point number and its integer part is in second preci...
test-img

Szabolcs

InfluxQL query to Flux conversion

I would like to switch from InfluxQL to flux, but now I want to convert the query: SELECT sum("execution_duration") / sum("interval_duration) as "Availability" FROM "data...
test-img

Tom van den Bogaart

sql

database

influxdb

flux

Votes: 0

Answers: 1

Latest Answer

SELECT sum("execution_duration") / sum("interval_duration") as "Availability" FROM "data-oee" WHERE $timeFilter GROUP BY time($time_interval) In this influx que...
test-img

Ritesh Kumar Singh

Finding the Sum based on Group using Flux Query - InfluxDB

I am trying to use flux query language to find the sum of a column based on a person. If I have the following input table: How can I use a Flux Query to obtain the following output table: I have tri...
test-img

Dr.Dough

mysql

grafana

influxdb

influxql

flux-influxdb

Votes: 0

Answers: 1

Latest Answer

You are almost on the right way. You have already grouped by name and now you need to use function sum. Pay attention on last function - |> group() it's just for union table to one view. |> grou...
test-img

Amerousful

Get the number of points in a bucket for a time interval with Flux query

Given a bucket how do I get the number of points in this bucket with the timestamp in the given time interval using a Flux query? I'm trying to estimate how much data is added to an influxdb2 bucket p...
test-img

axk

influxdb

influxdb-2

flux-influxdb

Votes: 0

Answers: 2

Latest Answer

This is what I ended up doing: from(bucket: "mybucket") |> range(start: -1m) |> group() |> count() In my case there's a very big number of series (table streams returned by...
test-img

axk

Posts

Questions

Blogs

Jobs