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
