Skip to main content

All Questions

Filter by
Sorted by
Tagged with
1 vote
1 answer
1k views

unable to write in influxdb2 using pandas dataframe

I am trying to write data from a panda's dataframe to influxdb v2.2 using python. However, I am not seeing any data in query. import pandas as pd from influxdb_client import InfluxDBClient from ...
myquest5 sh's user avatar
0 votes
1 answer
379 views

Why is this inner join returning noting, while it should return many lines items

This code executes an innerjoin operation on an influx.db My expectation is that a new table should be returned with entries that are common for booth input tables. But is does not return is nothing. ...
H Doucet's user avatar
0 votes
1 answer
205 views

Dates getting modified to1970-01-01T00:00:01.659452061Z when writing it to InfluxDb using the InfluxDb php client

I am using PHP Client for InfluxDB - https://github.com/influxdata/influxdb-client-php I am inserting points in my measurement along with current timestamp. For the timestamp, I am using as follows - $...
Shubham khetan's user avatar
1 vote
2 answers
564 views

Calculating average of elapsed time

I want to calculate the average time duration of my events. After an event starts and ends, it sends a request to my InfluxDB in the Line Protocol Syntax: mes1 id=1,event="start" 1655885442 ...
gaout5's user avatar
  • 69
1 vote
0 answers
985 views

InfluxDB Line Protocol Performance 1.8 vs. 2.0

I noticed that there is a considerable (5x) performance penalty when upgrading my app from InfluxDB 1.8 to 2.0. I'm using ILP and the only change I made on the ingress side was switching from /write ...
Michael's user avatar
  • 1,506
0 votes
1 answer
3k views

max-series-per-database limit exceeded clarification needed / how to calculate number of series in use

We recently started to encounter this error: {"error":"partial write: max-series-per-database limit exceeded: (1000000) dropped=1"} When writing metric data like this: resque_job,...
Keith Palmer Jr.'s user avatar
1 vote
0 answers
426 views

Export flux (Influxdb 2.0) database into csv in CLI

I found that we can send a CSV file into Influxdb 2.0, but is the reverse operation possible? How can I export flux database into CSV file in CLI?
dadoheh's user avatar
  • 11
1 vote
1 answer
1k views

Efficiently loading large time series data into InfluxDB

I am trying to load 100 billion (thousands of columns, millions of rows) multi-dimensional time series datapoints into InfluxDB from a CSV file. I am currently doing it through line protocol as ...
AbdelKh's user avatar
  • 542