[influxdb] standard deviation calculation using "sample" stddev rather that population

Hi All (again ;)) Some databases provide two different calcs of stddev (and variance); e.g. postgress: https://www.postgresql.org/docs/9.1/static/functions-aggregate.html both sample and pop available, Influx appears to use sample rather than population; is there a means by which this can be

[influxdb] Re: default retention policy gone from influxdb-1.0.0-beta1 but exists in influxdb-0.13.0, expected? bug

Found it. default has changed to "autogen" thanks! (and apologies) On Tuesday, 14 June 2016 13:51:01 UTC+10, ian lutz wrote: > > Hi there > > > the following works in 0.13.0 out-of-the-box and before > > CREATE CONTINUOUS QUERY down_sample_all_at_4320ms ON testdb BEGIN > SELECT mean(value_E

[influxdb] default retention policy gone from influxdb-1.0.0-beta1 but exists in influxdb-0.13.0, expected? bug

Hi there the following works in 0.13.0 out-of-the-box and before CREATE CONTINUOUS QUERY down_sample_all_at_4320ms ON testdb BEGIN SELECT mean(value_EIGAI) AS downsampled_4320ms_EIGAI, first(value_EIGSTR) AS downsampled_4320ms_EIGSTR, first(status) AS downsampled_4320ms_status

Re: [influxdb] How to list all container_image-s on a host ?

Hi Sean, Thanks for the quick reply! When I tried -> SELECT * from docker_container_net where time Response was -> *docker_container_net* timebuild-datecontainer_idcontainer_imagecontainer_namehostlicensename networkrx_bytesrx_droppedrx_errorsrx_packetstx_bytestx_droppedtx_errors tx_packetsvend

[influxdb] InfluxDBClientError: 400 in InfluxDB v0.13

I'm trying to collect data from a particular sensor, so I used the following code to retrieve the data. data = client.query("SELECT * FROM bmspoint WHERE time > now() - 10m AND name = 'B10_Area3for2_E_MtrEl6_PwrActv'") Although data does exist for this sensor in this particular time frame, I

Re: [influxdb] E: Unable to locate package python-influxdb

The python library is hosted by InfluxData but we do not maintain it. Have you tried opening an issue on the repo? On Mon, Jun 13, 2016 at 6:29 PM, kranthi sai wrote: > Hi, > >I am following the steps installing InfluxDB -Python. > > > Install, upgrade and uninstall InfluxDB-Python with thes

Re: [influxdb] Re: v13 influx and COUNT/aggregates; what are their time stamps and why is there data outside givn range

As you deduced, the calendar boundaries are round numbers. Days always start at 00:00 UTC, Hours start at xx:00 UTC, minutes start at xx:xx:00 UTC, etc. Any grouping in between starts at the initial boundary and adds from there. E.g. every four hours means 00:00 UTC, 04:00 UTC, 08:00 UTC, etc. The

Re: [influxdb] How to list all container_image-s on a host ?

SELECT , container_image FROM docker_container_net GROUP BY host You must have a field in the SELECT clause, but otherwise that will return the results. It will have massive duplication, though, since it will return the container_image for every point. Otherwise there's no great way to do it. Tag

Re: [influxdb] Unable to change admin user password

What version of InfluxDB? Have you tried using the CLI? On Mon, Jun 13, 2016 at 5:19 PM, Tanner Moore wrote: > I am pretty new to InfluxDB. I am currently trying to change the password > of my admin user and am having some trouble. > > I am trying to do this via curl and am getting conflicting

Re: [influxdb] Why aren't these queries working?

On Mon, Jun 13, 2016 at 12:14 PM, Michael Reed wrote: > Hi, > > Just starting off. I do a query and receive results (Yea!). > > But then I add to the WHERE clause, and don't get any results (Boo) > Your quoting syntax is off. It's not intuitive, but in queries string values must be single-quote

[influxdb] E: Unable to locate package python-influxdb

Hi, I am following the steps installing InfluxDB -Python. Install, upgrade and uninstall InfluxDB-Python with these commands: $ pip install influxdb $ pip install --upgrade influxdb $ pip uninstall influxdb I am getting the following error Reading package lists... Done Building dependen

Re: [influxdb] Re: v13 influx and COUNT/aggregates; what are their time stamps and why is there data outside givn range

Excellent thanks!! I think, I have managed to do what I wanted not without a little bit of faffary. I could not deduce exactly from the doc, where to "calendar" boundaries really are. I want to know the boundary before I make the query so i can calculate the offset and get the results I want:

[influxdb] How to list all container_image-s on a host ?

Hi There, I want to be able to list all images on a given host. So, I am trying the following query: SHOW TAG VALUES FROM "docker_container_net" WITH KEY IN ("container_image", "host") I would like to get this list per "Host". Anyway I can do this? Appreciate any help/pointers. Cheers! --

[influxdb] Unable to change admin user password

I am pretty new to InfluxDB. I am currently trying to change the password of my admin user and am having some trouble. I am trying to do this via curl and am getting conflicting information when querying the Influx API. $ curl -G 'http://localhost:8087/query' --data-urlencode "q=SHOW USERS"

[influxdb] Re: Storing Non-time related Data (Configuration Data) or data that rarely changes

I would argue that configuration data is time-related. I would keep a record of all configuration changes for auditing and a TSDB is a good place to put this info. It is simple to query for only the latest value. -- richard On Monday, June 13, 2016 at 7:57:52 AM UTC-7, brmu...@gmail.com wrote:

Re: [influxdb] How can we list nodes/hosts under a cluster from InfluxDB query?

Hi Sean, Thanks for your quick support! Yes, I had to restart the influxd and its all working now :) Cheers! On Thursday, June 9, 2016 at 8:47:06 AM UTC-7, Sean Beckett wrote: > > I believe you need to restart the process for any changes to the templates > to take effect. > > On Wed, Jun 8, 201

[influxdb] Why aren't these queries working?

Hi, Just starting off. I do a query and receive results (Yea!). But then I add to the WHERE clause, and don't get any results (Boo) Then I try an aggregate function, but only get results for COUNT() (Boo) What am I doing wrong? Thanks > SELECT * FROM meter_1 WHERE time >= '2016-06-13T10:48

Re: [influxdb] Inner join, in or how to filter on InfluxDb v 0.13

There are no inner joins in InfluxDB. Your proposed schema is very RDBMS-like, and won't work with InfluxDB. If you want some advice on how to construct your schema, please send some details of your data to the mailing list. On Fri, Jun 10, 2016 at 12:25 PM, Claudio Heidel wrote: > Hello guys, a

Re: [influxdb] Storing Non-time related Data (Configuration Data) or data that rarely changes

Overwriting the point with new values will ensure you have only one set of values at a time. It is not standard practice to record values in InfluxDB like this, but it should work. On Mon, Jun 13, 2016 at 8:57 AM, wrote: > I'm using influxDB as my datastore for a grafana dashboard. There are som

Re: [influxdb] How to exclude certain values with query

SELECT * FROM win_disk WHERE instance != 'HarddiskVolume1' https://docs.influxdata.com/influxdb/v0.13/query_language/data_exploration/#the-where-clause On Mon, Jun 13, 2016 at 7:29 AM, Willem D'Haese wrote: > Hello, > > How can I exclude disk metrics from win_disk where the value of 'instance >

Re: [influxdb] Filter measurements by tag property existing in other measurement - please help me

There are no JOINs in InfluxDB 0.9+. Instead, all series under a given measurement are automatically merged and are only separated by explicit filters in the WHERE or GROUP BY clauses. There is no way to perform cross-measurement math or grouping. All related data must be under one measurement in

Re: [influxdb] influxdb.conf

The 0.13 docs have every current configuration option listed. Anything not mentioned there can be deleted, I believe. The ones that have no match in the 0.13 docs are legacy settings from prior versions and can safely be deleted. On Sat, Jun 11, 2016 at 2:28 AM, Willem D'Haese wrote: > Hello, >

[influxdb] Re: using kapacitor to track incident duration?

I jotted down some of my ideas here https://github.com/influxdata/kapacitor/issues/643 On Monday, June 13, 2016 at 11:19:45 AM UTC-6, nath...@influxdb.com wrote: > > You are right that elapsed can't do what you want directly. In the > meantime the simplest solution would be to use a UDF, a simp

[influxdb] Re: using kapacitor to track incident duration?

You are right that elapsed can't do what you want directly. In the meantime the simplest solution would be to use a UDF, a simple python script could easily do what you want. You have me thinking though so if I can think of a non UDF solution I'll let you know. On Saturday, June 11, 2016 at 11

[influxdb] Re: Kapacitor deadman task not reporting state-change to "OK"?

On Friday, June 10, 2016 at 4:26:25 PM UTC-6, lp.j...@gmail.com wrote: > > Okay, in way that makes sense. > I have been trying to capture the ALIVE event but so far it eludes me. > Probably because I do not fully understand what I am looking at in the > output, nor how this works under the hood

[influxdb] Re: Kapacitor "invalid field type: string" error

The ability to perform string processing on fields is now fully supported in Kapacitor v0.13.1 and greater. On Sunday, June 12, 2016 at 8:49:07 AM UTC-6, oz. wrote: > > Same thing here. I would like to setup alerts based on a specific count of > log messages. > > Le jeudi 28 avril 2016 22:33:42

[influxdb] Re: Kapacitor: How to limit alerting by specific time range?

The beta is better than 0.13.1 so if you were using 0.13.1 go ahead and upgrade. On Monday, June 13, 2016 at 4:39:10 AM UTC-6, elad@adk2.com wrote: > > Upgraded to the beta and it works great. > Would you suggest installing this beta on production? OR wait for the > stable release.. > > Thx

[influxdb] Storing Non-time related Data (Configuration Data) or data that rarely changes

I'm using influxDB as my datastore for a grafana dashboard. There are some things that I want to be able to display that are not time related, and all the supported datastores are TSDB, so please don't just suggest using a different DB. Anyway, I would like to store some configuration data in my

[influxdb] How to exclude certain values with query

Hello, How can I exclude disk metrics from win_disk where the value of 'instance is "HarddiskVolume1" Whatever I try I cannot find the correct query. Please advi

[influxdb] Filter measurements by tag property existing in other measurement - please help me

Hi guys, I'm looking for the best solution to the follow problem: I have 2 measurements, one with the values and users_activity tag and other with the users_groups: *users_activity:* time, value, username, more_tags, more values... *users_groups:* time, user_name, users_group (every user coul

[influxdb] Re: Kapacitor: How to limit alerting by specific time range?

Upgraded to the beta and it works great. Would you suggest installing this beta on production? OR wait for the stable release.. Thx, Elad On Thursday, June 9, 2016 at 7:33:10 PM UTC+3, nath...@influxdb.com wrote: > > Looks like I was wrong that error is fixed in 1.0.0-beta1 and still > present