'How to retrieve array of objects in Elastic Search using PPL (Open Search) query
I have an array of objects inside ElasticSearch in signals field:
"ChargingStationID": "CS1",
"timestamp": "2019-06-03T14:51:38.009Z",
"signals": [
{
"signal": "Signal1",
"value": 286
},
{
"signal": "Signal2",
"value": 967
},
{
"signal": "Signal3",
"value": 662
},
{
"signal": "Signal4",
"value": 830
},
{
"signal": "Signal5",
"value": 572
},
{
"signal": "Signal6",
"value": 275
},
{
"signal": "Signal7",
"value": 278716166893
},
{
"signal": "Signal8",
"value": 368989185886
},
{
"signal": "Signal9",
"value": 96
}
]
}
I tried to get every object inside signals with following PPL (Piped Processing Language) query:
search source=my-index | where ChargingStationID='CS1' | fields signals
when I run PPL query above from Kibana Query Workbench I got only the first object of the signals array.
I don't know if is possible but I am stucking and there are no resources around the web focusing on it.
How can I get all values inside signals using PPL query?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
