Elasticsearch how to save user and it's tweets

Welcome! :smiley:

Are you asking us a question here, or just sharing a link?

i am asking a question. and my question is
I have two tables in MySQL. 1st table is users and 2nd table is posts. posts contain a user_id column. can anyone explain data structure of my index? I am using elasticsearch 7.5 version

Easiest way is to denormalize and store the user data with every tweet. This causes some duplication of data but gives fast queries and scales well.

if user change his name then how update user name in tweets

Use update by query. Assuming updates are reasonably infrequent you trade a bit more update work for simpler and faster queries.

1 Like

okay thank you :slight_smile:

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