Kibana Canvas DISTINCT key word

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 ?

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