Hello, The problem came from my side in my stick script .
Thank you to the team of Influx for their good job. wug Le mercredi 31 août 2016 08:39:38 UTC+2, wug a écrit : > > Hello. > > Thank you for the answer. It seems to work. Nevertheless, when I try to > record and replay kapacitor on historical data, it just records the > current day, although I put -past 2w. I tried also with -start -end, But it > is the same. > What is the problem? > > wug > > Le lundi 29 août 2016 17:10:06 UTC+2, [email protected] a écrit : >> >> You have two options. >> >> 1. Window the data in RAM on the Kapacitor host >> >> forecasteec >> >> |join(real) >> >> .as('forecasteec', 'real') >> >> |eval(lambda: abs( "forecasteec.value" - "real.value")) >> >> .as('diff') >> >> |window() >> >> .period(1d) >> >> .every(1d) >> >> |sum('diff') >> >> >> But this requires that you can buffer 24 hours of data in RAM which is >> probably not feasible >> >> >> 2. Write the intermediate data to InfluxDB and then query it back out to >> sum it over 24 hours later. >> >> >> >> forecasteec >> >> |join(real) >> >> .as('forecasteec', 'real') >> >> |eval(lambda: abs( "forecasteec.value" - "real.value")) >> >> .as('diff') >> >> |influxDBOut() >> >> .database('diff_data') >> >> .measurement('diff') >> >> .precision('s') >> >> >> >> batch >> >> |query(''' SELECT sum("diff") FROM "diff_data"."default"."diff" ''') >> >> .period(1d) >> >> .every(1d) >> >> .align() >> >> |... >> >> >> The second option is essentially the same as the first except you are >> using InfluxDB as the buffer so that you don't have to keep it all in RAM. >> >> On Monday, August 29, 2016 at 6:39:42 AM UTC-6, wug wrote: >>> >>> >>> >>> Hello, >>> >>> >>> >>> I want to use Kapacitor in order to do more complex computation on my >>> data. I create a task with the type batch. I put 2 queries in to variable >>> forecasteec and real . I want to compute a type of error which is: >>> >>> >>> error = sum( abs( real - forecasteec))/sum(real) >>> >>> >>> The sum is for one day. The first part is easy. But I do not know how do >>> the sum on 1 day. I have data each 15 min. >>> >>> >>> What is the best way to do that? I am completly on Kapacitor. I am using >>> the version 0.13 >>> >>> >>> Here the first part: >>> >>> >>> * 21 forecasteec* >>> >>> * 22 |join(real)* >>> >>> * 23 .as('forecasteec', 'real')* >>> >>> * 24 |eval(lambda: abs( "forecasteec.value" - "real.value"))* >>> >>> >>> >>> wug >>> >>> >>> >>> >>> >>> -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/52b5c106-c3c0-4abc-9e49-228905f2209b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
