Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-9146

Parallel SQL engine should support >, >=, <, <=, <>, != syntax

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.3
    • Component/s: Parallel SQL
    • Labels:
      None

      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.

        Attachments

        1. SOLR-9146.patch
          12 kB
          Kevin Risden
        2. SOLR-9146.patch
          7 kB
          Kevin Risden

          Issue Links

            Activity

              People

              • Assignee:
                risdenk Kevin Risden
                Reporter:
                thelabdude Timothy Potter
              • Votes:
                1 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: