search for docs where location not present
I have a location-type field in my schema where I store lat / lon of a
document when this data is available. In around half of my documents this
info is not available and I just don't store anything.
I am trying to find the documents where the location is not set but nothing
is working.
I tried q=location_field:* and get back no results
I tried q=-location_field:[* TO *] but got back an error
I even tried something like:
q=*:*fq={!geofilt sfield=location_field}pt=34.02093,-118.210755d=25000
(distance set to a very large number)
but it returned fields even if they had no location_field set.
Can anyone think of a way to do this?
Thanks in advance!
--
View this message in context:
http://lucene.472066.n3.nabble.com/search-for-docs-where-location-not-present-tp4068444.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: search for docs where location not present
Thanks for the replies. I found that -location_field:* returns documents that both have and don't have the field set. I should clarify that I am using Solr 3.4 the location type is set to solr.LatLonType Although I could add a boolean field that is true if location is set I'd rather not have redundant data in the db (harkens back to my normalize sql type days) -- View this message in context: http://lucene.472066.n3.nabble.com/search-for-docs-where-location-not-present-tp4068444p4068459.html Sent from the Solr - User mailing list archive at Nabble.com.
Funny behavior in facet query on large dataset
I am doing a facet query in Solr (3.4) and getting very bad performance. This is in a solr shard with 22 million records, but I am specifically doing a small time slice. However even if I take the time slice query out it takes the same amount of time, so it seems to be searching the entire data set. I am trying to find all documents that contain the word dude or thedude or anotherdude and count how many of these were written by eldudearino (of course names are changed here to protect the innocent...). My query is like this: http://myserver:8080/solr/select/?fq=created_at:NOW-5MINUTESq=(+(text:(%22dude%22+%22thedude%22+%22%23anotherdude%22))+)facet=trueindent=onfacet.mincount=1wt=xmlversion=2.2rows=0fl=author_username,author_idfacet.field=author_usernamefq=author_username:(%22@eldudearino%22) Any ideas what I could be doing wrong? Thanks in advance! -- View this message in context: http://lucene.472066.n3.nabble.com/Funny-behavior-in-facet-query-on-large-dataset-tp4012584.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Funny behavior in facet query on large dataset
Thanks for all the replies. I oversimplified the problem for the purposes of making my post small and concise. I am really trying to find the counts of documents by a list of 10 different authors that match those keywords. Of course on looking up a single author there is no reason to do a facet query. To be clearer: Find all documents that contain the word dude or thedude or anotherdude and count how many of these were written by eldudearino and zeedudearino and adudearino and beedudearino I tried facet.query as well as facet.method=fc and neither really helped. We are constantly adding documents to the solr index and committing, every few seconds, which is probably why this is not working well. Seems we need to re-architect the way we are doing this... -- View this message in context: http://lucene.472066.n3.nabble.com/Funny-behavior-in-facet-query-on-large-dataset-tp4012584p4012610.html Sent from the Solr - User mailing list archive at Nabble.com.
