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]
