{"action":"created","issue":{"url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/327","repository_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index","labels_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/327/labels{/name}","comments_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/327/comments","events_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/327/events","html_url":"https://github.com/Stratio/cassandra-lucene-index/issues/327","id":235416860,"number":327,"title":"Support paging in SCLI","user":{"login":"zengzh","id":22114008,"avatar_url":"https://avatars3.githubusercontent.com/u/22114008?v=3","gravatar_id":"","url":"https://api.github.com/users/zengzh","html_url":"https://github.com/zengzh","followers_url":"https://api.github.com/users/zengzh/followers","following_url":"https://api.github.com/users/zengzh/following{/other_user}","gists_url":"https://api.github.com/users/zengzh/gists{/gist_id}","starred_url":"https://api.github.com/users/zengzh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zengzh/subscriptions","organizations_url":"https://api.github.com/users/zengzh/orgs","repos_url":"https://api.github.com/users/zengzh/repos","events_url":"https://api.github.com/users/zengzh/events{/privacy}","received_events_url":"https://api.github.com/users/zengzh/received_events","type":"User","site_admin":false},"labels":[{"id":361242500,"url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/labels/waiting%20for%20feedback","name":"waiting for feedback","color":"fef2c0","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-06-13T02:19:38Z","updated_at":"2017-06-15T02:36:11Z","closed_at":null,"body":"Hi @ealonsodb \r\n\r\nElasticSearch accepts “from” and “size” parameters so that users can retrieve certain number of results starting from a particular position. https://www.elastic.co/guide/en/elasticsearch/guide/current/pagination.html\r\n\r\nDoes SCLI have this feature? For example, can I issue a query as follows:\r\n\r\n```\r\nSELECT * FROM tweets WHERE expr(tweets_index, '{\r\nquery: {type: \"match\", field: \"body\", value: \"FIFA\"},\r\n**limit：{offset:\"100\", pagesize：\"100\"}**\r\n}');\r\n```\r\n\r\nWhich retrieves the tweets about FIFA that are returned in 100 tweets/page and skip the first 100 tweets?\r\nIf not, does stratio folks have plan to support this? Thanks.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/comments/308611934","html_url":"https://github.com/Stratio/cassandra-lucene-index/issues/327#issuecomment-308611934","issue_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/327","id":308611934,"user":{"login":"zengzh","id":22114008,"avatar_url":"https://avatars3.githubusercontent.com/u/22114008?v=3","gravatar_id":"","url":"https://api.github.com/users/zengzh","html_url":"https://github.com/zengzh","followers_url":"https://api.github.com/users/zengzh/followers","following_url":"https://api.github.com/users/zengzh/following{/other_user}","gists_url":"https://api.github.com/users/zengzh/gists{/gist_id}","starred_url":"https://api.github.com/users/zengzh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zengzh/subscriptions","organizations_url":"https://api.github.com/users/zengzh/orgs","repos_url":"https://api.github.com/users/zengzh/repos","events_url":"https://api.github.com/users/zengzh/events{/privacy}","received_events_url":"https://api.github.com/users/zengzh/received_events","type":"User","site_admin":false},"created_at":"2017-06-15T02:36:11Z","updated_at":"2017-06-15T02:36:11Z","body":"Thanks @ealonsodb \r\nIt surprises me that the official document does not mention page size can be customized.\r\n\r\nCassandra supports paging but does not encourage [offset queries ](https://docs.datastax.com/en/developer/java-driver/2.1/manual/paging/). \r\n\r\nI understand that even providing an offset in SCLI, it still needs to compute the first page and discard those results (keys). But, this avoids to retrieve the whole set of tuples from Cassandra and discard them.  To this point of view, compute and discard results from SCLI instead of computing and discarding tuples from Cassandra is helpful, right?"}}
{"actor":{"display_login":"zengzh"}}