https://community.cloudera.com/t5/Support-Questions/Impala-Is-Not-Null-Doesn-t-Work-for-Views/m-p/67145#M13773 <P>The IS NOT NULL predicate is not placed correcly in the execution plan, that's why the result are wrong. We've fied many similar issues, chances are this one is known and fixed. I will need to confirm. What version of Impala are you running?</P><P>&nbsp;</P><P>You might be able to work around the issue like this.</P><P>Instead of "<SPAN>where company_name is not null" use "where coalesce(company_name, aais_company_number) is not null".<BR /></SPAN></P><P>You might need to "cast(aais_company_number as string)"</P><P>&nbsp;</P><P>I understand it's not pretty but hopefully it does the trick.</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 10 May 2018 21:49:10 GMT alex.behm 2018-05-10T21:49:10Z