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.
DURATIONMILLIS are fields in these indices?
@999chris in any case, I've raised https://github.com/elastic/elasticsearch/issues/36865 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.