{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/4819","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/4819/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/4819/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/4819/events","html_url":"https://github.com/influxdb/influxdb/issues/4819","id":117349542,"number":4819,"title":"[0.9.5-rc3] Is 1 second default unit for non_negative_derivative and derivative function?","user":{"login":"mahadeva604","id":6159814,"avatar_url":"https://avatars.githubusercontent.com/u/6159814?v=3","gravatar_id":"","url":"https://api.github.com/users/mahadeva604","html_url":"https://github.com/mahadeva604","followers_url":"https://api.github.com/users/mahadeva604/followers","following_url":"https://api.github.com/users/mahadeva604/following{/other_user}","gists_url":"https://api.github.com/users/mahadeva604/gists{/gist_id}","starred_url":"https://api.github.com/users/mahadeva604/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mahadeva604/subscriptions","organizations_url":"https://api.github.com/users/mahadeva604/orgs","repos_url":"https://api.github.com/users/mahadeva604/repos","events_url":"https://api.github.com/users/mahadeva604/events{/privacy}","received_events_url":"https://api.github.com/users/mahadeva604/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdb/influxdb/labels/category/functions","name":"category/functions","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-17T12:56:36Z","updated_at":"2015-11-18T05:53:55Z","closed_at":null,"body":"Why result is different?\r\n\r\n```\r\n> SELECT non_negative_derivative(mean(in_octets)) FROM \"other_interface\" WHERE \"type\" = 'ethernet' AND \"cm_mac\" =~ /001311a6edc6/ AND time > now() - 1h GROUP BY time(5m)\r\nname: other_interface\r\n---------------------\r\ntime                    non_negative_derivative\r\n1447761300000000000\r\n1447761600000000000     2.700182e+06\r\n1447761900000000000     1.597755e+06\r\n1447762200000000000     3.3451055e+06\r\n1447762500000000000     5.7093755e+06\r\n1447762800000000000     1.494687e+06\r\n1447763100000000000     6.504519e+06\r\n1447763400000000000     4.725501e+06\r\n1447763700000000000     1.5185836e+07\r\n1447764000000000000\r\n1447764300000000000\r\n1447764600000000000\r\n\r\n> SELECT non_negative_derivative(mean(in_octets),1s) FROM \"other_interface\" WHERE \"type\" = 'ethernet' AND \"cm_mac\" =~ /001311a6edc6/ AND time > now() - 1h GROUP BY time(5m)\r\nname: other_interface\r\n---------------------\r\ntime                    non_negative_derivative\r\n1447761300000000000\r\n1447761600000000000     9000.606666666667\r\n1447761900000000000     5325.85\r\n1447762200000000000     11150.351666666667\r\n1447762500000000000     19031.251666666667\r\n1447762800000000000     4982.29\r\n1447763100000000000     21681.73\r\n1447763400000000000     15751.67\r\n1447763700000000000     50619.45333333333\r\n1447764000000000000\r\n1447764300000000000\r\n1447764600000000000\r\n```"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/157611222","html_url":"https://github.com/influxdb/influxdb/issues/4819#issuecomment-157611222","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/4819","id":157611222,"user":{"login":"mahadeva604","id":6159814,"avatar_url":"https://avatars.githubusercontent.com/u/6159814?v=3","gravatar_id":"","url":"https://api.github.com/users/mahadeva604","html_url":"https://github.com/mahadeva604","followers_url":"https://api.github.com/users/mahadeva604/followers","following_url":"https://api.github.com/users/mahadeva604/following{/other_user}","gists_url":"https://api.github.com/users/mahadeva604/gists{/gist_id}","starred_url":"https://api.github.com/users/mahadeva604/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mahadeva604/subscriptions","organizations_url":"https://api.github.com/users/mahadeva604/orgs","repos_url":"https://api.github.com/users/mahadeva604/repos","events_url":"https://api.github.com/users/mahadeva604/events{/privacy}","received_events_url":"https://api.github.com/users/mahadeva604/received_events","type":"User","site_admin":false},"created_at":"2015-11-18T05:53:55Z","updated_at":"2015-11-18T05:53:55Z","body":"I think data from @rkuchan enough to find bug."}}