q=-id:xxxx in export handler does not work but works ok in select.

[radha krishnan <dr...@gmail.com>]

q=-id:xxxx in export handler does not work but works ok in select.

Works:
http://localhost:8983/solr/bucket4/select?q=id:8733*&rows=1&sort=_version_%20desc&fl=id
Does not work:
http://localhost:8983/solr/bucket4/export?q=id:8733*&rows=1&sort=_version_%20desc&fl=id

looks a bug with solr or am i making a mistake here


Thanks,
Radhakrishnan

Re: q=-id:xxxx in export handler does not work but works ok in select.

[Sundeep T <su...@gmail.com>]

Hi Erick,

It looks like solr by default takes care of adding the *:*  for /select API
for NOT queries like this. In the newer /export API, it is not doing that
by default. So, it is kind of inconsistent, and a lot of users will run
into this if they try to use the /export api for streaming results.

I think the ExportQParserPlugin which /export API calls is missing to
automatically add this. Is it possible to fix this in solr, so that /export
and /select APIs work similarly?

Thanks
Sundeep

On Sun, Mar 12, 2017 at 9:13 AM, Erick Erickson <er...@gmail.com>
wrote:

> Oh, you're running into a "quirk" of Solr. Pure negative queries in
> main clauses require a *:* in front unless there's some special
> handling. So try:
> q=*:* -id:8733
> instead in both cases.
>
> Best,
> Erick
>
> On Sun, Mar 12, 2017 at 7:57 AM, radha krishnan
> <dr...@gmail.com> wrote:
> > q=-id:xxxx in export handler does not work but works ok in select.
> >
> > Works:
> > http://localhost:8983/solr/bucket4/select?q=id:8733*&
> rows=1&sort=_version_%20desc&fl=id
> > Does not work:
> > http://localhost:8983/solr/bucket4/export?q=id:8733*&
> rows=1&sort=_version_%20desc&fl=id
> >
> > looks a bug with solr or am i making a mistake here
> >
> >
> > Thanks,
> > Radhakrishnan
>

Re: q=-id:xxxx in export handler does not work but works ok in select.

[Erick Erickson <er...@gmail.com>]

Oh, you're running into a "quirk" of Solr. Pure negative queries in
main clauses require a *:* in front unless there's some special
handling. So try:
q=*:* -id:8733
instead in both cases.

Best,
Erick

On Sun, Mar 12, 2017 at 7:57 AM, radha krishnan
<dr...@gmail.com> wrote:
> q=-id:xxxx in export handler does not work but works ok in select.
>
> Works:
> http://localhost:8983/solr/bucket4/select?q=id:8733*&rows=1&sort=_version_%20desc&fl=id
> Does not work:
> http://localhost:8983/solr/bucket4/export?q=id:8733*&rows=1&sort=_version_%20desc&fl=id
>
> looks a bug with solr or am i making a mistake here
>
>
> Thanks,
> Radhakrishnan