aleksi75 opened a new issue, #15562:
URL: https://github.com/apache/druid/issues/15562
It seems, that using a column in the WHERE clause with a division causes an:
Division undefined (java.lang.ArithmeticException)
### Affected Version
28.0.0
### Description
Just rolled out Druid 28.0.0 on our TST cluster. After all services startet
I tried out 'Druid Doctor' from WebUI and got an error with one of the last
checks where Historical SegmentCache size is checked. In PROD we are running
Druid 27.0.0 and there everything works fine. The configuration of 28.0.0
depending the new SQL features is 'legacy', it should work like 27.0.0. On the
other hand, I do not think it has something to do with the new 'SQL
Compatibility' Features.
Query looks something like that:
``````
SELECT
"server" AS "service",
"curr_size",
"max_size",
"curr_size" * 1.0 / "max_size" AS "fill"
FROM sys.servers
WHERE "server_type" = 'historical' AND "curr_size" * 1.0 / "max_size" > 0.2
ORDER BY "server" DESC
``````
I tested a little bit in the query editor tab and found out:
- Division works in SELECT for the 'fill' alias
- If I exchange the column 'max_size' with the real value (in our case
60000000000) the query works
- If I do not use '/' but eg '+' the query works (but make no sense =)
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
