Stack Overflow
Stack Overflow

Questions tagged [influxdb-python]

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

215 questions
2
votes
0 answers

InfluxDB SELECT query on multiple MEASUREMENT with different fieldType

I have an influxDB testdb where, I am trying a SELECT query on 4 different measurements with different fieldtype.I am able to query more than one measurements successfully but when it comes to combining multiple measurements with different…
harvpan
  • 8,571
  • 2
  • 18
  • 36
2
votes
0 answers

InfluxDB - Kapacitor udf timeout

I am trying to get data from InfluxDB inside a kapcitor udf written in Python using InfluxDBClient. I am able to get data in case the size is very small like 2000 records, but as soon as the size of data goes beyond that it starts failing with below…
user4981009
  • 41
  • 3
2
votes
0 answers

Influxdb does not close TCP connections

I connecting to my influxdb (1.1.1.1:8086) from my pc (2.2.2.2) to perform some queries. I find out, my server keeping the connections opened: netstat -tpn | grep 8086 tcp6 0 0 1.1.1.1:8086 2.2.2.2:50839 ESTABLISHED…
dorinand
  • 1,397
  • 1
  • 24
  • 49
2
votes
0 answers

getting a unexpected EOF error when running a udf in kapacitor

i wrote a simple udf for kapacitor that is basically changing one of the filed values,should be very simple and straightforward. when i run it i get an error like so : ts=2018-06-07T10:56:52.957Z lvl=error msg="node failed" service=kapacitor…
David Gidony
  • 1,243
  • 3
  • 16
  • 31
2
votes
0 answers

How to post CSV file data into the InfluxDB server in same time series as CSV File's time series?

I would like to post data from a CSV file to InfluxDB file and the Time column of InfluxDB should match with CSV file Time column. I meant InfluxDB time series should same as CSV file's Time series. My main motive is InfluxDB should store the data…
Prayuktibid
  • 189
  • 1
  • 9
2
votes
1 answer

How to export large number of rows from InfluxDB to CSV using python client?

I am trying to export a large number of rows (160.000.000+) from influxDB to a csv file. So far i am just blowing up the memory on the machine that runs the query. I am lost on how i could export this amount of rows without blowing the memory of the…
Marco
  • 15,101
  • 33
  • 107
  • 174
2
votes
1 answer

Import csv data into influxdb from python

This has almost certainly been asked. I have timeseries data that looks like this in a .csv file. The data has no heading, but this is what the different fields are:…
Ivan
  • 7,448
  • 14
  • 69
  • 134
2
votes
0 answers

Unable to get influxdb-python client to work

Environment: Platform is Ubuntu 16.10. influxdb v1.2.0 influxdb-python v4.0.0 I can connect to the server and perform queries with the influx client, with no problem. I can perform queries using POSTman. However, when I try any of the…
TomK
  • 362
  • 2
  • 10
2
votes
1 answer

Is there a correct way to use parameters in a SQL injection safe way with the InfluxDB python client, much like the mogrify function in psycopg?

Is there a correct way to use parameters in a SQL injection safe way with the InfluxDB python client, much like the mogrify function in…
André C. Andersen
  • 8,955
  • 3
  • 53
  • 79
2
votes
1 answer

Inserting data into Influxdb using Python client with Line protocol

I am using InfluxDb and have simple line protocol line as shown below: cpu,atag=test1 idle=100,usertime=10,system=1 I have python client using dictionary as shown below client = InfluxDBClient(host, port, USER, PASSWORD,…
Ammad
  • 4,031
  • 12
  • 39
  • 62
1
vote
1 answer

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 influxdb_client.client.write_api import…
myquest5 sh
  • 63
  • 6
1
vote
1 answer

odd result when ingesting dataframe into influxdb 2.x

I'm using python to ingest data into influxdb, but many examples just don't work (empty table, but no error reported), and one example with odd result. With client set, I create dataframe by: from datetime import datetime from datetime import…
Gusty2000
  • 13
  • 3
1
vote
1 answer

How can I use the Python client library for influxdb to for queries? (InfluxDB OSS v1.8.10)

I learned how to download the client library and write to influxdb databases in influxdb OSS v1.8 at this link: https://docs.influxdata.com/influxdb/v1.8/tools/api_client_libraries/#install-and-use-the-python-client-library but I can't find out how…
Luis Davila
  • 31
  • 4
1
vote
0 answers

Influxdb 2.2 has 'm' after numbers

I have noticed that some of my values in InfluxDB 2.2 have an 'm' character appended to their value. Is there a way to stop this from happening? I am writing my values as floats to the database. This seems to occur for seemingly random values in my…
Joe Schroedl
  • 21
  • 1
  • 4
1
vote
1 answer

InfluxDB field values mixed from another measurement

I'm sending data into influx-DB 1.8 OSS, which has 2 measurements. In that one measurement got mixed field values from another measurement. Eg: measurement 1 field: Apple, Banana, Grapes, Orange Measurement 2 field: Potato, Cucumber, Onion,…
sreevalsan
  • 33
  • 5
1 2
3
…
14 15