Hi,
I have an Oracle table with state-change events for each job (these are computing jobs that we are running) in the format:
id | timestamp | job_nr | status | attempt_nr |
0 |27-NOV-21 01.10.56.678706000 AM|1 | start| 0 |
1 |27-NOV-21 01.20.45.812761000 AM|1| end | 0 |
2 |27-NOV-21 02.17.56.678706000 AM|1 | start| 1 |
3 |27-NOV-21 03.18.45.812761000 AM|1| end | 1 |
4 |28-NOV-21 01.10.56.678706000 AM|2 | start| 0 |
5 |28-NOV-21 01.20.45.812761000 AM|2| end | 0 |
6 |28-NOV-21 02.17.56.678706000 AM|2 | start| 1 |
7 |28-NOV-21 03.18.45.812761000 AM|2| end | 1 |
...
I would like to be able to plot things like (in brackets, example using the ids from the list above):
- job length (3 - 0, 7 -4, ..)
- attempt length (1 - 0, 3 - 2, ..)
- number of attempts per job
- max attempt number
...
I was thinking of nesting objects i.e. an object per job, but then I have realized that I cannot plot / visualize any of the plots mentioned above with nested object with Kibana.
Any idea how I should format the data in ES to get the plots I need in Kibana?
Cheers,
Ivan