Converting Mysql query to lucene query


(emma) #1

Hi I have some queries in mysql which need to be incorporated in Kibana.
I Imported table data from MySql to Elasticsearch

select a.r_date, a.failed_aborted_job, b.expired_trigger_job from

(select DATE(currenttime) as r_date,count(*) as FAILED_ABORTED_JOB from samsungautomation.tbl_hybris_cronjob where customstatus="FAILED_ABORTED_JOB" group by DATE(currenttime) ) as a,

(select DATE(currenttime) as r_date,count(*) as EXPIRED_TRIGGER_JOB from samsungautomation.tbl_hybris_cronjob where customstatus="EXPIRED_TRIGGER_JOB" group by DATE(currenttime) ) as b

where a.r_date=b.r_date


(system) #2

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