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
