Hello Solr Forum,
I believe I have found a solution (workaround?) for performing an explicit (non-wildcarded) field query with values that contain special (escaped) characters. Instead of: field:"value-with-escape-chars" change this to: field:["value-with-escape-chars" TO "value-with-escape-chars"] (Note that for SolrJ, use QueryParser.escape(), to ultimately turn this into: field:[\"value\-with\-escape\-chars\" TO \"value\-with\-escape\-chars\"]) If the value being queried has no special characters (e.g. host:localhost), the above is not necessary, which leads me to believe this more of a workaround than the 'supported way'. Please do correct me/clarify if you know differently, or know of a better/more efficient method. In early tests with 200,000+ hits, there appears no performance hit for using the range form. Not sure if this affects performance for millions+ hits. Thanks, Peter > From: pete...@hotmail.com > To: solr-user@lucene.apache.org > Subject: Facet query with special characters > Date: Thu, 3 Dec 2009 13:29:45 +0000 > > > Hello, > > I've encountered some strange behaviour in Solr facet querying, and I've not > been able to find anything on this on the web. > Perhaps someone can shed some light on this? > > The problem: > When performing a facet query where part of the value portion has a special > character (a minus sign in this case), the query returns zero results unless > I put a wildcard (*) at the end. > > > > Here is my query: > > This produces zero 'numFound': > http://localhost:8983/solr/select/?wt=xml&indent=on&rows=20&q=((signature:3083 > AND host:pds-comp.domain)) AND _time:[091119124039 TO > 091203124039]&facet=true&facet.field=host&facet.field=sourcetype&facet.field=user&facet.field=signature > > This produces 28 'numFound': > http://localhost:8983/solr/select/?wt=xml&indent=on&rows=20&q=((signature:3083 > AND host:pds-comp.domain*)) AND _time:[091119124039 TO > 091203124039]&facet=true&facet.field=host&facet.field=sourcetype&facet.field=user&facet.field=signature > > > (Note: all hit results are for <host>pds-comp.domain</host> - there are no > other characters in the resulting field values) > > > I've tried escaping the minus sign in various ways, encoding etc., but > nothing seems to work. > Can anyone help? > > Many thanks, > Peter > > > _________________________________________________________________ > Add your Gmail and Yahoo! Mail email accounts into Hotmail - it's easy > http://clk.atdmt.com/UKM/go/186394592/direct/01/ _________________________________________________________________ Add your Gmail and Yahoo! Mail email accounts into Hotmail - it's easy http://clk.atdmt.com/UKM/go/186394592/direct/01/
