For NOT NULL, I had some success using:
WHERE field_name <> '' (greater or less than empty quotes)
Best regards,
Gethin.
From: Joel Bernstein <joels...@gmail.com>
Sent: 05 January 2017 20:12:19
To: solr-user@lucene.apache.org
Subject: Re: Re
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
wrote:
> Hi,
>
> solr version : 6.3
>
> will WHERE <> IS NULL / IS NOT NULL work with the /sql handler
> ?
>
>
Hi,
solr version : 6.3
will WHERE <> 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