lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Li <fancye...@gmail.com>
Subject Re: more sql-like commands for solr
Date Tue, 07 Feb 2012 10:13:34 GMT
is the jsr implemented yet?
I think I could first define this language by bnf and then use javacc or
antlr to implement.
I have recently written a query rewriter component for our products which
defines regular expression like language that can rewrite querys.
. and also we can learn something from http://jsqlparser.sourceforge.net/
I have experimented it to check sql injections.

On Tue, Feb 7, 2012 at 5:54 PM, Michael Wechner
<michael.wechner@wyona.com>wrote:

>  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
>
> http://www.day.com/specs/jcr/2.0/6_Query.html
>
> HTH
>
> Michael
>
>
> On Tue, Feb 7, 2012 at 5:31 PM, Michael Wechner <michael.wechner@wyona.com
> > 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: dev-unsubscribe@lucene.apache.org
>> For additional commands, e-mail: dev-help@lucene.apache.org
>>
>>
>
>

Mime
View raw message