Stack Overflow
Stack Overflow

Questions tagged [influx-line-protocol]

27 questions
2
votes
1 answer

Issue writing from Influx Line Protocol to QuestDB

My problem is that I cannot wrote data to Quest DB with Influx Line Protocol (ILP) is I have an already created table with a schema. If I have an empty table (i.e. with no schema) then I can do the schema and the schema is auto-created. My questions…
Newskooler
  • 3,973
  • 7
  • 46
  • 84
1
vote
0 answers

Data persistence in InfluxDB, using influxdb3

While persisting data in influx-db, there is a column name Time which is managed by influx itself. By default the format in which time stored is 2023-08-29T07:43:46.872Z I am trying to store the timestamp in Unix format, which is not happening. I am…
kshitiz raj
  • 23
  • 3
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
0 answers

InfluxDB different results with different time ranges

Due to a wrong retention setting I’ve lost a whole month of data (November 2022). As I have the data in another system, I’ve used the “Load Data” → “Line Protocol” → “Write Data” functionality in order to write the lost data points back into the…
Daniel
  • 1,179
  • 4
  • 18
  • 31
1
vote
2 answers

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 mes1 id=1,event="end" 1655885519 mes1 id=2,event="start"…
gaout5
  • 69
  • 1
  • 7
1
vote
0 answers

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 to /api/v2/write, adding the auth token and org…
Michael
  • 1,416
  • 1
  • 9
  • 21
1
vote
1 answer

How do I insert multiple points in Influx with the lineprotocol and API

According to the documentation the influx line protocol accepts \n to separate lines. I have a request in Postman on Windows http://127.0.0.1:8086/api/v2/write?precision=ms&bucket=Test&org=Test with required headers that works just fine with this…
noontz
  • 1,782
  • 20
  • 29
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

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
0
votes
0 answers

Pushing Data To Influx DB From The Command Line Invalid Number Error

I have some iot data in csv format that I would like to push into InfluxDb. I am using influx write from the command line, but I am getting a parsing error back. The command I'm running is influx write -b iotData \ -f data.csv \ --header…
CHEESE
  • 15
  • 2
0
votes
0 answers

unable to write data in influxdb

I am trying to write data in influxdb as below based on influx write /home/test-code>influx write --bucket bucketsha " > m,host=host1 field1=1.2,field2=5i 1640995200000000000 > m,host=host2 field1=2.4,field2=3i 1640995200000000000 > " Please provide…
myquest5 sh
  • 63
  • 6
0
votes
1 answer

influx write command is throwing error: "unsupported protocol scheme"

I have exported my data from an InfluxDB bucket with the following command: > influxd inspect export-lp --bucket-id d5f80730ede82d67 --engine-path ~\.influxdbv2\engine --output-path ~\Desktop\my-data.lp.gz --start 2022-11-01T00:00:00Z --end…
varad_s
  • 764
  • 1
  • 12
  • 24
0
votes
0 answers

Setting the RAM limit for the influxdb write process

The python influx client use too much ram during the writing process. Since we do not have access to the influxdb config we need to improve this in python directly. I tried to optimize it using different settings for batch_size, flush_interval,…
Ali Ajouz
  • 61
  • 3
0
votes
0 answers

Error in plugin: Invalid JSON provided, unable to parse

I'm using docker to bring up Telegraf,InfluxDB,Grafana. I'm using amqp_consumer input plugin in Telegraf conf file. I'm getting the error E! [inputs.amqp_consumer] Error in plugin: Invalid JSON provided, unable to parse. I have enabled debug level…
Prajyod Kumar
  • 395
  • 2
  • 4
  • 15
0
votes
1 answer

Send HTTP POST request to InfluxDB manually with browser

Hello, I'm currently using grafana to visualize data from InfluxDB, and would like to use a hyperlink in form of a HTTP request from a dashboard to insert data into the database. Is something like this possible?
OD-OD
  • 1
1
2