Re: Invalid Date String:'1992-07-10T17'
On 3/10/2015 1:39 PM, Ryan, Michael F. (LNG-DAY) wrote: You'll need to wrap the date in quotes, since it contains a colon: String a = speechDate:\1992-07-10T17:33:18Z\; You could also escape the colons with a backslash. Here's another way to do it that doesn't require quotes or manual escaping: String d = 1992-07-10T17:33:18Z; String a = speechDate: + ClientUtils.escapeQueryChars(d); If you wanted to go to the trouble of using StringBuilder instead of string concatenation for performance reasons, you could certainly do that. This is the class you need to import in order to use escapeQueryChars: http://lucene.apache.org/solr/4_10_2/solr-solrj/org/apache/solr/client/solrj/util/ClientUtils.html Thanks, Shawn
Re: Invalid Date String:'1992-07-10T17'
Thanks very much for each of your replies. These resolved my problem and teach me something important. I have just discovered that I have another problem but I guess that I have to open another discussion. Cheers, Mirko On 10/03/15 20:30, Chris Hostetter wrote: : is a syntactically significant character to the query parser, so it's getting confused by it in the text of your query. you're seeing the same problem as if you tried to search for foo:bar in the yak field using q=yak:foo:bar you either need to backslash escape the : characters, or wrap the date in quotes, or use a diff parser that doesn't treat colons as special characters (but remember that since you are building this up as a java string, you have to deal with *java* string escaping as well... String a = speechDate:1992-07-10T17\\:33\\:18Z; String a = speechDate:\1992-07-10T17:33:18Z\; String a = speechDate: + ClientUtils.escapeQueryChars(1992-07-10T17:33:18Z); String a = {!field f=speechDate}1992-07-10T17:33:18Z; : My goal is to group these speeches (hopefully using date math syntax). I would Unless you are truely seraching for only documents that have an *exact* date value matching your input (down to the millisecond) then seraching or a single date value is almost certainly not what you want -- you most likely want to do a range search... String a = speechDate:[1992-07-10T00:00:00Z TO 1992-07-11T00:00:00Z]; (which doesn't require special escaping, because the query parser is smart enough to know that : aren't special inside of the [..]) : like to know if you suggest me to use date or tdate or other because I have : not understood the difference. the difference between date and tdate has to do with how you wnat to trade index size (on disk in ram) with search speed for range queries like these -- tdate takes up a little more room in the index, but came make range queries faster. -Hoss http://www.lucidworks.com/
Re: Invalid Date String:'1992-07-10T17'
: is a syntactically significant character to the query parser, so it's getting confused by it in the text of your query. you're seeing the same problem as if you tried to search for foo:bar in the yak field using q=yak:foo:bar you either need to backslash escape the : characters, or wrap the date in quotes, or use a diff parser that doesn't treat colons as special characters (but remember that since you are building this up as a java string, you have to deal with *java* string escaping as well... String a = speechDate:1992-07-10T17\\:33\\:18Z; String a = speechDate:\1992-07-10T17:33:18Z\; String a = speechDate: + ClientUtils.escapeQueryChars(1992-07-10T17:33:18Z); String a = {!field f=speechDate}1992-07-10T17:33:18Z; : My goal is to group these speeches (hopefully using date math syntax). I would Unless you are truely seraching for only documents that have an *exact* date value matching your input (down to the millisecond) then seraching or a single date value is almost certainly not what you want -- you most likely want to do a range search... String a = speechDate:[1992-07-10T00:00:00Z TO 1992-07-11T00:00:00Z]; (which doesn't require special escaping, because the query parser is smart enough to know that : aren't special inside of the [..]) : like to know if you suggest me to use date or tdate or other because I have : not understood the difference. the difference between date and tdate has to do with how you wnat to trade index size (on disk in ram) with search speed for range queries like these -- tdate takes up a little more room in the index, but came make range queries faster. -Hoss http://www.lucidworks.com/
RE: Invalid Date String:'1992-07-10T17'
You'll need to wrap the date in quotes, since it contains a colon: String a = speechDate:\1992-07-10T17:33:18Z\; -Michael -Original Message- From: Mirko Torrisi [mailto:mirko.torr...@ucdconnect.ie] Sent: Tuesday, March 10, 2015 3:34 PM To: solr-user@lucene.apache.org Subject: Invalid Date String:'1992-07-10T17' Hi all, I am very new with Solr (and Lucene) and I use the last version of it. I do not understand why I obtain this: Exception in thread main org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException: Error from server at http://localhost:8983/solr/Collection1: Invalid Date String:'1992-07-10T17' at org.apache.solr.client.solrj.impl.HttpSolrClient.executeMethod(HttpSolrClient.java:558) at org.apache.solr.client.solrj.impl.HttpSolrClient.request(HttpSolrClient.java:214) at org.apache.solr.client.solrj.impl.HttpSolrClient.request(HttpSolrClient.java:210) at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:91) at org.apache.solr.client.solrj.SolrClient.query(SolrClient.java:302) at Update.main(Update.java:18) Here the code that creates this error: SolrQuery query = new SolrQuery(); String a = speechDate:1992-07-10T17:33:18Z; query.set(fq, a); //query.setQuery( a ); -- I also tried using this one. According to https://cwiki.apache.org/confluence/display/solr/Working+with+Dates, it should be right. I tried with others date, or just |-MM-DD, with no success. My goal is to group these speeches (hopefully using date math syntax). I would like to know if you suggest me to use date or tdate or other because I have not understood the difference. Thanks in advance,| Mirko||