{"action":"created","issue":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809","repository_url":"https://api.github.com/repos/rethinkdb/rethinkdb","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809/labels{/name}","comments_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809/comments","events_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809/events","html_url":"https://github.com/rethinkdb/rethinkdb/issues/809","id":14335226,"number":809,"title":"Support efficient index intersection","user":{"login":"coffeemug","id":48436,"avatar_url":"https://avatars.githubusercontent.com/u/48436?v=3","gravatar_id":"","url":"https://api.github.com/users/coffeemug","html_url":"https://github.com/coffeemug","followers_url":"https://api.github.com/users/coffeemug/followers","following_url":"https://api.github.com/users/coffeemug/following{/other_user}","gists_url":"https://api.github.com/users/coffeemug/gists{/gist_id}","starred_url":"https://api.github.com/users/coffeemug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coffeemug/subscriptions","organizations_url":"https://api.github.com/users/coffeemug/orgs","repos_url":"https://api.github.com/users/coffeemug/repos","events_url":"https://api.github.com/users/coffeemug/events{/privacy}","received_events_url":"https://api.github.com/users/coffeemug/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/labels/cp:reql","name":"cp:reql","color":"02d7e1"},{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/labels/tp:enhancement","name":"tp:enhancement","color":"02e10c"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/2","html_url":"https://github.com/rethinkdb/rethinkdb/milestones/backlog","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/2/labels","id":211054,"number":2,"title":"backlog","description":"Issues in this milestone are not an immediate priority, and will be periodically revisited. When we decide to work on an issue in backlog, we'll move it to next.","creator":{"login":"coffeemug","id":48436,"avatar_url":"https://avatars.githubusercontent.com/u/48436?v=3","gravatar_id":"","url":"https://api.github.com/users/coffeemug","html_url":"https://github.com/coffeemug","followers_url":"https://api.github.com/users/coffeemug/followers","following_url":"https://api.github.com/users/coffeemug/following{/other_user}","gists_url":"https://api.github.com/users/coffeemug/gists{/gist_id}","starred_url":"https://api.github.com/users/coffeemug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coffeemug/subscriptions","organizations_url":"https://api.github.com/users/coffeemug/orgs","repos_url":"https://api.github.com/users/coffeemug/repos","events_url":"https://api.github.com/users/coffeemug/events{/privacy}","received_events_url":"https://api.github.com/users/coffeemug/received_events","type":"User","site_admin":false},"open_issues":859,"closed_issues":0,"state":"open","created_at":"2012-11-11T14:16:11Z","updated_at":"2016-05-25T19:25:51Z","due_on":null,"closed_at":null},"comments":22,"created_at":"2013-05-14T22:35:39Z","updated_at":"2016-05-31T07:09:31Z","closed_at":null,"body":"```\r\ntable('foo')\r\n .between(i, j, index='a')\r\n .between(k, l, index='b')\r\n .between(m, n, index='c')\r\n```\r\n\r\nCurrently we can only use a single index at a time. We should eventually support efficient index intersection (which is a neat problem). This is obviously in backlog because:\r\n\r\n* There's far more important low-hanging fruit\r\n* None of the state of the art systems in this space support this\r\n* A lot of technical (language optimizer) work likely needs to be in place before we can do this"},"comment":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/comments/222608945","html_url":"https://github.com/rethinkdb/rethinkdb/issues/809#issuecomment-222608945","issue_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809","id":222608945,"user":{"login":"andokai","id":3984138,"avatar_url":"https://avatars.githubusercontent.com/u/3984138?v=3","gravatar_id":"","url":"https://api.github.com/users/andokai","html_url":"https://github.com/andokai","followers_url":"https://api.github.com/users/andokai/followers","following_url":"https://api.github.com/users/andokai/following{/other_user}","gists_url":"https://api.github.com/users/andokai/gists{/gist_id}","starred_url":"https://api.github.com/users/andokai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andokai/subscriptions","organizations_url":"https://api.github.com/users/andokai/orgs","repos_url":"https://api.github.com/users/andokai/repos","events_url":"https://api.github.com/users/andokai/events{/privacy}","received_events_url":"https://api.github.com/users/andokai/received_events","type":"User","site_admin":false},"created_at":"2016-05-31T07:09:31Z","updated_at":"2016-05-31T07:09:31Z","body":"Any sign of this getting some love? I'm hoping to avoid having to augment RethinkDB with Elasticsearch just to enable semi-complex queries."}}
{"actor":{"display_login":"andokai"}}