No. Lucene is a text search engine, NOT a RDBMS. Whenever you think of joins (self or otherwise), you're thinking in RDMBS terms, which Lucene is not. At best, you'll have to use one of the DB integrations that Steve mentioned (assuming they work). But I wouldn't keep looking for any magic internal to Lucene to solve this problem.
On 12/28/06, Kapil Chhabra <[EMAIL PROTECTED]> wrote:
Hi Steve, Thanks for the response. Actually I am not looking for a query language. My question is, whether Lucene supports Nested Queries or self joins? As per http://lucene.apache.org/java/docs/api/org/apache/lucene/queryParser/QueryParser.html In BNF, the query grammar is: Query ::= ( Clause )* Clause ::= ["+", "-"] [<TERM> ":"] ( <TERM> | "(" Query ")" ) Which means that FIELD2:(FIELD2:3) is a correct query. Correct me if I am wrong. What will this query translate into? Will it be same as FIELD2: 1 OR FIELD2: 2 Thanks kapilChhabra Steven Rowe wrote: > Hi Kapil, > > Kapil Chhabra wrote: > >> Just to mention, I have tokenized FIELD2 on "," and indexed it. >> >> FIELD2:3 should return 1,2 >> FIELD2:(FIELD2:3) should return something like the output of: >> >> *FIELD2: 1 OR FIELD2: 2 >> > > Given your data table, I assume you mean: > > FIELD1:3 should return 1,2 > FIELD1:(FIELD2:3) should return something like the output of: > > *FIELD1: 1 OR FIELD1: 2 > > If you make FIELD1 stored, and search using "FIELD2:3", you can iterate > through the hits and return the values for FIELD1. > > Are you looking for a query language that does this work for you? That > is, one which can query on any field and then return information from > other field(s) in matching documents? If so, I don't know of such a > query language that exists for Lucene. > > There have been several integrations of Lucene with databases, some of > which enable SQL queries something like: > > SELECT FIELD1 WHERE FIELD2 CONTAINS('3'); > > 1. Marcelo Ochoa's Oracle JVM implementation for Lucene DataStore: > <http://issues.apache.org/jira/browse/LUCENE-724>; see also these > threads on the Lucene Java-Users list: > <http://www.nabble.com/Oracle-and-Lucene-Integration-tf2689965.html> > <http://www.nabble.com/Oracle-Lucene-integration--status--tf2865873.html > > > 2. Mark Harwood's Lucene database bindings for HSQLDB and Derby: > <http://issues.apache.org/jira/browse/LUCENE-434>; see also this thread > on the Lucene Java-Users list: > <http://www.nabble.com/Lucene-database-bindings-tf316816.html> > > 3. Hibernate (as of v3.1, I think) Lucene Integration: > < http://www.hibernate.org/hib_docs/annotations/reference/en/html/lucene.html > > > 4. DBSight enables Lucene search with databases: < http://www.dbsight.net/> > > > Hope it helps, > Steve > > >> Kapil Chhabra wrote: >> >>> Hi, >>> >>> Please see the following data-structure >>> +--------+----------+ >>> | FIELD1 | FIELD2 | >>> +--------+----------+ >>> | 1 | 2,3,4,6, | >>> | 2 | 3,1,5,7, | >>> | 3 | 1,2, | >>> | 4 | 1,8,10, | >>> | 5 | 2,9, | >>> | 6 | 1, | >>> | 7 | 2,9, | >>> | 8 | 4,9, | >>> | 9 | 5,7,8, | >>> | 10 | 4, | >>> +--------+----------+ >>> >>> My requirement is to find all values in FIELD1 where FIELD2 contains >>> all values of FIELD1 where FIELD2 contains 3 >>> Which means something like >>> FIELD2:(FIELD2:3) >>> >>> Is it possible to achieve this in a single query? If yes, then how >>> should I go about it? >>> >>> >>> >>> Thanks in anticipation, >>> kapilChhabra >>> >>> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > >
