pauladams12345 commented on issue #15255: URL: https://github.com/apache/pinot/issues/15255#issuecomment-2748088393
@Jackie-Jiang > Thanks for reporting the issue. Have you tried this on a DOUBLE dimension with null values? Yes, `floatDecimal` works correctly on DOUBLE columns. > Can you also try this without `SET enableNullHandling=TRUE;`? The same error is returned when enableNullHandling is disabled. @mghildiy > I made some changes in code, and result for following query: > > ``` > SET enableNullHandling=TRUE; > SELECT roundDecimal(floatfield, 1) FROM testnullfloat; > ``` > > ...is > > ``` > rounddecimal(floatfield,'1') > 1.4 > null > ``` > > Is it good enough result? That appears to be the correct result. If a field is null, calling `floatDecimal` on that field should return null. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
