lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joel Bernstein <joels...@gmail.com>
Subject Re: Parallel SQL doesn't support >, >=, <, <= syntax?
Date Sat, 21 May 2016 21:39:16 GMT
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 <joelsolr@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 <thelabdude@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.
>>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message