lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fabio Corneti <i...@corneti.com>
Subject Error executing a SQL query sorting on both a field and an expression
Date Thu, 02 Nov 2017 00:29:31 GMT
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

Mime
View raw message