Questions tagged [influxdb]

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

Links

2990 questions
23
votes
12 answers

How to install InfluxDB in Windows

I am new to InfluxDB. I could not find any details about installing InfluxDB on Windows. Is there any way to install it on a Windows machine or do I need to use a Linux server for development purposes?
Sajith
  • 2,842
  • 9
  • 37
  • 49
22
votes
3 answers

How to use a InfluxDB-tag value in a grafana legend?

I have a InfluxDB dataseries. It stores one information about mulitple machines. I distingsh between these machines with a tag. I can display the information for all three machines at once using a "Group by tag(machine)" clause. the name of the…
Michael K.
  • 423
  • 1
  • 4
  • 13
20
votes
5 answers

How to set default retention policy and duration for InfluxDB via configuration

I am using the official InfluxDB docker image. I want to set the retention policy to be 14 days by default. There are various ENV variables that I can set to change the config for InfluxDB, such as INFLUXDB_RETENTION_POLICY. This expects the name of…
Tutan Ramen
  • 1,234
  • 1
  • 8
  • 27
20
votes
3 answers

Inserting with a specific time?

I am looking through all the InfluxDB examples, and they all seem to insert with "time now" (time of insert). There is a well-defined "time" field, but none of the examples use it. Recording the time of an event as "insert time into the DB" is a…
Brian Bulkowski
  • 866
  • 1
  • 7
  • 10
19
votes
4 answers

How to use Distinct function in influxDB

I am using influx DB and issuing command, SELECT * FROM interface Below is the out put- interface time element path value 2016-08-24T21:22:16.7080877Z …
Ammad
  • 4,031
  • 12
  • 39
  • 62
19
votes
3 answers

How do I get consistent values with influxdb non_negative_derivative?

Using grafana with influxdb, I am trying to show the per-second rate of some value that is a counter. If I use the non_negative_derivative(1s) function, the value of the rate seems to change dramatically depending on the time width of the grafana…
Ben
  • 4,785
  • 3
  • 27
  • 39
19
votes
4 answers

select from InfluxDB where value is null

If my data (conceptually) is: # a b c ------- 1 1 1 2 1 1 0 3 1 0 1 Then in legacy SQL language, the statement would be: select * from table where b is null I cannot find a similar condition within the InfluxDB Query Language…
glasnt
  • 2,865
  • 5
  • 35
  • 55
19
votes
3 answers

How to delete columns of a series in InfluxDB

Is there any solution to remove a specific column of a series in InfluxDB? Its seems that this feature is not implemented. But does anybody have found any kind of trick to do that?
Darko P.
  • 567
  • 1
  • 4
  • 14
17
votes
3 answers

What are series and bucket in InfluxDb

While trying to understand different concepts of InfluxDb I came across this documentation, where there is a comparision of terms with SQL database. An InfluxDB measurement is similar to an SQL database table. InfluxDB tags are like indexed…
pvpkiran
  • 25,582
  • 8
  • 87
  • 134
16
votes
3 answers

What is the equivalent of SELECT in Flux Query Language?

What would be equivalent flux query for SELECT address, name FROM addresses ? (I am referring to FluxQL, the new query language developed by InfluxData) I didn't find a clear answer to this in the limited Flux Documentation present. Flux…
Sushovan Mandal
  • 1,027
  • 3
  • 13
  • 32
16
votes
3 answers

Failed to install golang.org/x/crypto/bcrypt

I trying install InfluxDB client. But installation failed. This is my trace: go get -u -v -x github.com/influxdb/influxdb/client github.com/influxdb/influxdb (download) ... git remote -v Fetching https://golang.org/x/crypto/bcrypt?go-get=1 [1] …
rusnasonov
  • 752
  • 2
  • 12
  • 23
16
votes
11 answers

Changing Grafana port

I currently have InfluxDB feeding dashboards in Grafana. I will eventually be deploying this stack on a server. However, the default port for Grafana is 80. I must change this port, but I don't know how. Can anyone help out? Thanks.
Eric Miller
  • 1,367
  • 4
  • 13
  • 20
15
votes
8 answers

influxdb data/table be downloaded as csv file?

Influxdb is a time series database which stores data and its attributes in the tables, commonly known as measurements. Can the tables in databases of influxdb be fetched to local system in csv format?
surya rahul
  • 833
  • 2
  • 14
  • 27
15
votes
3 answers

How to make a choice between OpenTSDB and InfluxDB or other TSDS?

They both are open source distributed time series databases, OpenTSDB for metrics, InfluxDB for metrics and events with no external dependencies, on the other OpenTSDB based on HBase. Any other comparation between them? And if I want to store and…
yang.leo
  • 153
  • 1
  • 1
  • 6
14
votes
6 answers

Grafana - InfluxDB 2 - Label/Alias data

I am in the processing of migrating my panels from using the SQL syntax (from InfluxDB version 1.X) to the new influx syntax (InfluxDB version 2). There is an issue with the labels of the data. It includes the attributes that I used to filter it.…
TheNiceGuy
  • 3,462
  • 8
  • 34
  • 64