0

Our application support the View model, as you know, each View has its own query to filter the data that should appear in this View from DB.

And Our business require us to create a separate lucene index directory for each table in the DB.

Now am planning to use the full text index to retrieve and filter this View data. is that possible to join between this separate index directories ? if so, then how could i do this ?

Salah
  • 8,567
  • 3
  • 26
  • 43

1 Answers1

2

You can search multiple indexes at once using a MultiReader. Just open readers normally on each of the indexes, and create the MultiReader, passing those readers into the constructor, like:

IndexReader reader1 = DirectoryReader.open(directory1);
IndexReader reader2 = DirectoryReader.open(directory2);
MultiReader multiReader = new MultiReader(reader1, reader2);
IndexSearcher searcher = new IndexSearcher(multiReader);
femtoRgon
  • 32,893
  • 7
  • 60
  • 87
  • thanks a lot for your answer, now my question is, can i perform a join mechanism (rational database join) on this two directories ? – Salah Nov 25 '13 at 06:55
  • 1
    Yes, there is some support for joins. Of course, Lucene isn't really relational, so it's all cobbled together as a method of emulating an RDB, but have a look at [`JoinUtil`](http://lucene.apache.org/core/4_3_0/join/org/apache/lucene/search/join/JoinUtil.html) – femtoRgon Nov 25 '13 at 14:52