lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Faire Mii <faire....@gmail.com>
Subject preserve relational strucutre in solr?
Date Mon, 14 Dec 2009 13:34:17 GMT
  was able to import data through solr DIH.

in my db i have 3 tables:

threads: id tags: id thread_tag_map: thread_id, tag_id

i want to import the many2many relationship (which thread has which  
tags) to my solr index.

how should the query look like.

i have tried with following code without result:

<entity name="thread_tags"
         query="select * from threads, tags, thread_tag_map where  
thread_tag_map.thread_id = threads.id AND thread_tag_map.tag_id =  
tags.id">
</entity>

s this the right way to go?

i thought that with this query each document will consist of tread and  
all the tags related to it. and i could do a query to get the specific  
thread by tagname.


thanks!
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message