{"action":"created","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/2152","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/2152/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/2152/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/2152/events","html_url":"https://github.com/metabase/metabase/issues/2152","id":141028119,"number":2152,"title":"NullPointerException when attempting to add a \"is not empty\" filter on a join","user":{"login":"NevilleS","id":1834295,"avatar_url":"https://avatars.githubusercontent.com/u/1834295?v=3","gravatar_id":"","url":"https://api.github.com/users/NevilleS","html_url":"https://github.com/NevilleS","followers_url":"https://api.github.com/users/NevilleS/followers","following_url":"https://api.github.com/users/NevilleS/following{/other_user}","gists_url":"https://api.github.com/users/NevilleS/gists{/gist_id}","starred_url":"https://api.github.com/users/NevilleS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NevilleS/subscriptions","organizations_url":"https://api.github.com/users/NevilleS/orgs","repos_url":"https://api.github.com/users/NevilleS/repos","events_url":"https://api.github.com/users/NevilleS/events{/privacy}","received_events_url":"https://api.github.com/users/NevilleS/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-15T16:31:27Z","updated_at":"2016-03-15T18:43:40Z","closed_at":null,"body":"I'm trying to run a query and specific a `NOT NULL` clause on a column (`sharer_id`) brought in from a join table (`Company Course`). In the question builder, I believe that's the same as specifying that the join tables column \"is not empty\", like so:\r\n![image](https://cloud.githubusercontent.com/assets/1834295/13785266/49c06042-eaa9-11e5-8e57-cf7d5474a80c.png)\r\n\r\nUnfortunately, a `NullPointerException` is thrown somewhere in the Metabase internals when I try to run this query :cry: \r\n\r\nI built a similar query using raw SQL and managed to get that working fine, so it seems to be related to the construction of the SQL based on the question config. This query runs correctly (once you swap out `<redacted>` for the schema name):\r\n![image](https://cloud.githubusercontent.com/assets/1834295/13785366/a7531e34-eaa9-11e5-8fa2-b85511b2b145.png)\r\n\r\n\r\n\r\n*  I am using the Chrome browser (v48.0.2564.116).\r\n*  My computer's OS is OSX 10.11.3.\r\n*  My database is Postgres.\r\n*  My Metabase version is v0.15.1.\r\n"},"comment":{"url":"https://api.github.com/repos/metabase/metabase/issues/comments/196968098","html_url":"https://github.com/metabase/metabase/issues/2152#issuecomment-196968098","issue_url":"https://api.github.com/repos/metabase/metabase/issues/2152","id":196968098,"user":{"login":"camsaul","id":1455846,"avatar_url":"https://avatars.githubusercontent.com/u/1455846?v=3","gravatar_id":"","url":"https://api.github.com/users/camsaul","html_url":"https://github.com/camsaul","followers_url":"https://api.github.com/users/camsaul/followers","following_url":"https://api.github.com/users/camsaul/following{/other_user}","gists_url":"https://api.github.com/users/camsaul/gists{/gist_id}","starred_url":"https://api.github.com/users/camsaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camsaul/subscriptions","organizations_url":"https://api.github.com/users/camsaul/orgs","repos_url":"https://api.github.com/users/camsaul/repos","events_url":"https://api.github.com/users/camsaul/events{/privacy}","received_events_url":"https://api.github.com/users/camsaul/received_events","type":"User","site_admin":false},"created_at":"2016-03-15T18:43:40Z","updated_at":"2016-03-15T18:43:40Z","body":"Hi @NevilleS can you give us the stacktrace from the console logs when the error is generated?"}}