{"action":"closed","issue":{"url":"https://api.github.com/repos/intel-hadoop/Big-Data-Benchmark-for-Big-Bench/issues/56","labels_url":"https://api.github.com/repos/intel-hadoop/Big-Data-Benchmark-for-Big-Bench/issues/56/labels{/name}","comments_url":"https://api.github.com/repos/intel-hadoop/Big-Data-Benchmark-for-Big-Bench/issues/56/comments","events_url":"https://api.github.com/repos/intel-hadoop/Big-Data-Benchmark-for-Big-Bench/issues/56/events","html_url":"https://github.com/intel-hadoop/Big-Data-Benchmark-for-Big-Bench/issues/56","id":110112737,"number":56,"title":"Q5 Runtime Improvement","user":{"login":"rohit-singhal","id":13595583,"avatar_url":"https://avatars.githubusercontent.com/u/13595583?v=3","gravatar_id":"","url":"https://api.github.com/users/rohit-singhal","html_url":"https://github.com/rohit-singhal","followers_url":"https://api.github.com/users/rohit-singhal/followers","following_url":"https://api.github.com/users/rohit-singhal/following{/other_user}","gists_url":"https://api.github.com/users/rohit-singhal/gists{/gist_id}","starred_url":"https://api.github.com/users/rohit-singhal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rohit-singhal/subscriptions","organizations_url":"https://api.github.com/users/rohit-singhal/orgs","repos_url":"https://api.github.com/users/rohit-singhal/repos","events_url":"https://api.github.com/users/rohit-singhal/events{/privacy}","received_events_url":"https://api.github.com/users/rohit-singhal/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-06T22:14:52Z","updated_at":"2015-10-22T19:40:04Z","closed_at":"2015-10-22T19:40:04Z","body":"The following change results in a 35% runtime improvement for Query 5. The change is to split a massive join into smaller parts that effectively pre-filter data. \r\nThe final output is unchanged. This has been verified at multiple scale factors. \r\n![q05_change](https://cloud.githubusercontent.com/assets/13595583/10324247/f8009456-6c3c-11e5-87c0-743752a918a1.jpg)\r\n"}}