Worked :D
Thanks a lot!
2013/7/10 Marcelo Elias Del Valle <mvall...@gmail.com>
> root_id is a dynamic field... But should the type of the field change
> according to the values? Because using the same configuration but using
> "room1" as value, it works.
>
> Let me compare the configurations:
>
> <field name="id" type="string" indexed="true" stored="true"
> required="true" multiValued="false" />
>
> <dynamicField name="*" type="text_general" multiValued="true" />
>
> Indeed, one is text_general and the other is string... I will try to
> create a fixed field root_id and check if it works...
>
> Thanks for the hint!
>
>
>
> 2013/7/10 Erick Erickson <erickerick...@gmail.com>
>
>> What kind of field is root_id? If it's tokenized or not the
>> same type as id, that could account for it.
>>
>> Best
>> Erick
>>
>> On Tue, Jul 9, 2013 at 7:34 PM, Marcelo Elias Del Valle
>> <mvall...@gmail.com> wrote:
>> > Hello,
>> >
>> > I am trying to create a POC to test query joins. However, I was
>> > surprised when I saw my test worked with some ids, but when my document
>> ids
>> > are UUIDs, it doesn't work.
>> > Follows an example, using solrj:
>> >
>> > SolrInputDocument doc = new SolrInputDocument();
>> > doc.addField("id", "bcbaf9eb-0da7-4225-be24-2b9472ad2c20");
>> > doc.addField("cor_parede", "branca");
>> > doc.addField("num_cadeiras", 34);
>> > solr.add(doc);
>> >
>> > // Add children
>> > SolrInputDocument doc2 = new SolrInputDocument();
>> > doc2.addField("id", "computador1");
>> > doc2.addField("acessorio1", "Teclado");
>> > doc2.addField("acessorio2", "Mouse");
>> > doc2.addField("root_id", "bcbaf9eb-0da7-4225-be24-2b9472ad2c20");
>> > solr.add(doc2);
>> >
>> > When I execute:
>> >
>> > ///select
>> >
>> params={start=0&rows=10&q=cor_parede%3Abranca&fq=%7B%21join+from%3Droot_id+to%3Did%7Dacessorio1%3ATeclado}
>> > SolrQuery query = new SolrQuery();
>> >
>> > query.setStart(0);
>> > query.setRows(10);
>> > query.set("q", "cor_parede:branca");
>> > query.set("fq", "{!join from=root_id to=id}acessorio1:Teclado");
>> >
>> > QueryResponse response = DGSolrServer.get().query(query);
>> > long numFound = response.getResults().getNumFound();
>> >
>> > it returns zero results. However, if I use "room1" for first
>> > document's id and for root_id field on second document, it works.
>> >
>> > Any idea why? What am I missing?
>> >
>> > Best regards,
>> > --
>> > Marcelo Elias Del Valle
>> > http://mvalle.com - @mvallebr
>>
>
>
>
> --
> Marcelo Elias Del Valle
> http://mvalle.com - @mvallebr
>
--
Marcelo Elias Del Valle
http://mvalle.com - @mvallebr
