Stack Overflow
Stack Overflow

Questions tagged [influxdb]

InfluxDB is an open-source time series, events, and metrics database written in Go, with no external dependencies.

Links

2990 questions
7
votes
1 answer

InfluxDB Flux - Filter where field matches value

I'm using InfluxDB with Grafana, and I have a measurement called items with some tags and a field called itemType. I need to filter for rows where itemType is a certain string. The following InfluxQL query does exactly what I need: SELECT * FROM…
APixel Visuals
  • 1,508
  • 4
  • 20
  • 38
7
votes
2 answers

how to hide the "time" column in the table when use Grafana with influxes

When I use table visualisation in Grafana with InfluxDB, the table panel always shows the time column, but I do not want it. So how can I achieve this? I have searched similar questions on StackOverflow, but could not find any answer. My query does…
myd620
  • 111
  • 1
  • 1
  • 5
7
votes
1 answer

interval vs flush_interval in telegraf

I have a following telegraf configuration [agent] interval = "5s" round_interval = true metric_batch_size = 1000 metric_buffer_limit = 10000 collection_jitter = "0s" flush_interval = "5s" flush_jitter = "0s" precision = "" debug =…
flashburn
  • 4,180
  • 7
  • 54
  • 109
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

How can InfluxDB be used as Spark Source

How can an InfluxDB database (which has streaming data coming in) be used as Source for Spark Streaming ? Also, Is it possible to use InfluxDB instead of SparkSQL for performing computations on datasets ?
Mark B.
  • 329
  • 2
  • 16
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
7
votes
1 answer

InfluxDB "GROUP BY time" shifts time

I'm having a problem thats limiting me quite a bit. We are trying to sample our data by grouping time. We have millions of points and want to fetch every Nth point in a given interval. We have implemented a solution that calculates the time…
Firas Dib
  • 2,743
  • 19
  • 38
7
votes
3 answers

influxdb: calculating duration of boolean events?

I have data in an influxdb database from a door sensor. This is a boolean sensor (either the door is open (value is false) or it is closed (value is true)), and the table looks like: name: door -------------- time …
larsks
  • 277,717
  • 41
  • 399
  • 399
7
votes
2 answers

InfluxDB Line Protocol Bad Timestamp

I'm trying to POST this data: my_tests,SNR=533033200650344358002D00,TNR=test HelloWorld=123 1495179651177999872 my_tests,SNR=533033200650344358002D00,TNR=test HelloWorld=444 1495179651203000064 The POST Url looks like…
lapsus
  • 2,915
  • 2
  • 32
  • 61
7
votes
1 answer

Query InfluxDB for specific hours every day

What is the best way to query InfluxDB for specific hours every day, for example, I have a Series that have checkin/checkout activities, and I need to see them between hour 2PM - 3PM every day for last month, am aware that there's no direct way to…
Abdullah Shahin
  • 1,002
  • 15
  • 19
7
votes
2 answers

How do I query InfluxDB to show me current time and date?

I couldn't find much documentation on this. How do I query InfluxDB to show me current database system time and date?
Tracy Ann Monteiro
  • 213
  • 3
  • 7
  • 14
7
votes
3 answers

How to create database and user in influxdb programmatically?

In my use case I am using single ec2 instance [not a cluster]. I want to create a database and an user with all privileges programmatically? Is there a config file which I can edit and copy to the right location after influxdb is installed. Could…
Dany
  • 2,692
  • 7
  • 44
  • 67
7
votes
2 answers

Selecting a backend database for Grafana

Graphite, Elastisearch, Cloudwatch, Prometheus, InfluxDB are all supported backends for Grafana. I am creating an application with grafana front-end, but an not being able understand how these backends differ and which would be the best to use for…
Aditya Kotwal
  • 101
  • 2
  • 5
7
votes
1 answer

Influxdb Move Copy data between databases within Influxdb

I have my_db1, my_db2, my_db3 in Influxdb, now is there a way to move or copy data between these databases with a query?
gitvegas
  • 101
  • 1
  • 2
  • 4
7
votes
2 answers

influxdb python: 404 page not found

I am trying to use the influxdb-python lib which I found here. But I cant even get the tutorial programm to work. When I run the following example code: $ python >>> from influxdb import InfluxDBClient >>> json_body = [ { …
IIIIIIIIIIIIIIIIIIIIII
  • 3,958
  • 5
  • 45
  • 70
1 2 3
…
99 100