{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/5626","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/5626/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/5626/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/5626/events","html_url":"https://github.com/influxdata/influxdb/issues/5626","id":132902073,"number":5626,"title":"[feature request] Support of IN clause in query","user":{"login":"pribiswas","id":8664591,"avatar_url":"https://avatars.githubusercontent.com/u/8664591?v=3","gravatar_id":"","url":"https://api.github.com/users/pribiswas","html_url":"https://github.com/pribiswas","followers_url":"https://api.github.com/users/pribiswas/followers","following_url":"https://api.github.com/users/pribiswas/following{/other_user}","gists_url":"https://api.github.com/users/pribiswas/gists{/gist_id}","starred_url":"https://api.github.com/users/pribiswas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pribiswas/subscriptions","organizations_url":"https://api.github.com/users/pribiswas/orgs","repos_url":"https://api.github.com/users/pribiswas/repos","events_url":"https://api.github.com/users/pribiswas/events{/privacy}","received_events_url":"https://api.github.com/users/pribiswas/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/feature%20request","name":"category/feature request","color":"006b75"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/queries","name":"category/queries","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-02-11T06:45:12Z","updated_at":"2016-02-19T00:04:52Z","closed_at":null,"body":"Suppose I have following points in influxdb:\r\n{account_id: 1, user_id: 1}\r\n{account_id: 2, user_id: 2}\r\n{account_id: 3, user_id: 3}\r\n\r\nI just want to select those points where account_id belongs to [1, 2, 3]. Something like:\r\nSELECT * FROM my_series WHERE account_id IN ('1', '2', '3')\r\n\r\nLooks like IN CLAUSE is not supported in influx QL. I am using v0.10.0. Is there any plan to support IN clause in future?"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/185986635","html_url":"https://github.com/influxdata/influxdb/issues/5626#issuecomment-185986635","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/5626","id":185986635,"user":{"login":"cxreg","id":55474,"avatar_url":"https://avatars.githubusercontent.com/u/55474?v=3","gravatar_id":"","url":"https://api.github.com/users/cxreg","html_url":"https://github.com/cxreg","followers_url":"https://api.github.com/users/cxreg/followers","following_url":"https://api.github.com/users/cxreg/following{/other_user}","gists_url":"https://api.github.com/users/cxreg/gists{/gist_id}","starred_url":"https://api.github.com/users/cxreg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cxreg/subscriptions","organizations_url":"https://api.github.com/users/cxreg/orgs","repos_url":"https://api.github.com/users/cxreg/repos","events_url":"https://api.github.com/users/cxreg/events{/privacy}","received_events_url":"https://api.github.com/users/cxreg/received_events","type":"User","site_admin":false},"created_at":"2016-02-19T00:04:52Z","updated_at":"2016-02-19T00:04:52Z","body":"https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg/influxdb/wjawZZ0RFRE/cydIk0xPZCIJ seems to confirm my notion that this is unindexed.  I would hope and expect that an IN() version would indeed make use of the index here"}}