Also agreed we should throw an exception in this scenario until it's implemented.
Joel Bernstein http://joelsolr.blogspot.com/ On Sat, May 21, 2016 at 5:34 PM, Joel Bernstein <joels...@gmail.com> wrote: > 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. >> > >
