Regarding /sql -- WHERE <> IS NULL and IS NOT NULL
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
Re: Regarding /sql -- WHERE <> IS NULL and IS NOT NULL
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 > ? > > " 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 >
Re: Regarding /sql -- WHERE <> IS NULL and IS NOT NULL
For NOT NULL, I had some success using: WHERE field_name <> '' (greater or less than empty quotes) Best regards, Gethin. From: Joel Bernstein Sent: 05 January 2017 20:12:19 To: solr-user@lucene.apache.org Subject: Re: Regarding /sql -- WHERE <> IS NULL and IS NOT NULL 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 > ? > > " 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 >