[
https://issues.apache.org/jira/browse/SOLR-9675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15678358#comment-15678358
]
Chakra Yeleswarapu commented on SOLR-9675:
------------------------------------------
Thank you [[email protected]]
Use case is similar to parallel sql. However, our implementation is based on
json faceting on Solr v 6.1.0
SELECT sl1, gc_2, sum(product_bkgs)
FROM collection1
WHERE sl2 : ("xyz")
GROUP BY gc_2
ORDER BY sl1 asc
LIMIT 25
Schema is single valued fields (each document just like row in database).
ORDER BY fields sl1,sl2,fieldA, fieldB are non-numeric.
gc2 field is concatenation of sl1,sl2,fieldA, fieldB values.
There may be any number of documents in each gc_2 bucket. But each gc_2 bucket
will have one unique sl1,sl2,fieldA, fieldB value.
Ability to sort (asc|desc) on sl1,sl2,fieldA, fieldB is the use case.
> Sorting on field in JSON Facet API which is not part of JSON Facet.
> -------------------------------------------------------------------
>
> Key: SOLR-9675
> URL: https://issues.apache.org/jira/browse/SOLR-9675
> Project: Solr
> Issue Type: Improvement
> Security Level: Public(Default Security Level. Issues are Public)
> Reporter: AMRIT SARKAR
> Priority: Minor
>
> Here's a sample example:
> There is a requirement to facet on a particular field but sort on another
> field which is not part of json facet.
> For example, consider schema with fields : sl1, sl2, product_bkgs, gc_2
> Solr query & facet : q=sl1 : ("abc") AND sl2 : ("xyz")&sort=sl1 desc&rows=0
> & json.facet={
> "group_column_level" :
> {
> "type" : "terms",
> "field" : "gc_2",
> "offset" : 0,
> "limit" :25,
> "sort" : { "product_bkgs" : "desc"},
> "facet" :
> {
> "product_bkgs" :"sum(product_bkgs)"
> }
> }
> }
> Sort on product_bkgs is possible but not on sl1 in the facet.
> Let me know if anything can be done to achieve the same.
> Thanks in advance.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
