{"action":"closed","issue":{"url":"https://api.github.com/repos/OpenTSDB/opentsdb/issues/881","repository_url":"https://api.github.com/repos/OpenTSDB/opentsdb","labels_url":"https://api.github.com/repos/OpenTSDB/opentsdb/issues/881/labels{/name}","comments_url":"https://api.github.com/repos/OpenTSDB/opentsdb/issues/881/comments","events_url":"https://api.github.com/repos/OpenTSDB/opentsdb/issues/881/events","html_url":"https://github.com/OpenTSDB/opentsdb/issues/881","id":182455611,"number":881,"title":"Unify starting timestamp ?","user":{"login":"benrubson","id":6764151,"avatar_url":"https://avatars.githubusercontent.com/u/6764151?v=3","gravatar_id":"","url":"https://api.github.com/users/benrubson","html_url":"https://github.com/benrubson","followers_url":"https://api.github.com/users/benrubson/followers","following_url":"https://api.github.com/users/benrubson/following{/other_user}","gists_url":"https://api.github.com/users/benrubson/gists{/gist_id}","starred_url":"https://api.github.com/users/benrubson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benrubson/subscriptions","organizations_url":"https://api.github.com/users/benrubson/orgs","repos_url":"https://api.github.com/users/benrubson/repos","events_url":"https://api.github.com/users/benrubson/events{/privacy}","received_events_url":"https://api.github.com/users/benrubson/received_events","type":"User","site_admin":false},"labels":[{"id":104810722,"url":"https://api.github.com/repos/OpenTSDB/opentsdb/labels/question","name":"question","color":"d4c5f9","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-10-12T07:36:39Z","updated_at":"2016-11-01T14:17:44Z","closed_at":"2016-11-01T14:17:44Z","body":"Hello,\n\nLet's assume 2 series with the following values :\n\n```\ncpu.idle\n- 10:30:00 : 100\n- 10:29:29 : 100\n- 10:28:58 : 100\n- 10:28:27 : 60\n- 10:27:56 : 60\n\ncpu.user\n- 10:28:58 : 0\n- 10:28:27 : 40\n- 10:27:56 : 40\n```\n\nAs you can see, cpu.user does not have the 2 last timestamps, as they have 0 value they were not pushed to OpenTSDB (deduplication).\n\nWhen we request these 2 series, starting at 10:29:50 with a 30 seconds downsample (to match data sampling), OpenTSDB will return the following :\n\n```\ncpu.idle\n- 10:30:00 : 100\n- 10:29:30 : 100\n- 10:29:00 : 100\n- 10:28:30 : 60\n- 10:28:00 : 60\n\ncpu.user\n- 10:28:58 : 0\n- 10:28:28 : 40\n- 10:27:58 : 40\n```\n\nUnfortunately, we can't stack these series, as the timestamps do not match.\n\nI think we would expect the following (take the first available timestamp across the requested series as the starting timestamp) :\n\n```\ncpu.idle\n- 10:30:00 : 100\n- 10:29:30 : 100\n- 10:29:00 : 100\n- 10:28:30 : 60\n- 10:28:00 : 60\n\ncpu.user\n- 10:29:00 : 0\n- 10:28:30 : 40\n- 10:28:00 : 40\n```\n\nOr (take the query timestamp as the starting timestamp) :\n\n```\ncpu.idle\n- 10:29:50 : 100\n- 10:29:20 : 100\n- 10:28:50 : 100\n- 10:28:20 : 60\n- 10:27:50 : 60\n\ncpu.user\n- 10:28:50 : 0\n- 10:28:20 : 40\n- 10:27:50 : 40\n```\n\nDo you think OpenTSDB could be modified to match this behaviour ?\n\nThank you very much 👍 \n\nBen\n"}}
{"actor":{"display_login":"benrubson"}}