Stack Overflow
Stack Overflow

Questions tagged [influxdb-python]

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

215 questions
8
votes
2 answers

How to retrive more than 10k lines from InfluxDB using Pandas?

I am trying to use InfluxDB's Python client's to retrieve data stored on InfluxDB, but can't more than 10k lines. The examples I am (unsuccessfully) following are here. In summary: import influxdb dfclient = influxdb.DataFrameClient('localhost',…
Gustavo Bezerra
  • 9,984
  • 4
  • 40
  • 48
7
votes
1 answer

How send proper timestamp to influxdb with influxdb-python

I have influxdb database test with measurement: name: mes1 time Amount Buy_order_id Price ---- ------ ------------ ----- 1529832177822 0.02294 132868375 130117.83 I would like to make graph in Grafana, but…
dorinand
  • 1,397
  • 1
  • 24
  • 49
7
votes
0 answers

Coalesce / dynamic WHERE clause with InfluxDB

I would like to create a dynamic WHERE clause in my SELECT statement. Looking through Google results and the InfluxDB documentation, I cannot find any mention of COALESCE or any equivalent/reasonable way to achieve this purpose. What would be the…
Christian Neverdal
  • 5,655
  • 6
  • 38
  • 93
6
votes
1 answer

Influx DB precision setting at DB Level

Extension of #8746 : I have tried to set the precision in the config file as seconds. But as i write data and tries to fetch it its again showing Nanoseconds timestamp. I read the whole Doc but couldn't figure it out only change in my config file…
Appunni M
  • 83
  • 3
  • 9
5
votes
1 answer

InfluxDB write points with same timestamp but different measurement

Requirement: I want to create an influxDB database to store time-series data from multiple sensors reporting temperatures from different locations. Problem: When I write points to the database with same timestamp but different tags (example :…
Raj Muruges
  • 75
  • 2
  • 8
4
votes
1 answer

flux query very slow in compare to InfluxQL (10x slower)

I'm upgrading form influx1.x to influx2.x (updating queries from influxQL to Flux syntax). For very simple queries, performance drops dramatically when I try to query more than 500,000 points and I'm not sure if there's anything I can do to improve…
Ali Ajouz
  • 61
  • 3
4
votes
1 answer

How to get column names of a table in influxdb

I am trying to work with a database that I barly know and I need to know column names of a table: Here is what I tried: client = DataFrameClient(host, 8086, username, password,…
Abolfazl
  • 1,047
  • 2
  • 12
  • 29
4
votes
1 answer

Dump series back into InfluxDB after querying with replaced field value

Scenario I want to send data to an MQTT Broker (Cloud) by querying measurements from InfluxDB. I have a field in the schema which is called status. It can either be 1 or 0. status=0 indicated that series has not been sent to the cloud. If I get an…
Shan-Desai
  • 3,101
  • 3
  • 46
  • 89
4
votes
1 answer

Query builder for InfluxDB?

What is the preferred way of properly building InfluxDB queries in Python? (I have been looking for a proper InfluxDB query builder. The ones I've found are either old/outdated or can't really generate valid queries for InfluxDB.)
Christian Neverdal
  • 5,655
  • 6
  • 38
  • 93
4
votes
2 answers

influxdb: Write multiple points vs single point multiple times

I'm using influxdb in my project and I'm facing an issue with query when multiple points are written at once I'm using influxdb-python to write 1000 unique points to influxdb. In the influxdb-python there is a function called…
HaggarTheHorrible
  • 7,083
  • 20
  • 70
  • 81
3
votes
1 answer

SSL certificate expired error for influxdb-client

I have a windows 10 machine, and I am not sure what the problem is, I was able to run everything until a few hours back and now I keep running into SSL certificate Expired error for some reason. Steps to reproduce: This is my code. ''' ''' from…
SAK
  • 169
  • 2
  • 11
3
votes
1 answer

Get list of Measurements with Influx 2

I'm having trouble understanding how to use some InfluxDB 2 APIs from Python, using the influxdb-client-python library for InfluxDB 2 For example I would like to get a list of measurements in a bucket. Official documentation (not Python) suggest…
mattewre
  • 91
  • 2
  • 6
3
votes
1 answer

Use Influxdb client in python - Error : 'InfluxDBClient' object has no attribute 'create_database'/' get_list_database '

I just started using the influxdb client in python. I'm probably doing something wrong but I can't figure it out yet. from influxdb import InfluxDBClient, DataFrameClient client=InfluxDBClient(host="localhost",port="8086",…
the phoenix
  • 641
  • 7
  • 15
3
votes
0 answers

database "telegraf" creation failed: Post "http://influxdb:8086/query": dial tcp 172.31.0.2:8086: connect: connection refused

I installed four containers in my ec2 instance and every container is running fine. One of the containers in Telegraf and another one in influxdb. So I am trying to write the data from Telegraf to Influxdb and in Telegraf is coming from the AWS…
Ravi kant Gautam
  • 333
  • 2
  • 23
3
votes
1 answer

How to dynamically initialize an object within an inner class in Python 3?

I am leveraging the SeriesHelper object of InfluxDB library(please have a look at https://influxdb-python.readthedocs.io/en/latest/examples.html#tutorials-serieshelper) to push set of data points to InfluxDB. The SeriesHelper class has to be…
Ashwin Kanna
  • 75
  • 1
  • 6
1
2 3
…
14 15