>>does it deal w/ aggregate functions and group by
>> clauses?
Yes, it is basically *all* the normal SQL
functionality but with the added option to mix in
scores from lucene queries to the criteria.
>From the example code:
select top 10 count(*) as numAds,pricePounds from ads
where pricePounds
I must admit that I have not downloaded the source yet. But a quick
question, does it deal w/ aggregate functions and group by clauses?
Thanks!
Ray,
On 9/17/05, markharw00d <[EMAIL PROTECTED]> wrote:
> >>Basically your lucene_query function will return a true/false in one
> of the query predica
>>Basically your lucene_query function will return a true/false in one
of the query predicates for each record.
Almost, it returns a score - much more useful than just a boolean and
the key difference between a search engine and a database (partial
matching with relevance ranked scores). Thes
Mark:
VERY VERY good post! Please publish this doc and example.
On 9/17/05, Chris Lu <[EMAIL PROTECTED]> wrote:
>
> On 9/17/05, markharw00d <[EMAIL PROTECTED]> wrote:
> > Mag Gam wrote:
> >
> > >Does your example store the index in the derby db or somewhere else? I
> was
> > >thinking of index
On 9/17/05, markharw00d <[EMAIL PROTECTED]> wrote:
> Mag Gam wrote:
>
> >Does your example store the index in the derby db or somewhere else? I was
> >thinking of indexing a table in a seperate column.
> >
> >
> The software is not an org.apache.lucene.store.Directory implementation
> ie an FSDire
Mag Gam wrote:
Does your example store the index in the derby db or somewhere else? I was
thinking of indexing a table in a seperate column.
The software is not an org.apache.lucene.store.Directory implementation
ie an FSDirectory alternative for persisting Lucene data in a relational
table
Does your example store the index in the derby db or somewhere else? I was
thinking of indexing a table in a seperate column.
On 9/16/05, markharw00d <[EMAIL PROTECTED]> wrote:
>
> I know there have been some posts discussing how to integrate Lucene
> with Derby recently.
>
> I've added an ex
Mark:
Thanks for looking at this.I will try it out!
On 9/16/05, markharw00d <[EMAIL PROTECTED]> wrote:
>
> I know there have been some posts discussing how to integrate Lucene
> with Derby recently.
>
> I've added an example project that works with both HSQLDB and Derby
> here: http://issues.a
I know there have been some posts discussing how to integrate Lucene
with Derby recently.
I've added an example project that works with both HSQLDB and Derby
here: http://issues.apache.org/jira/browse/LUCENE-434
The bindings allow you to use SQL that mixes database and Lucene
functionality i