Kibana Canvas DISTINCT key word

Elastic Stack Elasticsearch
1

I am trying to run following query as SQL . its erring saying DISTINCT is not allowed

SELECT DISTINCT ("context.correlationId" , gqlOperationName ) FROM "alpha-*" where isError ='1'

Can I any way achieve this in canvas /dashboard/visualization ?

2

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