How to visualize "terms lookup twitter example" in kibana

Elastic Stack Kibana
1

Elasticsearch reference gives a good example to combine 2 indices between tweets and users.
GET /tweets/_search
{
"query" : {
"terms" : {
"user" : {
"index" : "users",
"type" : "user",
"id" : "2",
"path" : "followers"
}
}
}
}
ref link:
https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-terms-query.html
I have similar query and want to monitor the change daily, is it possible to visualize this kind of query in kibana?

Thanks,
Shun

2

let's follow the reference you pasted:

in kibana i go to Dev Tools and execute the following two queries:

PUT /users/user/2
{
    "followers" : ["1", "3"]
}

PUT /tweets/tweet/1
{
    "user" : "1"
}

you could try adding more users and tweets ...

then go to Management/Index Patterns and add two new index patterns: users and tweets.

now go to the Discover and select tweets index pattern and enter this into your search:

{"terms":{"user":{"id":"2","index":"users","path":"followers","type":"user"}}}

you can Save this search now and use it in visualizations.

1 Like
3

Thank you, it is great, this shows me the light of dawn.
Further, I want to sum up each user by id and draw the increasing/decreasing trends daily in a chart.

4

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