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

Reply via email to