check out the videos on this website TROO.TUBE don't be such a sheep/zombie/loser/NPC. Much love! https://troo.tube/videos/watch/aaa64864-52ee-4201-922f-41300032f219
On Tue, May 12, 2020 at 3:35 AM Jan Høydahl <jan....@cominvent.com> wrote: > > Note that my example is simplified. Both the parent and child docs need to > have globally unique ‘id’ fields, and any field names used both in parent and > child needs to have same fieldType in schema. > There was some plans to automatically generate IDs for child documents if > they do not exist, but I think that is not yet done. Perhaps you can add the > UUID processor for this purpose? > > <processor class="solr.UUIDUpdateProcessorFactory"> > <str name="fieldName">id</str> > </processor> > Jan > > > 12. mai 2020 kl. 07:03 skrev Vignan Malyala <dsmsvig...@gmail.com>: > > > > Thanks Jan! This helps a lot! > > > > Sai Vignan Malyala > > > > On Mon, May 11, 2020 at 5:07 PM Jan Høydahl <jan....@cominvent.com> wrote: > > > >> Sounds like you are looking for parent/child docs here, see > >> https://lucene.apache.org/solr/guide/8_5/indexing-nested-documents.html > >> > >> { > >> "type": "user", > >> "name": "user1", > >> "products": [ > >> { "id": "prod_A", "cost": 50}, > >> { "id": "prod_B", "cost": 200}, > >> { "id": "prod_D", "cost": 25} > >> ] > >> } > >> > >> This will index 4 documents - one user document and three product-cost > >> child documents. > >> > >> You can then search the child docs and return matching parents with e.g. > >> q=*:*&fq={!parent which="type:user"}((id:prod_A AND cost:[50 TO 100]) OR > >> (id:prod_D AND cost:[0 TO 40]))&fl=[child] > >> > >> Hope this helps. > >> > >> Jan > >> > >>> 11. mai 2020 kl. 11:35 skrev Vignan Malyala <dsmsvig...@gmail.com>: > >>> > >>> 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 > >>>> > >> > >> >