Currently grouping on the Date field is not supported with SQL interface. At Alfresco we've added a time series capability to Solr's SQL engine and plan on contributing it back.
Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Feb 16, 2018 at 3:10 PM, Jorge Carlos Guedert Junior < jorge.jun...@blendit.com.br> wrote: > I'm getting error > > > {"result-set":{"docs":[{"EXCEPTION":"java.util.Date cannot be cast to > java.lang.String","EOF":true,"RESPONSE_TIME":68}]}} > > > when i trying to do this query: > > SELECT `date` as Date, COUNT(deviceSerialNumber) FROM `trip-day-mobile` > GROUP BY `date`? > > > this problem occurs only when i group by date if not grouped return values > normally > > > Solr Version: 6.6 >