[SOLR-9146] Parallel SQL engine should support >, >=, <, <=, <>, != syntax

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 6.3
• Component/s: Parallel SQL
• Assignee: Kevin Risden
• Reporter: Timothy Potter
• Created: 22/May/16 19:14
• Updated: 08/Oct/19 14:50
• Resolved: 06/Oct/16 18:17

Description

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 ...

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.

Also, the ref guide should be updated to contain a known limitations section so users don't have to guess at what SQL features are supported by Solr.

Issue Links

• is related to: SOLR-8125 Umbrella ticket for Streaming and SQL issues