Hi Yaswanth,
I tried your query in a quick unit test and there's a problem here
even on main. I'll get this fixed for 8.10.
That timestamp string looks like a valid ISO-8601 timestamp to me.
Which version of Solr are you using? As a work-around, you could try:
WHERE addedon >= CAST('2021-07-13 15:12:10.037' as TIMESTAMP)
But I only tried that work-around ^^ on main, which has recent
improvements in the SQL code, including a Calcite upgrade. Let me know
if that work-around works for you.
Cheers,
Tim
On Mon, Aug 2, 2021 at 3:44 AM Vincenzo D'Amore <v.dam...@gmail.com> wrote:
>
> Hi, have you tried to investigate the error: Invalid Date in Date Math
> String:''2021-07-13T15:12:10.037Z ?
>
> This error is thrown when a datetime string has an invalid format.
> https://solr.apache.org/guide/8_2/working-with-dates.html#date-formatting
>
> On Mon, Aug 2, 2021 at 7:12 AM yaswanth kumar <yaswanth...@gmail.com> wrote:
>
> > Hi Team,
> >
> > Can someone help me on how can I use date filtering on parallel sql
> > interface by writing queries?
> >
> > I got a addedon which is of date type on schema but when trying to write a
> > query like the below its throwing invalid date error like this
> > "EXCEPTION":"Failed to execute sqlQuery 'SELECT addedon FROM msglogin
> > WHERE addedon>= '2021-07-13T15:12:10.037Z' limit 10' against JDBC
> > connection 'jdbc:calcitesolr:'.\nError while executing SQL \"SELECT addedon
> > FROM msglogin WHERE addedon>= '2021-07-13T15:12:10.037Z' limit 10\":
> > java.io.IOException: java.util.concurrent.ExecutionException:
> > java.io.IOException: -->
> > https://172.16.233.63:8080/solr/msglogin_v2_shard1_replica_n2/:Invalid
> > Date
> > in Date Math String:''2021-07-13T15:12:10.037Z''",
> >
> > SELECT addedon FROM msglogin where addedon >'2021-07-13T15:12:10.037Z'
> > limit 10
> >
> > Am I missing something here? Please do correct me if there any usage issues
> > I cross checked the stored value and that is matching with the format that
> > I am passing above into the query.
> >
> > --
> > Thanks & Regards,
> > Yaswanth Kumar Konathala.
> > yaswanth...@gmail.com
> >
>
>
> --
> Vincenzo D'Amore
