Hi Flavio,
do you execute this query in a batch or stream execution environment?
In any case this sounds very strange to me. But is it guarateed that it
is not the fault of the connector?
Regars,
Timo
Am 31.10.18 um 14:54 schrieb Flavio Pompermaier:
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
