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

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.

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

@999chris in any case, I've raised to improve the support for AVG like groupings.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.