lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Wechner <>
Subject Re: more sql-like commands for solr
Date Tue, 07 Feb 2012 09:54:11 GMT
Am 07.02.12 10:43, schrieb Li Li:
> I just want solr providing this new feature  and also want to know 
> whether any other users need this feature. if possible, I'd like to 
> participate in it.

sounds good. I would also be interested in such a functionality. I think 
the first step would be to define a mapping between sql and lucene 
queries (without actually implementing it) and check whether and how 
this is possible.

It might be interesting to have a look at how jackrabbit is doing it with


> On Tue, Feb 7, 2012 at 5:31 PM, Michael Wechner 
> < <>> wrote:
>     Am 07.02.12 10:24, schrieb Li Li:
>         hi all,
>            we have used solr to provide searching service in many
>         products. I found for each product, we have to do some
>         configurations and query expressions.
>            our users are not used to this. they are familiar with sql
>         and they may describe like this: I want a query that can
>         search books whose title contains java, and I will group these
>         books by publishing year and order by matching score and
>         freshness, the weight of score is 2 and the weight of
>         freshness is 1.
>            maybe they will be happy if they can use sql like
>         statements to convey their needs.
>            select * from books where title contains java group by
>         pub_year order by score^2, freshness^1
>            also they may like they can insert or delete documents by
>         delete from books where title contains java and pub_year
>         between 2011 and 2012.
>            we can define some language similar to sql and translate
>         the to solr query string such as .../select/?q=+title:java^2
>         +pub_year:2011....
>            this may be equivalent to apache hive for hadoop.
>     It's not clear to me whether you are asking a question or making a
>     comment. Can you rephrase?
>     Thanks
>     Michael
>     ---------------------------------------------------------------------
>     To unsubscribe, e-mail:
>     <>
>     For additional commands, e-mail:
>     <>

View raw message