: thanks for your help so do you think I should execute solr queries twice ?
: or is there any other workarounds
http://people.apache.org/~hossman/#xyproblem
XY Problem
Your question appears to be an "XY Problem" ... that is: you are dealing
with "X", you are assuming "Y" will help you, and you
From: Mark N [nipen.m...@gmail.com]
Sent: Monday, November 30, 2009 4:36 AM
To: solr-user@lucene.apache.org
Subject: Re: nested solr queries
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 Shek
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.
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 wrote:
>
> > field2="xyz" we dont know until we run qu
On Mon, Nov 30, 2009 at 2:26 PM, Mark N 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 *fi
field2="xyz" we dont know until we run query1
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
On Mon, Nov 30, 2009 at 2:02 PM, Mark N wrote:
> hi shalin
>
> I am trying to achieve something like JOIN. Previously am doing this with
> two queries on solr
>
> solr index = ( field1 ,field 2, field3)
>
> query1 = ( for example field1="ABC" )
>
> suppose query1 returns results set1= { 1, 2 ,
hi shalin
I am trying to achieve something like JOIN. Previously am doing this with
two queries on solr
solr index = ( field1 ,field 2, field3)
query1 = ( for example field1="ABC" )
suppose query1 returns results set1= { 1, 2 ,3 ,4 } which matches query1
query2 = ( get all records having
On Mon, Nov 30, 2009 at 1:19 PM, Mark N wrote:
> Is it possible to write nested queries in Solr similar to sql like query
> where I can take results of the first query and use one or more of its
> fields as an argument in the second query.
>
>
That sounds like a join. If so, the answer would be
Is it possible to write nested queries in Solr similar to sql like query
where I can take results of the first query and use one or more of its
fields as an argument in the second query.
For example:
field1:XYZ AND (_query_: field3:{value of field4})
This should search for all types of XYZ and
10 matches
Mail list logo
