[
https://issues.apache.org/jira/browse/SOLR-10016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15937559#comment-15937559
]
Kevin Risden commented on SOLR-10016:
-------------------------------------
Just going to share my two cents on this (not fully fleshed out):
I don't know if adding a field to the schema for each custom field is the right
approach. This would get very unwieldy. Instead, is it possible to do this by
implemented a custom function that isn't in the schema? Something like random()
or random(SEED). I don't know the right place to hook this into Calcite right
now but it seems like this would be possible? It may also be the case that
Calcite has some functions built in already?
> 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]
