https://community.cloudera.com/t5/Support-Questions/Impala-Is-Not-Null-Doesn-t-Work-for-Views/m-p/67169#M13774 <P><SPAN>"where coalesce(company_name, aais_company_number) is not null" produces the same result because&nbsp;aais_company_number is never null so I still get all the records.</SPAN></P><P>&nbsp;</P><P><SPAN>We are using Hue 3.10 and I don't know which version of Impala comes with that.&nbsp; I just started working in this&nbsp;environment recently.</SPAN></P> Fri, 11 May 2018 12:07:34 GMT mikeg 2018-05-11T12:07:34Z