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