flopp
February 3, 2019, 7:25pm
1
I would like to write to Influx every minute, so I don’t want to have a query but it doesn’t seem to work.
Is there a work around?
If I use a query and the batch doesn’t get any data in the query, it will not write anything to Influx.
flopp
February 3, 2019, 8:21pm
2
I found a way, but of course it is a bug so it didn’t worked.
opened 08:32PM - 20 Oct 17 UTC
status/long-term
(Also posted to https://community.influxdata.com/t/kapacitor-fill-seems-to-have-… no-effect-on-batch-queries/2825)
I’m trying to compute summary data over series data that may have gaps. I would like to fill with the previous value in case of gaps. My tickscript looks like this:
```
var SQL = '''SELECT "duration"
FROM "desktop_client"."default"."profiling_metrics"''''
var hour_batched = batch
|query(SQL)
.period(1h)
.every(1h)
.groupBy(*)
.align()
.fill('previous')
var hour_median = hour_batched
|median('duration')
.as('hour_median')
|influxDBOut()
.database('desktop_client')
.measurement('kapacitor_experimental')
```
Any value I use for .fill() (previous, 0, null, etc.) yields the same results, and hours with missing values in the original series are also missing data in the transformed series. I have tried putting ‘GROUP BY/FILL’ in the influx query as well, with no results.
rawkode
February 5, 2019, 12:45pm
3
Hi @flopp ,
Can you please provide an example with what you’re trying to accomplish?
If you want to write to Influx every minute, this should be handled by Telegraf or by implementing the write in the programming language of choice.
If you’re attempting to write from one measurement to another, you can use a continuous query.
flopp
February 5, 2019, 7:50pm
4
Thanks for reply.
These values I need to change historical.
Let’s say that I put in value 1.3 every minute to a field in a measurement for 7 days(now)
Would this be possible?
