Nested objects? Or not possible in Kibana?

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

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