Timothy Potter created SOLR-9146:
------------------------------------
Summary: Parallel SQL engine should support >, >=, <, <= syntax
Key: SOLR-9146
URL: https://issues.apache.org/jira/browse/SOLR-9146
Project: Solr
Issue Type: New Feature
Components: Parallell SQL
Reporter: Timothy Potter
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
