[
https://issues.apache.org/jira/browse/SOLR-10016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15836376#comment-15836376
]
Timothy Potter commented on SOLR-10016:
---------------------------------------
thanks Joel, will get started on this using the Calcite SQL implementation
also, Hossman was thinking we should try to solve this by allowing any function
/ ValueSource (not just random) for sorting SQL results, so I'm going to go
down that path first
> 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
>
> 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.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
