{"action":"created","issue":{"url":"https://api.github.com/repos/scylladb/scylla/issues/401","repository_url":"https://api.github.com/repos/scylladb/scylla","labels_url":"https://api.github.com/repos/scylladb/scylla/issues/401/labels{/name}","comments_url":"https://api.github.com/repos/scylladb/scylla/issues/401/comments","events_url":"https://api.github.com/repos/scylladb/scylla/issues/401/events","html_url":"https://github.com/scylladb/scylla/issues/401","id":108100378,"number":401,"title":"Secondary index","user":{"login":"doublex","id":274624,"avatar_url":"https://avatars.githubusercontent.com/u/274624?v=3","gravatar_id":"","url":"https://api.github.com/users/doublex","html_url":"https://github.com/doublex","followers_url":"https://api.github.com/users/doublex/followers","following_url":"https://api.github.com/users/doublex/following{/other_user}","gists_url":"https://api.github.com/users/doublex/gists{/gist_id}","starred_url":"https://api.github.com/users/doublex/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/doublex/subscriptions","organizations_url":"https://api.github.com/users/doublex/orgs","repos_url":"https://api.github.com/users/doublex/repos","events_url":"https://api.github.com/users/doublex/events{/privacy}","received_events_url":"https://api.github.com/users/doublex/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/scylladb/scylla/labels/CQL","name":"CQL","color":"c2e0c6"},{"url":"https://api.github.com/repos/scylladb/scylla/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/scylladb/scylla/labels/high","name":"high","color":"d4c5f9"},{"url":"https://api.github.com/repos/scylladb/scylla/labels/User%20Request","name":"User Request","color":"c7def8"}],"state":"open","locked":false,"assignee":{"login":"nyh","id":584227,"avatar_url":"https://avatars.githubusercontent.com/u/584227?v=3","gravatar_id":"","url":"https://api.github.com/users/nyh","html_url":"https://github.com/nyh","followers_url":"https://api.github.com/users/nyh/followers","following_url":"https://api.github.com/users/nyh/following{/other_user}","gists_url":"https://api.github.com/users/nyh/gists{/gist_id}","starred_url":"https://api.github.com/users/nyh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nyh/subscriptions","organizations_url":"https://api.github.com/users/nyh/orgs","repos_url":"https://api.github.com/users/nyh/repos","events_url":"https://api.github.com/users/nyh/events{/privacy}","received_events_url":"https://api.github.com/users/nyh/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/scylladb/scylla/milestones/12","html_url":"https://github.com/scylladb/scylla/milestones/1.1","labels_url":"https://api.github.com/repos/scylladb/scylla/milestones/12/labels","id":1661891,"number":12,"title":"1.1","description":"","creator":{"login":"tzach","id":170200,"avatar_url":"https://avatars.githubusercontent.com/u/170200?v=3","gravatar_id":"","url":"https://api.github.com/users/tzach","html_url":"https://github.com/tzach","followers_url":"https://api.github.com/users/tzach/followers","following_url":"https://api.github.com/users/tzach/following{/other_user}","gists_url":"https://api.github.com/users/tzach/gists{/gist_id}","starred_url":"https://api.github.com/users/tzach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tzach/subscriptions","organizations_url":"https://api.github.com/users/tzach/orgs","repos_url":"https://api.github.com/users/tzach/repos","events_url":"https://api.github.com/users/tzach/events{/privacy}","received_events_url":"https://api.github.com/users/tzach/received_events","type":"User","site_admin":false},"open_issues":67,"closed_issues":41,"state":"open","created_at":"2016-03-23T13:18:57Z","updated_at":"2016-04-15T05:57:06Z","due_on":null,"closed_at":null},"comments":11,"created_at":"2015-09-24T10:14:08Z","updated_at":"2016-04-18T07:36:02Z","closed_at":null,"body":"Is scylladb a \"newsql\" database like cockroachdb, clustrix, ...?\r\nMore precise:\r\nIs there support for a secondary index?\r\nIf yes, is the secondary index stored on the same machine as the record? Is it necessary to ask all the machines to query a secondary index?\r\n"},"comment":{"url":"https://api.github.com/repos/scylladb/scylla/issues/comments/211244420","html_url":"https://github.com/scylladb/scylla/issues/401#issuecomment-211244420","issue_url":"https://api.github.com/repos/scylladb/scylla/issues/401","id":211244420,"user":{"login":"doublex","id":274624,"avatar_url":"https://avatars.githubusercontent.com/u/274624?v=3","gravatar_id":"","url":"https://api.github.com/users/doublex","html_url":"https://github.com/doublex","followers_url":"https://api.github.com/users/doublex/followers","following_url":"https://api.github.com/users/doublex/following{/other_user}","gists_url":"https://api.github.com/users/doublex/gists{/gist_id}","starred_url":"https://api.github.com/users/doublex/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/doublex/subscriptions","organizations_url":"https://api.github.com/users/doublex/orgs","repos_url":"https://api.github.com/users/doublex/repos","events_url":"https://api.github.com/users/doublex/events{/privacy}","received_events_url":"https://api.github.com/users/doublex/received_events","type":"User","site_admin":false},"created_at":"2016-04-18T07:36:02Z","updated_at":"2016-04-18T07:36:02Z","body":"It would be great to have one distributed database which\r\na) supports range requests (on secondary index)\r\nb) scales with sherd count\r\nc) not based on \"garbage collection\"\r\nTo my knowledge such a database does not exist"}}