I don't know the use-case so I cannot suggest anything. Solr is different from relational databases and techniques which are taken for granted in the RDBMS world are usually not required or have bad performance characteristics. You shouldn't try to solve problems the same way in solr and databases.
You have told us that you need to do joins but you haven't told us *why* you need to do joins. There maybe other ways of solving the same problem. If not, two queries may be the only way to go. On Mon, Nov 30, 2009 at 3:06 PM, Mark N <nipen.m...@gmail.com> wrote: > thanks for your help so do you think I should execute solr queries twice ? > or is there any other workarounds > > > > > On Mon, Nov 30, 2009 at 3:07 PM, Shalin Shekhar Mangar < > shalinman...@gmail.com> wrote: > > > On Mon, Nov 30, 2009 at 2:26 PM, Mark N <nipen.m...@gmail.com> wrote: > > > > > field2="xyz" we dont know until we run query1 > > > > > > > > Ah, ok. I thought xyz was a literal that you wanted to search. > > > > > > > To simply i was actually trying to do some kind of JOIN similar to > > > following > > > SQL query > > > > > > > > > select * from table1 where *field2* in > > > ( select *field2 *from dbo.concept_db where field1='ABC' ) > > > > > > if this is not possible then i will have to search inner query ( > > > select *field2 > > > *from dbo.concept_db where field1='ABC' ) first and then only run the > > > outer query > > > > > > > > No, there are no joins in Solr. Consider de-normalizing your schema, if > you > > haven't. > > > > -- > > Regards, > > Shalin Shekhar Mangar. > > > > > > -- > Nipen Mark > -- Regards, Shalin Shekhar Mangar.
