Getting Error when try to use sql query

[Jorge Carlos Guedert Junior <jo...@blendit.com.br>]

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

Re: Getting Error when try to use sql query

[Joel Bernstein <jo...@gmail.com>]

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.junior@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
>