Re: Lucene join

2012-08-28 Thread Martijn v Groningen
Lucene isn't a relation database. However there are some methods to have a relational like search: 1) Index time joins: http://blog.mikemccandless.com/2012/01/searching-relational-content-with.html 2) Query time joins: http://www.searchworkings.org/blog/-/blogs/query-time-joining-in-lucene Martijn

Re: Lucene join

2012-08-27 Thread Stephen Howe
Trupti, Looking over your sample query, that looks like you're trying to do a SQL query against a database instead of a Lucene query. If you're going against a SQL database, Lucene isn't a good tool for the problem you've outlined. If you're using SQL, you can do multiple joins to link multiple ta

Lucene join

2012-08-27 Thread Trupti Ghuge
Hi, I am new to Lucene. I have a complex query where I need to join more than two tables and have different filtering criteria on it. Is it possible to use Lucene for this ? For example , my query is as follows(there is no foreing key relation on the tables): Select x.id from tablex x, ta