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.wech...@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.wech...@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-unsubscr...@lucene.apache.org >> For additional commands, e-mail: dev-h...@lucene.apache.org >> >> > >