lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Risden (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SOLR-9146) Parallel SQL engine should support >, >=, <, <= syntax
Date Thu, 26 May 2016 03:45:12 GMT

    [ https://issues.apache.org/jira/browse/SOLR-9146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15301474#comment-15301474
] 

Kevin Risden commented on SOLR-9146:
------------------------------------

{quote}
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.
{quote}

I absolutely agree with this. Currently it would be easier to start with a what is supported
section by taking the tests (TestSQLHandler and JDBCTest) as a place to start that list.

> 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message