[MDEV-5477] [PATCH] sphinxSE GROUP BY on multiple attributes Created: 2013-12-20  Updated: 2017-05-16  Resolved: 2017-05-16

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - SphinxSE
Affects Version/s: 10.0.6
Fix Version/s: 10.0.31

Type: Bug Priority: Minor
Reporter: Alex Luft Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: sphinx, upstream
Environment:

Linux, SphinxSE

Attachments: File groupby.patch    
Issue Links:
Blocks
is blocked by MDEV-5480 upgrade sphinxse Closed

 Description   

It is possible to group by on multiple attribute values with the native API and SphinxQL but not with the Storage Engine.

The patch implements a new mode ("multi:") for the groupby function SPH_GROUPBY_MULTIPLE.

After the patch it is possible to group by on multiple attribute values with this query:

SELECT _sph_count, attribute1, attribute2 FROM sphinx_index_table WHERE query = ';groupby=multi:attribute1, attribute2';

 Comments   
Comment by Alex Luft [ 2014-05-09 ]

Is anything else blocking this issue? Grouping on multiple attributes is really essential for statistical analysis... We use this patch already, works like a charm

Comment by Sergei Golubchik [ 2014-05-10 ]

Nothing is really blocking it, besides the fact that it's an upstream issue and we generally prefer upstream issues to be fixed upstream. But I see that this was not reported upstream yet.

I've now reported it on the SphinxSE bug tracker, see the link above.

Let's see how it'll go. We still might end up applying the patch only in MariaDB, although, of course, it would be better if sphinx developers would've taken it.

Comment by Elena Stepanova [ 2014-11-16 ]

The upstream issue hasn't had much activity so far, should we maybe apply the patch?

Comment by Alex Luft [ 2014-11-19 ]

I would really appreciate it... I also implemented some features from VER_COMMAND_SEARCH 0x11B (http://sphinxsearch.com/bugs/view.php?id=2007) but there is not much activity on sphinxSE.

Generated at Thu Feb 08 07:04:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.