Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

brent.hale_101199 avatar image
brent.hale_101199 asked ·

How to do Solr "Result Grouping" via CQL

Our customer needs the functionality of the Solr's "Result Grouping" feature that is documented here: https://lucene.apache.org/solr/guide/6_6/result-grouping.html#result-grouping.

Yes. that is for Solr 6.6, but I can find the same functionality in the pdf docs for 6.0 (which DSE Search is locked at): http://archive.apache.org/dist/lucene/solr/ref-guide/apache-solr-ref-guide-6.0.pdf

Is there a way to do "Result Grouping" via CQL?

I don't see that it is as an "Unsupported features for DSE Search" (https://docs.datastax.com/en/dse/5.1/dse-admin/datastax_enterprise/search/unsupportedSearchFeatures.html)


It may be tempting to use the "Collapse and Expand" functionality of Solr since at least the "Collapse" feature can be specified on the "fq" parameter. But that feature doesn't return the number of collapsed documents which our customer really needs. Nor does it look like DSE has a way of specifying the "expand" parameter. (https://docs.datastax.com/en/dse/5.1/dse-admin/datastax_enterprise/search/siQuerySyntax.html#siQuerySyntax)


searchcql
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

maedhroz avatar image
maedhroz answered ·

Grouping and field collapsing are supported only via the Solr HTTP interface.

2 comments Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Thanks. I'm grasping for solutions other than using the Solr HTTP interface for all the reasons mentioned in your docs. Do you think it would it be possible to use the custom payload feature mentioned in CASSANDRA-8553 to do this?

0 Likes 0 · ·

EDITED from @brent.hale_101199:

I've never written a custom query handler. Does doing so provide access to Solr directly when returning the total Result count (this and this)? Will that work?

0 Likes 0 · ·