We’re introducing a new series: Vertica Quick Tips! These tips are intended to give you concise information to help you get the most out of using Vertica.
NaN (Not a Number) does not equal anything, not even another NaN. You can query for them using the predicate … WHERE column != column
Read more here:
https://forum.vertica.com/discussion/23 ... nan-values