Vertica Quick Tip: How to Query for NaN Values
Posted: Fri Jan 26, 2018 2:17 pm
Vertica Community Blog post authored by Jim Knicely
Read more here:
https://forum.vertica.com/discussion/23 ... nan-values
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