{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-carbondata/issues/70","repository_url":"https://api.github.com/repos/apache/incubator-carbondata","labels_url":"https://api.github.com/repos/apache/incubator-carbondata/issues/70/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-carbondata/issues/70/comments","events_url":"https://api.github.com/repos/apache/incubator-carbondata/issues/70/events","html_url":"https://github.com/apache/incubator-carbondata/pull/70","id":170319608,"number":70,"title":"[CARBONDATA-154] Fix the bug of block prune that query result is wrong.","user":{"login":"Zhangshunyu","id":13940237,"avatar_url":"https://avatars.githubusercontent.com/u/13940237?v=3","gravatar_id":"","url":"https://api.github.com/users/Zhangshunyu","html_url":"https://github.com/Zhangshunyu","followers_url":"https://api.github.com/users/Zhangshunyu/followers","following_url":"https://api.github.com/users/Zhangshunyu/following{/other_user}","gists_url":"https://api.github.com/users/Zhangshunyu/gists{/gist_id}","starred_url":"https://api.github.com/users/Zhangshunyu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Zhangshunyu/subscriptions","organizations_url":"https://api.github.com/users/Zhangshunyu/orgs","repos_url":"https://api.github.com/users/Zhangshunyu/repos","events_url":"https://api.github.com/users/Zhangshunyu/events{/privacy}","received_events_url":"https://api.github.com/users/Zhangshunyu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-10T03:23:08Z","updated_at":"2016-08-11T15:14:12Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/incubator-carbondata/pulls/70","html_url":"https://github.com/apache/incubator-carbondata/pull/70","diff_url":"https://github.com/apache/incubator-carbondata/pull/70.diff","patch_url":"https://github.com/apache/incubator-carbondata/pull/70.patch"},"body":"## Why raise this pr:\r\n\r\nDuring block prune, endkey is always only decided by the last filter expression, this is a bug\r\nand can lead wrong result,\r\nFor example, when load data whose dimension column is 120000 lines of 'a', 120000 lines of 'b', 120000 lines of 'c', if query like \"select * from tablename where colname='c' or colname='b' or colname='a'\" only 120000lines 'a' will be selected because of wrong endkey.\r\n\r\n## How to solve this:\r\n\r\nFix the end key consider all the filter expression end key get max and start key get (min - 1) for each column level, using this to produce a new start key an a new endkey.\r\n\r\nFor more details please look at the test case."},"comment":{"url":"https://api.github.com/repos/apache/incubator-carbondata/issues/comments/239192197","html_url":"https://github.com/apache/incubator-carbondata/pull/70#issuecomment-239192197","issue_url":"https://api.github.com/repos/apache/incubator-carbondata/issues/70","id":239192197,"user":{"login":"chenliang613","id":8075709,"avatar_url":"https://avatars.githubusercontent.com/u/8075709?v=3","gravatar_id":"","url":"https://api.github.com/users/chenliang613","html_url":"https://github.com/chenliang613","followers_url":"https://api.github.com/users/chenliang613/followers","following_url":"https://api.github.com/users/chenliang613/following{/other_user}","gists_url":"https://api.github.com/users/chenliang613/gists{/gist_id}","starred_url":"https://api.github.com/users/chenliang613/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chenliang613/subscriptions","organizations_url":"https://api.github.com/users/chenliang613/orgs","repos_url":"https://api.github.com/users/chenliang613/repos","events_url":"https://api.github.com/users/chenliang613/events{/privacy}","received_events_url":"https://api.github.com/users/chenliang613/received_events","type":"User","site_admin":false},"created_at":"2016-08-11T15:14:12Z","updated_at":"2016-08-11T15:14:12Z","body":"LGTM\r\n"}}
{"actor":{"display_login":"chenliang613"}}