Yes, currently only Solr range syntax is supported. The SQL greater, less than syntax isn't yet supported.
This isn't explicitly stated in the docs, which would be a good first step. Supporting SQL greater and less then predicates should not be too difficult. Feel free to create a jira ticket for this. Joel Bernstein http://joelsolr.blogspot.com/ On Sat, May 21, 2016 at 10:55 AM, Timothy Potter <thelabd...@gmail.com> wrote: > this gives expected result: > > SELECT title_s, COUNT(*) as cnt > FROM movielens > WHERE genre_ss='action' AND rating_i='[4 TO 5]' > GROUP BY title_s > ORDER BY cnt desc > LIMIT 5 > > but using >= 4 doesn't give same results (my ratings are 1-5): > > SELECT title_s, COUNT(*) as cnt > FROM movielens > WHERE genre_ss='action' AND rating_i >= 4 > GROUP BY title_s > ORDER BY cnt desc > LIMIT 5 > > on the Solr side, I see queries forumlated as: > > 2016-05-21 14:53:43.096 INFO (qtp1435804085-1419) [c:movielens > s:shard1 r:core_node1 x:movielens_shard1_replica1] o.a.s.c.S.Request > [movielens_shard1_replica1] webapp=/solr path=/export > > params={q=((genre_ss:"action")+AND+(rating_i:"4"))&distrib=false&fl=title_s&sort=title_s+desc&wt=json&version=2.2} > hits=2044 status=0 QTime=0 > > which is obviously wrong ... known issue or should I open a JIRA? > > In general, rather than crafting an incorrect query that gives the > wrong results, we should throw an exception stating that the syntax is > not supported. >
