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

Timothy Potter commented on SOLR-10016:
---------------------------------------

Thanks [~risdenk] ... I'll see about just working with those RAND functions.

> SQL should support sorting by random_<SEED>
> -------------------------------------------
>
>                 Key: SOLR-10016
>                 URL: https://issues.apache.org/jira/browse/SOLR-10016
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: Parallel SQL
>            Reporter: Timothy Potter
>            Assignee: Timothy Potter
>         Attachments: SOLR-10016.patch
>
>
> I tried using the handy sort=random_<SEED> feature in normal queries with SQL 
> and it failed:
> {code} 
> curl --data-urlencode "stmt=select rating, movie_id, user_id from ratings 
> order by random_5150 asc" \
> >  "http://localhost:8983/solr/ratings/sql";
> {"result-set":{"docs":[
> {"EXCEPTION":"Fields in the sort spec must be included in the field 
> list:random_5150","EOF":true}]}}
> {code}
> I'd like to take a stab at fixing this if there are no objections to me doing 
> so?



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to