Re: [influxdb] No data on subscription

Hi Ross, Thanks... I think I figured out what I did wrong. When I initially defined the "task" I incorrectly added the -dbrp "ion.defualt" **Note incorrect spelling Since I am setting the retention policy in the task itself, I assume I should not add the -dbrp option, but it seems that is req

[influxdb] Cardinality: applies only to tag-value combination used, or all possible combinations?

I've searched for an answer to this specific question, but turned up nothing specific. Is series cardinality affected by actual use, or by combinatorial math alone? For example: metric,asset_id=abc,geohash=gbsuv7ztq metric,asset_id=xyz,geohash=gbsuv7ztr ... in this schema, a series will have

Re: [influxdb] No data on subscription

What versions of both InfluxDB and Kapacitor are you running? And are you sure points are being written to the `ion` database? What does the output of a `kapacitor show test` look like? Thanks, Ross On Tue, Aug 9, 2016 at 2:15 PM, Kristopher Cieplak wrote: > I cannot seem to get any data from

Re: [influxdb] Influx Query for an specific times instead of field values

Thank you for your answer. I just read the documentation and it is crystal clear. I am using the InfluxDB v0.12.2, and I am getting a Zero timestamp: Select Max(Pmax) from Test0 *Test0* timemax1970-01-01T00:00:00Z 36608 It is time to upgrade, I hope it works in the last version 0.13. El m

[influxdb] No data on subscription

I cannot seem to get any data from influxdb to kapacitor via the subscription. I have confirmed that I can get data to the kapacitor server, and create a bad data over the connection. ** On influxdb node echo foobar | nc -u 10.0.36.176 37661 ** On kapacitor node [udp:ion.default] 2016/08/09 1

Re: [influxdb] snmp multiple network equipments

The Telegraf SNMP plugin is under heavy redesign currently. I encourage you to be part of the discussion. https://github.com/influxdata/telegraf/pull/1389 https://github.com/influxdata/telegraf/pull/1573 On Thu, Aug 4, 2016 at 8:56 PM, João Martins wrote: > > Hi, > can I use telegraf to monitor

Re: [influxdb] Influx Query for an specific times instead of field values

Issue: SELECT MAX (value) FROM foo WHERE... That will return the maximum value AND the timestamp of the point with the maximum value. On Thu, Aug 4, 2016 at 1:38 AM, Joaquin Rus Pezzi wrote: > I want to learn the *specif

Re: [influxdb] Data from Oracle db

As far as I am aware, there is no bulk export/import from Oracle. Convert it to line protocol and send it to the HTTP endpoint, or convert it to CollectD, OpenTSDB, or Graphite formats and write it to those endpoints. On Wed, Aug 3, 2016 at 10:38 PM, Raj wrote: > Hi, > > How to get data from O

Re: [influxdb] Newbie: Query on TAGs with multiple measurements

The FROM clause should restrict the return results to only the tag values existing on that measurement. If that's not what you are getting, please open a bug report . Perhaps I misunderstood your question? On Wed, Aug 3, 2016 at 3:36 PM, Catalin

Re: [influxdb] Visualize data from InfluxDB in real-time using Grafana

You can monitor the CPU and RAM needs of the machine for stress from the queries. Without knowing the shape of your data and the actual queries, it's hard to predict what load the hardware could sustain. On Wed, Aug 3, 2016 at 1:09 PM, wrote: > Hello! > > I am new to InfluxDB/Grafana and have a

Re: [influxdb] Select not null values

Use regular expressions: SELECT V3 FROM data WHERE V3 =~ /.*/ On Wed, Aug 3, 2016 at 8:35 AM, wrote: > There is a "not null" statement in inlux query language? SOmething like: > > SELECT V3 from data where V3 is not null > > Thanks > > -- > Remember to include the InfluxDB version number with a

[influxdb] Re: [Kapacitor] how to find sum of top 3 values

Your example is basically right, here is a complete working example: var data = stream |from() .measurement('m') .groupBy('a', 'b', 'c') |window() .period(10s) .every(10s) |top(3, 'field') |sum('top') |alert() .crit(lambda: "sum" == 0)

[influxdb] [Kapacitor] how to find sum of top 3 values

i want to find the sum of top 3 values from the stream of data, how can it be done? i am looking something like, var data = stream |from() .measurement('measurement1') .groupBy('a','b','c') |top(3,"field") |sum("