Hi,
We have a system very much like Google Forms, which allow users to design
their own forms with various fields (single line text, paragraph, number,
address etc, you can imagine that.) Without any doubt, it's running on top
of MongoDB. Now it has 120K forms with nearly 10 million entries.
Recently we found a performance bottleneck on the query. After we have done
every possible performance tuning on mongoDB side, we decide to index the
form entries into elastic search. And there is a trouble:
Given there is a Form A, has field_1 as string type, field_2 as number, the
data entry might look like: { field_1: "hello", field_2: 100}
Form B could be field_1 as number, field_2 as number, the date entry will
look like { field_1: 100, field_2: "hello form"}
We have successfully create an index "entries" in ES, and can index the
first entry successfully. But the second one failed for an obvious reason:
type mismatch.
I am not sure how to deal with this problem. I definitely don't want to
create 120K indices for every single form. And I am not sure it's doable to
write custom transform script to change the index type identical across all
entries.
Any suggestion? Much appreciate any response.
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/4a6d47d7-ae0e-44f5-bd3a-756ea94e3899%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
