Could you use a multi-valued field for user in each of your products?
So productA and a field User that is a list of all the users that have
productA. Then you could do a search like:
user:User1 AND Product_A_cost:[5 TO 10]
user:(User1 User5...) AND Product_B_cost[0 TO 40]
-Joe
On 5/11/2020 5:35 AM, Vignan Malyala wrote:
I have around 1M products used by my clients.
Client need a filter of these 1M products by their cost filters.
Just like:
User1 has 5 products (A,B,C,D,E)
User2 has 3 products (D,E,F)
User3 has 10 products (A,B,C,H,I,J,K,L,M,N,O)
...every customer has different sets.
Now they want to search users by filter of product costs:
Product_A_cost : 50 TO 100
Product_D_cost : 0 TO 40
it should return all the users who use products in this filter range.
As I have 1M products, do I need to create dynamic fields for all users
with filed names as Product_A_cost and product_B_cost..... etc to make a
search by them? If I should, then I haveto create 1M dynamic fields
Or is there any other way?
Hope I'm clear here!
On Mon, May 11, 2020 at 1:47 PM Jan Høydahl <jan....@cominvent.com> wrote:
Sounds like an anti pattern. Can you explain what search problem you are
trying to solve with this many unique fields?
Jan Høydahl
11. mai 2020 kl. 07:51 skrev Vignan Malyala <dsmsvig...@gmail.com>:
Hi
Is it good idea to create 100000 dynamic fields of time pint in solr?
I have that many fields to search on actually which come upon based on
users.
Thanks in advance!
And I'm using Solr Cloud in real-time.
Regards,
Sai Vignan M
