Need advice to translate a SQL request to a REST code


(Justine Stienne Houplines Wh ) #1

Hello, All

I'm a beginner in Elasticsearch technology.

Below, is my ORACLE's SQL code I want to translate in a REST Elasticsearch

SELECT tra_process_type_name, E.EXC_NAME,
sum(decode(TRA_STATUS, 'C', 1, 0)) AS TRA_COUNT_C,
max (tra_timestamp_last) AS TIMESTAMP
FROM oxy_trace
WHERE TRA_TIMESTAMP_FIRST between {ts '2015-05-01 00:00:00.0'} and {ts '2015-05-07 00:00:00.0'} AND TRA_TIMESTAMP_LAST > {ts '2015-05-01 00:00:00.0'}
GROUP BY tra_process_type_name, E.EXC_NAME
ORDER BY TIMESTAMP DESC

Could you help me ?

Is a tool can translate, in automatic mode, a SQL code to ELK REST code ?

Thanks a lot
Regards
Justine


(system) #2