{"action":"created","issue":{"url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/421","repository_url":"https://api.github.com/repos/YugaByte/yugabyte-db","labels_url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/421/labels{/name}","comments_url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/421/comments","events_url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/421/events","html_url":"https://github.com/YugaByte/yugabyte-db/issues/421","id":347722983,"node_id":"MDU6SXNzdWUzNDc3MjI5ODM=","number":421,"title":"2i index on lists","user":{"login":"doublex","id":274624,"node_id":"MDQ6VXNlcjI3NDYyNA==","avatar_url":"https://avatars0.githubusercontent.com/u/274624?v=4","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":[{"id":711841624,"node_id":"MDU6TGFiZWw3MTE4NDE2MjQ=","url":"https://api.github.com/repos/YugaByte/yugabyte-db/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-08-05T19:08:10Z","updated_at":"2018-08-06T16:49:01Z","closed_at":null,"author_association":"NONE","body":"To migrate a database from \"BerkeleyDB\" to YugoByte:\r\n\r\nIs there a chance to query a range request on lexicographical list values?\r\nSimplied example using CQL (finds users from 'Marseille', 'Melbourne', 'Moscow', ...):\r\n````\r\nUPDATE users SET places = ['London', 'Madrid'] WHERE userid = 1;\r\nSELECT userid FROM users WHERE places CONTAINS BETWEEN 'Ma' AND 'Mz';\r\n````\r\n\r\n* Cassandra supports indexing `lists` using the `CONTAINS` keyword.\r\n* Redis supports lexicographical indexes using the `ZRANGEBYLEX` command.\r\n\r\nThanks a lot!"},"comment":{"url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/comments/410773864","html_url":"https://github.com/YugaByte/yugabyte-db/issues/421#issuecomment-410773864","issue_url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/421","id":410773864,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMDc3Mzg2NA==","user":{"login":"rkarthik007","id":9641328,"node_id":"MDQ6VXNlcjk2NDEzMjg=","avatar_url":"https://avatars0.githubusercontent.com/u/9641328?v=4","gravatar_id":"","url":"https://api.github.com/users/rkarthik007","html_url":"https://github.com/rkarthik007","followers_url":"https://api.github.com/users/rkarthik007/followers","following_url":"https://api.github.com/users/rkarthik007/following{/other_user}","gists_url":"https://api.github.com/users/rkarthik007/gists{/gist_id}","starred_url":"https://api.github.com/users/rkarthik007/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rkarthik007/subscriptions","organizations_url":"https://api.github.com/users/rkarthik007/orgs","repos_url":"https://api.github.com/users/rkarthik007/repos","events_url":"https://api.github.com/users/rkarthik007/events{/privacy}","received_events_url":"https://api.github.com/users/rkarthik007/received_events","type":"User","site_admin":false},"created_at":"2018-08-06T16:49:01Z","updated_at":"2018-08-06T16:49:01Z","author_association":"COLLABORATOR","body":"Also, wanted to point out that for:\r\n> Cassandra supports indexing lists using the CONTAINS keyword.\r\n\r\nThe equivalent functionality can be achieved by creating a clustering column with the contents of the list and creating a secondary index. This should allow looking up by the list value in O(1). Not sure if that would work for you though."}}
{"actor":{"display_login":"rkarthik007"}}