Hello, I'm doing some tests against the SQL handler on a single node SolrCloud 7.1.0 installation.
When running this query: SELECT Org_Type, COUNT(*) FROM obesity GROUP BY Org_Type ORDER BY Org_Type DESC, COUNT(*) ASC I get the following error: Failed to execute sqlQuery <query>: java.io.IOException: If multiple sorts are specified there must be a sort for each bucket. Is this a bug or the handler cannot support this kind of mixed sorting? For reference, the following queries work as expected: SELECT Org_Type, COUNT(*) FROM obesity GROUP BY Org_Type ORDER BY COUNT(*) ASC SELECT Org_Type, COUNT(*) FROM obesity GROUP BY Org_Type ORDER BY Org_Type DESC SELECT Org_Type, Org_Name, COUNT(*) FROM obesity GROUP BY Org_Type, Org_Name ORDER BY Org_Type DESC, Org_Name DESC Thanks, Fabio