Please help with Elasticsearch SQL Error: "Does not know how to convert argument Div[] for function Max[]"

Elastic Stack Elasticsearch
1

I'm getting the error on the following:

SELECT AVG(((dateupdated-datecreated) + 0.0) / (DURATIONMILLIS + 0.0)) AS "Ratio" FROM "mip*" WHERE key = 'ottvod' AND WORKFLOWSTATUSID = 0 GROUP BY 'PROVIDERID'

Elasticsearch SQL is (I suppose understandably, not very well documented) so I cant find a way around this err.

2

@999chris dateupdated, datecreated and DURATIONMILLIS are fields in these indices?

3

@999chris in any case, I've raised https://github.com/elastic/elasticsearch/issues/36865 to improve the support for AVG like groupings.