Stack Overflow
Stack Overflow

Questions tagged [influxql]

Use this tag for questions related to InfluxQL, an SQL-like query language for interacting with data in InfluxDB.

219 questions
0
votes
1 answer

"Transactional safety" in influxDB

We have a scenario where we want to frequently change the tag of a (single) measurement value. Our goal is to create a database which is storing prognosis values. But it should never loose data and track changes to already written data, like changes…
ThoPaz
  • 174
  • 9
0
votes
1 answer

Subtract two count values with different where clause in influxDb

I have a measurement in influxDb with two keys: operation and count. The operation key can store two different values: 'add' and 'delete'. I want to subtract the sum(count) value when operation='delete' to sum(count) value when operation='add'. The…
bunny
  • 115
  • 1
  • 9
0
votes
1 answer

Can't delete series with binary tag

I accidentally inserted a tag with some single quotes in them in a series: > show series key --- sensor,boardid=b'5ddd2d00' sensor,boardid=living_room and I can't get rid of them. I've tried drop series from sensor where…
bart van deenen
  • 661
  • 6
  • 16
0
votes
1 answer

Measure failed SMTP logins with Telegraf and InfluxDB

There is a lot of questions about the root of the problem without answers so I would like to specify my problem a little deeper to hopefully get some ideas about how can I achieve it. Warning: InfluxDB newbie is here so please bear with me. So, my…
Gabor Garami
  • 1,245
  • 8
  • 26
0
votes
1 answer

How to select the current database in InfluxDB

How can I get the current database name in Influx? For example, we use SELECT DATABASE(); in MySQL to get the db. Do we have any similar function in Influx?
Surajit Kundu
  • 455
  • 1
  • 7
  • 17
0
votes
1 answer

Not able to retrieve a column from Influx database

I am using sprigboot and influx client :https://github.com/influxdata/influxdb-java I am facing a problem where i am trying to get specif column from the influx db but i am not able to get any record when i am putting column name in the query .But,…
Rohitesh
  • 1,514
  • 7
  • 28
  • 51
0
votes
1 answer

Combine LAST with DISTINCT or GROUP BY?

I have a simple time series like this: time id area 2019-09-25T17:21:00Z 1 us 2019-09-25T17:22:00Z 1 uk 2019-09-25T17:23:00Z 2 canada 2019-09-25T17:24:00Z 3 …
Dave Slinn
  • 435
  • 6
  • 13
0
votes
2 answers

How to delete the field from measurment Influxdb

I am doing POC on influx db and i can see that if i am trying to drop measurement then all the data from the measurement has been deleted bu the old fields still remains there. I want to delete the old fields how i can do this ?
Rohitesh
  • 1,514
  • 7
  • 28
  • 51
0
votes
2 answers

Distinguish tags from fields in InfluxDB "SELECT *" results

Assume you're given an InfluxDB measurement you haven't seen before and you run, SELECT * FROM measurement How can you tell which of the keys returned are tags, and which are fields? The InfluxDB shell sorts the keys alphabetically, so unlike the…
Dan Dascalescu
  • 143,271
  • 52
  • 317
  • 404
0
votes
1 answer

Sum of field with where condition of this field - Influxdb

I want to get the sum of result_code where result_code=0. What I found is that querying without sum gives me result but adding the aggregation sum() and then I have 0 as a result. For those who want an understanding of the use case : I use telegraf…
Jérôme B
  • 311
  • 5
  • 18
0
votes
2 answers

Modifying the series data using flux language in influx

I have a function which takes the 1st value from a masurement every 5mins. ever5Mins1st = from(bucket: "Historian/oneday") |> range(start: dashboardTime) |> filter(fn: (r) => r._measurement == "InventoryStock" and r._field =="Value" …
Simsons
  • 12,295
  • 42
  • 153
  • 269
0
votes
1 answer

Writing to Influx DB results points beyond retention policy dropped=1

I am trying to test continuous queries as per influx example. I am trying to create the measurement with following data. insert bus_data,passengers=5 complaints=8 1557187200 insert bus_data,passengers=8 complaints=8 1557188100 insert…
Simsons
  • 12,295
  • 42
  • 153
  • 269
0
votes
1 answer

InfluxDB query using regular expression is not working

I am using InfluxDB and have below mention data in measurement against field…
Ammad
  • 4,031
  • 12
  • 39
  • 62
0
votes
1 answer

InfluxDB schema design - need only summation of thousands of time series data

I am very new to InfluxDB. I am writing a program to monitor electricity usages from 13,000 homes' electric meters located in 11 districts. The data will be used for a reporting program that mostly cares only the total usages from the 11 districts.…
Dustin Sun
  • 5,292
  • 9
  • 49
  • 87
0
votes
1 answer

How can I compare current value in my stream with previous value in tickscript?

I am working on kapacitor alerts to generate alerts on data in influxDB. I am receiving a new value from the stream when a request has been made. I want to compare the current value in my stream I received with the previous value I received just…
Karthik Gullapalli
  • 53
  • 2
  • 10
1 2 3
…
14
15