Stack Overflow
Stack Overflow

Questions tagged [influxdb-python]

Use this tag for questions about the InfluxDB-Python client library.

215 questions
1
vote
2 answers

What is the query to select multiple columns and group by one of the column in InfluxDb using Flux?

How to write similar query using Flux: SELECT field_a,field_b from 'measurement' where field_a = 10 and group by field_b
Nikhil
  • 21
  • 1
  • 2
1
vote
0 answers

Connecting and accessing data from influxdb(self hosted server) to jupyter notebook

I have been trying to access influxdb self hosted data through jupyter notebook. ref link: https://www.influxdata.com/blog/streaming-time-series-with-jupyter-and-influxdb/ . from influxdb import InfluxDBClient from datetime import datetime import…
deepika tiruvaipati
  • 11
  • 2
1
vote
2 answers

How to type hint object as `PointType` in Python aioinflux?

I have a dataclass similar to the one defined in the docs : from dataclasses import dataclass @lineprotocol @dataclass class Trade: timestamp: TIMEINT instrument: TAGENUM source: TAG side: TAG price: FLOAT size: INT …
KZiovas
  • 3,491
  • 3
  • 26
  • 47
1
vote
0 answers

What is the fastes batch_size for influxDBClient

I want to write a list of 1,000,000 datapoints to my influxDB. I use this command: client.write_points(listOfPoints[:1000000], batch_size=1000000) This returns Entity Error: InfluxDBClientError: 413: {"error":"Request Entity Too…
msba
  • 141
  • 1
  • 8
1
vote
0 answers

How to read influxdb backup data with Python (with pandas or other tool)

I have a data backup folder produced from an influxdb with the backup and restore utility. This produces a .tar.gz file as mentioned in the reference. I wish to open and process these data with Python (maybe pandas library or another python…
KZiovas
  • 3,491
  • 3
  • 26
  • 47
1
vote
1 answer

detect error on asynchronous write to influxdb using python influxdb_client

This is my code: write_api = client.write_api(write_options=ASYNCHRONOUS) write_api.write(bucket, org, data, write_precision=WritePrecision.US) 1 - How can I detect writing errors? 2 - Should I initialize write_api each time I want to write or I…
Rony Tesler
  • 1,207
  • 15
  • 25
1
vote
0 answers

Losing precision when reading out data from influxdb

I am using influxdb v2.0.9 with python and am wondering why values are not equal when reading them out again. I.e. I am writing a value 0.000007345345 into the db but when I read them out I get 0.0000073 and the other digits are cut off. I use the…
Martin S
  • 377
  • 3
  • 14
1
vote
0 answers

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
  • 11
  • 2
1
vote
1 answer

Why won't my custom Dockerfile connect over the docker-compose network when other services will?

The problem I am attempting to create a docker-compose file that will host three services. InfluxDB, Grafana, and a custom script in a customer Dockerfile that fills the database. I am having networking issues, and the custom script is not able to…
mmachenry
  • 1,773
  • 3
  • 22
  • 38
1
vote
0 answers

InfluxDB timestamps don't appear to use the provided timestamp

I am sending data to an InfluxDB database using the Python client library. The example given uses the time method from the Point class, which is supposed to allow for writing data with a provided timestamp rather than the data received time at the…
Hari
  • 157
  • 2
  • 12
1
vote
1 answer

Problem with inserting pandas dataframe into influxdb

I am trying to write data into influxdb and querying it to return the data but all I am getting is empty dataframe. I have used official influxdb documentation by creating a dataframe and writing and that works fine. But when I import a csv/pickle…
T2020
  • 61
  • 6
1
vote
1 answer

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 follows (my codebase is in Python): f = open(args.file,…
AbdelKh
  • 499
  • 7
  • 19
1
vote
2 answers

influxDB: How to convert field to tag in influxDB v2.0

We need to convert field to tag in influxDB v2.0 but not able to find any proper solution. Can someone help me out to achieve the same ? Solution we found was to create new measurement by altering fields and tags of existing measurement but not able…
Dhyanesh Naik
  • 41
  • 1
  • 5
1
vote
1 answer

Unable to access Influxdb web UI. It shows 404 page not found error

I have my influxdb working in server. When I try to open the influxdb UI using http://my_host:8086. I'm receiving 404 as response. What am I missing ? help me with this please.
Abilash K
  • 33
  • 1
  • 1
  • 8
1
vote
1 answer

Create Dockerfile for python application to read InfluxDB

I am having a simple python script to fetch data from a table in InfluxDB installed in the local system. The deviceStatus.py script is as shown import time import sys import influxdb from influxdb import InfluxDBClient client =…
Subhadeep Datta
  • 29
  • 5
1 2 3
…
14 15