I believe the NOT should be working. But the joins won't work correctly.
Apache Calcite, which is parsing the query, is attempting to do the joins
but there are no test cases with joins at all. The official docs should say
that joins are not supported.
Joel Bernstein
http://joelsolr.blogspot.com/
okay, found a work around for string fields for NOT queries
This query does not filters for NOT:
curl --data-urlencode "stmt=select id, name from collection where NOT (name
= 'defaultmail')" 'http://server:port/solr/collection/sql'
but after adding sth trivial i.e id > 0 o the where clause as
c
using integers in where clause with NOT is the same, though for that one
using <> as workaround does the job
-
Zeki ama calismiyor... Calissa yapar...
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
with curl the result is the same:
curl --data-urlencode "stmt=select id, name from collection where NOT (name
= 'defaultmail')" 'http://server:port/solr/collection/sql'
then the response is
.
.
.
{
"id":113,
"name":"defaultmail"}
,{
"id":109,
"name":"defau
I have been trying to get sql queries running, but having trouble while
dealing with the NOT queries.
Basically, the code looks like below
SolrQuery sqlQuery = new SolrQuery();
sqlQuery.setRequestHandler("/sql");
sqlQuery.set("stmt","select collection1.id as collection_1_id,
collection1.email as
