How to validate elastic search data with sql data after migration from sql to elastic search

Question

Anyone who have worked on elastic search. need input as mentioned in subject. I have one requirement in which sql data is migrated to elastic Search now there is ton of data so I can not check each and every field manually. So what is best way to test migrated data with sql.

This might help: stackoverflow.com/questions/22034722/…

Val
– Val

2017-12-12 06:23:54 +00:00
Commented Dec 12, 2017 at 6:23 — Val
– Val, Commented Dec 12, 2017 at 6:23

Tamas Szasz · Accepted Answer · 2017-12-12 06:23:55Z

0

Try to implement 2 scripts which will result exactly the same output from mysql and elasticsearch. Make sure, formatting, ordering matches. At the end you should be able to diff the files or do md5sum on them to compare.

answered Dec 12, 2017 at 6:23

Tamas Szasz

3865 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

anky Over a year ago

Hi Tamas can you suggest which technology would be better for comparing it

anky Over a year ago

Thank you guys for your help. I have done it using JAVA and JUnit.

Collectives™ on Stack Overflow

How to validate elastic search data with sql data after migration from sql to elastic search

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related