{"action":"opened","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/8555","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/8555/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/8555/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/8555/events","html_url":"https://github.com/influxdata/influxdb/issues/8555","id":239813114,"number":8555,"title":"Ahead of time grouping with null values.... ","user":{"login":"theoDiefenthal","id":4670569,"avatar_url":"https://avatars3.githubusercontent.com/u/4670569?v=3","gravatar_id":"","url":"https://api.github.com/users/theoDiefenthal","html_url":"https://github.com/theoDiefenthal","followers_url":"https://api.github.com/users/theoDiefenthal/followers","following_url":"https://api.github.com/users/theoDiefenthal/following{/other_user}","gists_url":"https://api.github.com/users/theoDiefenthal/gists{/gist_id}","starred_url":"https://api.github.com/users/theoDiefenthal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theoDiefenthal/subscriptions","organizations_url":"https://api.github.com/users/theoDiefenthal/orgs","repos_url":"https://api.github.com/users/theoDiefenthal/repos","events_url":"https://api.github.com/users/theoDiefenthal/events{/privacy}","received_events_url":"https://api.github.com/users/theoDiefenthal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-06-30T15:28:06Z","updated_at":"2017-06-30T15:28:06Z","closed_at":null,"body":"We have an Open Source (Community) InfluxDB instance running remotely in version 1.2.2 in a docker container.\r\n\r\nIf I query a measurement all along with aggregation, a grouping by time and a given start but without an end date, I expect the result to be matched to the entire dataset beginning from start and going to the end, but not more. However, in the result Influx creates some more \"time group buckets\" ahead of time and fills their values with `null` as there are obviously no points yet. I would be happy, if you exclude those meaningless `null`-buckets. \r\n\r\nFor a demonstration. I have a measurement like this:\r\n```\r\n> SELECT value FROM \"MY_SENSOR\" ORDER BY time DESC LIMIT 10\r\nname: MY_SENSOR\r\ntime                 value\r\n----                 -----\r\n2017-06-30T03:45:00Z 1.2\r\n2017-06-30T03:30:00Z -3.6\r\n2017-06-30T03:15:00Z 5.2\r\n2017-06-30T03:00:00Z -9.6\r\n2017-06-30T02:45:00Z 7.2\r\n2017-06-30T02:30:00Z 0\r\n2017-06-30T02:15:00Z 0.40000000000003\r\n2017-06-30T02:00:00Z 4\r\n2017-06-30T01:45:00Z 0\r\n2017-06-30T01:30:00Z 0\r\n```\r\n\r\nand now, I do an aggregation operation on that measurement like the following:\r\n```\r\n> SELECT MEAN(\"value\") AS \"value\" FROM \"MY_SENSOR\" WHERE time >= '2017-05-07T11:45:00Z' GROUP BY time(100m)\r\nname: MY_SENSOR\r\ntime                 value\r\n----                 -----\r\n2017-05-07T11:20:00Z 0.15999999999999998\r\n2017-05-07T13:00:00Z -2.6285714285714343\r\n2017-05-07T14:40:00Z 3.8285714285714305\r\n.....\r\nLot more values\r\n.....\r\n2017-06-30T02:00:00Z 0.5142857142857186\r\n2017-06-30T03:40:00Z 1.2\r\n2017-06-30T05:20:00Z null\r\n2017-06-30T07:00:00Z null\r\n2017-06-30T08:40:00Z null\r\n2017-06-30T10:20:00Z null\r\n2017-06-30T12:00:00Z null\r\n2017-06-30T13:40:00Z null\r\n```\r\n\r\nAs you see, there are some useless null entries at the end... \r\nThey occur for COUNT, MEAN ,... doesn't matter.\r\n\r\nThis behavior occurs in the Java Influx SDK as well as in the CLI, so it's a problem of the response which is sent by Influx via REST... "}}
{"actor":{"display_login":"theoDiefenthal"}}