40

I have a Solr index with a set of coordinates stored as a Location type; I would like to query for documents where this field has a non-null value.

What is the query syntax to perform the NOT NULL check on a Location field?

Improve this question

4 Answers 4

Reset to default
71

The canonical way is this:

fieldName:[* TO *]

Using a '' on the left side as Paige Cook suggested will probably work too but I don't trust it as much as I do the above. And since this is to a Location field, you will probably have to do this against one of the two underlying actual fields versus this logical composite field. They start with fieldName and end with some sort of numeric suffix; look in the Schema Browser to see what the actual name is.

An important thing to be aware of here is that a query like this is expensive for Solr to do as it much do a full index scan on this field. If you have many distinct location field values (thousands on up?), then this is a big deal. If you do this in a filter query, then it will be cached and it's perhaps moot. If you want this query to run fast, then at index time you should index a boolean field to indicate if there is a value in this field or not.

Improve this answer
Sign up to request clarification or add additional context in comments.

5 Comments

Thanks David, the [* TO *] syntax, combined with checking both backing fields, appears to work correctly (e.g. field_0_coord:[* TO *] AND field_1_coord:[* TO *]). Thanks for the performance tip as well!
You don't have to do this against both coord fields, which is twice as slow, just one. If one has a value, the other does, and vice versa.
Because I just came across this "solution" in our project: Don't use this for a String field.
@DavidSmiley I can also use fieldName:() to achieve NOT NULL values for field. Can you please say if is there any performance impact difference between these 2 queries [ TO ] and ()
@ChiragShah your syntax confused the StackOverflow formatting but I assume you are asking if field:[* TO *] is equivalent to field:*. I think these are the same as of Jan 2020.
14

You can add this to your query fieldname:['' TO *]. This will be the equivalent of a NOT NULL check.

I got this from the post - Solr - Field Not Null Searches

Improve this answer

3 Comments

Thanks Paige, but unfortunately that doesn't appear to work for the Location
to expand a bit more, the field as well as the backing fields are numeric; evaluating them against '' results in a NumberFormatException
Sorry that I missed that this was numeric. David Smiley has the correct answer.
7

For a location field (solr.LatLonType), use the following filter query: -fieldName:[-90,-180 TO 90,180] (the coordinates outside this range are still invalid)

Improve this answer

Comments

-7

Try this q= !fieldname:NULL this will be equivalent to Fieldvalue is NOT NULL.

Asked by STW I have a Solr index with a set of coordinates stored as a Location type; I would like to query for documents where this field has a non-null value.

What is the query syntax to perform the NOT NULL check on a Location field?

Improve this answer

1 Comment

The query !fieldname:NULL isn't working, shows the error 400: java.text.ParseException: missing parens: NULL

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.