Hello, I'd like to show the additional information on Kibana Visualize close to Buckets's X-axis.
Currently, my X-axis result is document's ids. (That is parent data)
These documents have children documents. (But we don't use join feature)
I'd like to show the information which is children document data that is searched by Bucket's X-axis result's id.
For example, below data's parent id is '562c1ea71b85c270'.
finally, I'd like to show children data's tags.graphql.source
information (I need to take first 10 - 20 words).
I think we need to write some script for fetching this information.
By the way, Kibana Visualize can be queried by Buckets's X-axis result and then just showing?
How we do this kind of complicated visualization?
Thank you so much.
mapping
{
"zipkin-span-2021-10-18":{
"aliases":{
},
"mappings":{
"_source":{
"excludes":[
"_q"
]
},
"dynamic_templates":[
{
"strings":{
"match":"*",
"match_mapping_type":"string",
"mapping":{
"ignore_above":256,
"norms":false,
"type":"keyword"
}
}
}
],
"properties":{
"_q":{
"type":"keyword"
},
"annotations":{
"type":"object",
"enabled":false
},
"duration":{
"type":"long"
},
"id":{
"type":"keyword",
"ignore_above":256
},
"kind":{
"type":"keyword",
"ignore_above":256
},
"localEndpoint":{
"dynamic":"false",
"properties":{
"serviceName":{
"type":"keyword"
}
}
},
"name":{
"type":"keyword"
},
"parentId":{
"type":"keyword",
"ignore_above":256
},
"remoteEndpoint":{
"dynamic":"false",
"properties":{
"serviceName":{
"type":"keyword"
}
}
},
"tags":{
"type":"object",
"enabled":false
},
"timestamp":{
"type":"long"
},
"timestamp_millis":{
"type":"date",
"format":"epoch_millis"
},
"traceId":{
"type":"keyword"
}
}
},
"settings":{
"index":{
"number_of_shards":"5",
"provided_name":"zipkin-span-2021-10-18",
"creation_date":"1634536102682",
"requests":{
"cache":{
"enable":"true"
}
},
"number_of_replicas":"1",
"uuid":"ZN66UyddS8-YFlSly6M-5Q",
"version":{
"created":"7090399"
}
}
}
}
}
parent document
curl -s 'localhost:9200/zipkin*/_search?q=id:6173b7140ef7d23f'
{
"took":2,
"timed_out":false,
"_shards":{
"total":5,
"successful":5,
"skipped":0,
"failed":0
},
"hits":{
"total":{
"value":1,
"relation":"eq"
},
"max_score":3.1780539,
"hits":[
{
"_index":"zipkin-span-2021-10-18",
"_type":"_doc",
"_id":"6c4bd64364ca942608948c00212c0c9a-2abaeb0c1767e3169a0014169fe4a420",
"_score":3.1780539,
"_source":{
"traceId":"6c4bd64364ca942608948c00212c0c9a",
"duration":224484,
"localEndpoint":{
"serviceName":"unknown_service:node"
},
"timestamp_millis":1634536273448,
"kind":"SERVER",
"name":"http post",
"id":"562c1ea71b85c270",
"timestamp":1634536273448577,
"tags":{
"http.flavor":"1.1",
"http.host":"localhost:3000",
"http.method":"POST",
"http.request_content_length_uncompressed":"163",
"http.route":"/graphql",
"http.status_code":"200",
"http.status_text":"OK",
"http.target":"/graphql",
"http.url":"http://localhost:3000/graphql",
"http.user_agent":"PostmanRuntime/7.28.4",
"net.host.ip":"::1",
"net.host.name":"localhost",
"net.host.port":"3000",
"net.peer.ip":"::1",
"net.peer.port":"50754",
"net.transport":"ip_tcp",
"ot.status_code":"OK",
"service.name":"unknown_service:node",
"telemetry.sdk.language":"nodejs",
"telemetry.sdk.name":"opentelemetry",
"telemetry.sdk.version":"0.24.0"
}
}
}
]
}
}
children data
curl -s 'localhost:9200/zipkin*/_search?q=parentId:562c1ea71b85c270'
{
"took":4,
"timed_out":false,
"_shards":{
"total":5,
"successful":5,
"skipped":0,
"failed":0
},
"hits":{
"total":{
"value":18,
"relation":"eq"
},
"max_score":2.7725885,
"hits":[
{
"_index":"zipkin-span-2021-10-18",
"_type":"_doc",
"_id":"6c4bd64364ca942608948c00212c0c9a-005a0a2a214d24489f5114739494d0e1",
"_score":2.7725885,
"_source":{
"traceId":"6c4bd64364ca942608948c00212c0c9a",
"duration":565,
"localEndpoint":{
"serviceName":"unknown_service:node"
},
"timestamp_millis":1634536273450,
"name":"middleware - query",
"id":"486eeec3b920a9a0",
"parentId":"562c1ea71b85c270",
"timestamp":1634536273450807,
"tags":{
"express.name":"query",
"express.type":"middleware",
"http.route":"/",
"ot.status_code":"UNSET",
"service.name":"unknown_service:node",
"telemetry.sdk.language":"nodejs",
"telemetry.sdk.name":"opentelemetry",
"telemetry.sdk.version":"0.24.0"
}
}
},
{
"_index":"zipkin-span-2021-10-18",
"_type":"_doc",
"_id":"6c4bd64364ca942608948c00212c0c9a-89b8a9320b388356696bca9526537134",
"_score":2.7725885,
"_source":{
"traceId":"6c4bd64364ca942608948c00212c0c9a",
"duration":247,
"localEndpoint":{
"serviceName":"unknown_service:node"
},
"timestamp_millis":1634536273592,
"name":"graphql.parse",
"id":"84b6623ee1b43a9d",
"parentId":"562c1ea71b85c270",
"timestamp":1634536273592592,
"tags":{
"graphql.source":"query Projects {\n __typename\n projects {\n __typename\n id\n name\n code\n photoID\n }\n}",
"ot.status_code":"UNSET",
"service.name":"unknown_service:node",
"telemetry.sdk.language":"nodejs",
"telemetry.sdk.name":"opentelemetry",
"telemetry.sdk.version":"0.24.0"
}
}
},
{
"_index":"zipkin-span-2021-10-18",
"_type":"_doc",
"_id":"6c4bd64364ca942608948c00212c0c9a-62fd79571b7d4c72f0fb8bc1d0973a62",
"_score":2.2735975,
"_source":{
"traceId":"6c4bd64364ca942608948c00212c0c9a",
"duration":303,
"localEndpoint":{
"serviceName":"unknown_service:node"
},
"timestamp_millis":1634536273453,
"name":"middleware - use",
"id":"43a5203c6649943e",
"parentId":"562c1ea71b85c270",
"timestamp":1634536273453045,
"tags":{
"express.name":"use",
"express.type":"middleware",
"http.route":"/",
"ot.status_code":"UNSET",
"service.name":"unknown_service:node",
"telemetry.sdk.language":"nodejs",
"telemetry.sdk.name":"opentelemetry",
"telemetry.sdk.version":"0.24.0"
}
}
},
{
"_index":"zipkin-span-2021-10-18",
"_type":"_doc",
"_id":"6c4bd64364ca942608948c00212c0c9a-10f1e84a8a8690dc2dff92bfe99fe85c",
"_score":2.2735975,
"_source":{
"traceId":"6c4bd64364ca942608948c00212c0c9a",
"duration":868,
"localEndpoint":{
"serviceName":"unknown_service:node"
},
"timestamp_millis":1634536273453,
"name":"middleware - use",
"id":"d38ec1ec9a8e905e",
"parentId":"562c1ea71b85c270",
"timestamp":1634536273453532,
"tags":{
"express.name":"use",
"express.type":"middleware",
"http.route":"/",
"ot.status_code":"UNSET",
"service.name":"unknown_service:node",
"telemetry.sdk.language":"nodejs",
"telemetry.sdk.name":"opentelemetry",
"telemetry.sdk.version":"0.24.0"
}
}
}
]
}
}