Page 1 of 1

Vertica Quick Tip: How to Query for NaN Values

Posted: Fri Jan 26, 2018 2:17 pm
by JimKnicely
Vertica Community Blog post authored by Jim Knicely
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: ... nan-values