Hi to all, I'm using Flink 1.6.1 and I get different results when running the same query on the same static dataset. There are times that I get a 'NaN' as result of a select field-expression, while other times I get a valid double. How is this possible? This seems to happen only when I execute a complex query while it does not happen when I isolate the 2 select clause causing the error (i.e.: *SELECT* ROUND(STDDEV_POP(CAST(imposteResidue AS DOUBLE)),2), SUM(CASE WHEN field1 IS NULL THEN 1 ELSE 0 END) *FROM* T1)
Best, Flavio