{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/4471","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/4471/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/4471/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/4471/events","html_url":"https://github.com/influxdb/influxdb/issues/4471","id":111790768,"number":4471,"title":"[0.9.5-nightly] SHOW TAG VALUES ... WHERE time > now() - 1h","user":{"login":"ymettier","id":2285664,"avatar_url":"https://avatars.githubusercontent.com/u/2285664?v=3","gravatar_id":"","url":"https://api.github.com/users/ymettier","html_url":"https://github.com/ymettier","followers_url":"https://api.github.com/users/ymettier/followers","following_url":"https://api.github.com/users/ymettier/following{/other_user}","gists_url":"https://api.github.com/users/ymettier/gists{/gist_id}","starred_url":"https://api.github.com/users/ymettier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ymettier/subscriptions","organizations_url":"https://api.github.com/users/ymettier/orgs","repos_url":"https://api.github.com/users/ymettier/repos","events_url":"https://api.github.com/users/ymettier/events{/privacy}","received_events_url":"https://api.github.com/users/ymettier/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-16T09:01:24Z","updated_at":"2015-10-16T09:06:41Z","closed_at":null,"body":"Hello,\r\n\r\n## Description of the problem\r\n```\r\nSHOW TAG VALUES FROM \"sys.cpu\" WITH KEY = \"fqdn\" WHERE time > now() - 1h\r\n```\r\n\r\nThis is returning results on 0.9.4\r\n\r\n0.9.5-nightly answers this :\r\n```\r\nServer returned error: SHOW SERIES doesn't support time in WHERE clause\r\n```\r\n\r\nHow can I get the servers that were still alive last hour ?\r\n\r\n\r\n## More information\r\n```\r\n$ rpm -q influxdb\r\ninfluxdb-0.9.5_nightly_542efbb-1.x86_64\r\n```\r\nand\r\n```\r\nSHOW DIAGNOSTICS\r\n[...]\r\nBranch\tBuild Time\tCommit\tVersion\r\nmaster\t\"'2015-10-16T04:00:42+0000'\"\t\"542efbbd7993f0a7a7e6ff73a134df13c8274744\"\t\"0.9.5-nightly-542efbb\"\r\n```\r\nRegards,\r\nYves"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/148661511","html_url":"https://github.com/influxdb/influxdb/issues/4471#issuecomment-148661511","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/4471","id":148661511,"user":{"login":"ymettier","id":2285664,"avatar_url":"https://avatars.githubusercontent.com/u/2285664?v=3","gravatar_id":"","url":"https://api.github.com/users/ymettier","html_url":"https://github.com/ymettier","followers_url":"https://api.github.com/users/ymettier/followers","following_url":"https://api.github.com/users/ymettier/following{/other_user}","gists_url":"https://api.github.com/users/ymettier/gists{/gist_id}","starred_url":"https://api.github.com/users/ymettier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ymettier/subscriptions","organizations_url":"https://api.github.com/users/ymettier/orgs","repos_url":"https://api.github.com/users/ymettier/repos","events_url":"https://api.github.com/users/ymettier/events{/privacy}","received_events_url":"https://api.github.com/users/ymettier/received_events","type":"User","site_admin":false},"created_at":"2015-10-16T09:06:41Z","updated_at":"2015-10-16T09:06:41Z","body":"I forgot to mention that I'm running `tsm1` engine. I don't know if this is important. Not tested with `bz1`."}}