[
https://issues.apache.org/jira/browse/SOLR-10016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Timothy Potter updated SOLR-10016:
----------------------------------
Attachment: SOLR-10016.patch
Here's a patch (-p0 style) prepared against branch_6_5 that adds the ability to
sort SQL query results using Solr's random_SEED trick (via RandomStream).
To use this, your SQL would look something like:
{code}
curl --data-urlencode "stmt=select movie_id, user_id from ratings order by
_random_ asc limit 100" "http://localhost:8983/solr/ratings/sql";
{code}
Unlike with score, the _random_ sort field doesn't need to be included in the
results, which I felt was unnecessary since it's just a random number.
Still needs a test but wanted to post something up to get initial feedback.
Ideally, we'd be able to sort by any ValueSource as well as include the value
of a ValueSource in the results. However, it seems like we need to expose the
name and type of every possible ValueSource in the SolrSchema.getRelDataType
return value? [~joel.bernstein] or [~risdenk] any suggestions on the best way
to support any ValueSource in a SQL query? Seems like that would force the user
to have to use LIMIT afaik, ValueSource's aren't exportable. Also, let me know
if this approach is acceptable for random sorting.
> 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]
