https://community.cloudera.com/t5/Support-Questions/Impala-Is-Not-Null-Doesn-t-Work-for-Views/m-p/66727#M13768 <P>For this simple query of a view,</P><P>&nbsp;</P><P>select * from view_name where column_name is not null;</P><P>&nbsp;</P><P>it is returning all records from the view (null and not null) in Impala.&nbsp; The condition is being ignored.&nbsp; Is there a work around for this?&nbsp; I've tried coalesce and nullif tricks and it still doesn't work and I still get all records from the view.&nbsp; The view was created using Hive.&nbsp; Does that make a difference?&nbsp; I don't have this problem when working with tables in Impala.</P> Fri, 16 Sep 2022 13:08:39 GMT mikeg 2022-09-16T13:08:39Z