{"action":"reopened","issue":{"url":"https://api.github.com/repos/yahoo/maha/issues/328","repository_url":"https://api.github.com/repos/yahoo/maha","labels_url":"https://api.github.com/repos/yahoo/maha/issues/328/labels{/name}","comments_url":"https://api.github.com/repos/yahoo/maha/issues/328/comments","events_url":"https://api.github.com/repos/yahoo/maha/issues/328/events","html_url":"https://github.com/yahoo/maha/issues/328","id":358230999,"node_id":"MDU6SXNzdWUzNTgyMzA5OTk=","number":328,"title":"MIP 1: Generate the join instead of in subquery when high cardinality dimension filters are requested","user":{"login":"pranavbhole","id":4935454,"node_id":"MDQ6VXNlcjQ5MzU0NTQ=","avatar_url":"https://avatars2.githubusercontent.com/u/4935454?v=4","gravatar_id":"","url":"https://api.github.com/users/pranavbhole","html_url":"https://github.com/pranavbhole","followers_url":"https://api.github.com/users/pranavbhole/followers","following_url":"https://api.github.com/users/pranavbhole/following{/other_user}","gists_url":"https://api.github.com/users/pranavbhole/gists{/gist_id}","starred_url":"https://api.github.com/users/pranavbhole/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pranavbhole/subscriptions","organizations_url":"https://api.github.com/users/pranavbhole/orgs","repos_url":"https://api.github.com/users/pranavbhole/repos","events_url":"https://api.github.com/users/pranavbhole/events{/privacy}","received_events_url":"https://api.github.com/users/pranavbhole/received_events","type":"User","site_admin":false},"labels":[{"id":708607465,"node_id":"MDU6TGFiZWw3MDg2MDc0NjU=","url":"https://api.github.com/repos/yahoo/maha/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-09-07T22:32:14Z","updated_at":"2018-09-12T19:09:41Z","closed_at":null,"author_association":"MEMBER","body":"We found that high cardinality filter works better in the join clauses instead of fact only subquery clauses. \r\n\r\nRight now we are using highCardinalityFilters only in disqualifying the druid engine. It would be good use to optimize the query based on the HighCardinalityFilters. \r\n\r\nFor example: Following query performs better than IN subquery if hcf is high cardinality filter.\r\nselect * from fact \r\nleft outer join ( select id from dim where hcf in ('A')) dm on (fact.id=dm.id);\r\n\r\nselect * from \r\nfact where id in (select id from dim where hcf in ('A')); \r\n\r\n\r\n"}}
{"actor":{"display_login":"pranavbhole"}}