Hi,
I’m trying to extract some data from an Elasticsearch instance through Elasticsearch/ Kibana data sources.
The structure of my data in elasticsearch is like the following:
{
“passicarrabili”: {
“mappings”: {
“doc”: {
“properties”: {
“cittadino”:{
“properties”:{
“nome”:{
“type”:“text”,
“fields”:{
“keyword”:{
“type”:“keyword”,
“ignore_above”:256
}
}
},
“cognome”:{
“type”:“text”,
“fields”:{
“keyword”:{
“type”:“keyword”,
“ignore_above”:256
}
}
},
(…) and so on.
The question is: does redash support nested fields? when I try to get results (without any filter) it returns something like this:
→ One Column representing only the first level key
→ Json-like output inside the column.
Is there anything that i’m missing? What can i do to get all columns separately?
Thank you very much
Giovanni