IS NULL and IS NOT NULL predicate are not currently supported. Joel Bernstein http://joelsolr.blogspot.com/
On Thu, Jan 5, 2017 at 2:05 PM, radha krishnan <dradhakrishna...@gmail.com> wrote: > Hi, > > solr version : 6.3 > > will WHERE <<field_name>> IS NULL / IS NOT NULL work with the /sql handler > ? > > " select name from gettingstarted where name is not null " > > the above query is not returning any documents in the response even if > there are documents with "name"defined > > > Thanks, > Radhakrishnan D >