Hello everybody, i would like to know how to create index supporting a
parent/child mapping and then querying the child to get the results.
in other words; imagine that we have a database containing 2
tables:Keyword[id(int), value(string)] and Result[id(int), res_url(text),
res_text(tex), res_date(date), res_rank(int)]
For indexing, i used the DataImportHandler to import data and it works well,
and my query response seems good:(q=*:*) (imagine that we have only this to
keywords and their results)
<?xml version="1.0" encoding="UTF-8" ?>
- <response>
- <lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">0</int>
- <lst name="params">
<str name="q">*:*</str>
</lst>
</lst>
- <result name="response" numFound="2" start="0">
- <doc>
<str name="id">1</str>
<str name="keyword">Key1</str>
- <arr name="res_url">
<str>url1</str>
<str>url2</str>
<str>url3</str>
<str>url4</str>
</arr>
- <arr name="res_rank">
<str>1</str>
<str>2</str>
<str>3</str>
<str>4</str>
</arr>
</doc>
- <doc>
<str name="id">2</str>
<str name="keyword">Key2</str>
- <arr name="res_url">
<str>url1</str>
<str>url5</str>
<str>url8</str>
<str>url7</str>
</arr>
- <arr name="res_rank">
<str>1</str>
<str>2</str>
<str>3</str>
<str>4</str>
</arr>
</doc>
</result>
</response>
but the problem is when i tape a query kind of this:"q=res_url:url2 AND
res_rank:1" and this to say that i want to search for the keywords in which
the url (url2) is ranked at the first position, i have a result like this:
<?xml version="1.0" encoding="UTF-8" ?>
- <response>
- <lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">0</int>
- <lst name="params">
<str name="q">res_url:url2 AND res_rank:1</str>
</lst>
</lst>
- <result name="response" numFound="1" start="0">
- <doc>
<str name="id">1</str>
<str name="keyword">Key1</str>
- <arr name="res_url">
<str>url1</str>
<str>url2</str>
<str>url3</str>
<str>url4</str>
</arr>
- <arr name="res_rank">
<str>1</str>
<str>2</str>
<str>3</str>
<str>4</str>
</arr>
</doc>
</result>
</response>
But this is not true; because the url present in the 1st position in the
results of the keyword "key1" is url1 and not url2.
So what i want to say is : is there any solution to make the values of the
"multivalued" fields linked;
so in our case we can see that the previous result say that:
- url1 is present in 1st position of "key1" results
- url2 is present in 2nd position of "key1" results
- url3 is present in 3rd position of "key1" results
- url4 is present in 4th position of "key1" results
and i would like that solr consider this when executing queries.
Any helps please; and thanks for all :)
--
View this message in context:
http://old.nabble.com/how-to-do-a-Parent-Child-Mapping-using-entities-tp26956426p26956426.html
Sent from the Solr - User mailing list archive at Nabble.com.
