Below is the query i have written in Oracle i need to write same in Elastic search.
select sum(total_count),datasource from
(select distinct faspdf_os_id,FASPDF_CUST_ID,FASPDF_PROD_ID,FASPDF_TIME_ID,total_count,datasource from fas_final_denom) group by datasource;
Please provide me the solution for this. I need this urgently
Any input will be really appreciated