Re: Parallel SQL - column not found intermittent error

2017-06-14 Thread Susheel Kumar
Created JIRA https://issues.apache.org/jira/browse/SOLR-10890 Thank you. On Wed, Jun 14, 2017 at 1:59 PM, Joel Bernstein wrote: > Let's create a jira for this. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Wed, Jun 14, 2017 at 12:26 PM, Susheel Kumar > wrote: > > > Thanks, Yury.

Re: Parallel SQL - column not found intermittent error

2017-06-14 Thread Joel Bernstein
Let's create a jira for this. Joel Bernstein http://joelsolr.blogspot.com/ On Wed, Jun 14, 2017 at 12:26 PM, Susheel Kumar wrote: > Thanks, Yury. Indeed that is the issue. > > Joel, is that something expected behavior or should i create a JIRA? > > Thanks, > Susheel > > On Wed, Jun 14, 2017 a

Re: Parallel SQL - column not found intermittent error

2017-06-14 Thread Susheel Kumar
Thanks, Yury. Indeed that is the issue. Joel, is that something expected behavior or should i create a JIRA? Thanks, Susheel On Wed, Jun 14, 2017 at 12:16 PM, Yury Kats wrote: > I have seen this with very few indexed documents and multiple shards. > In such a case, some shards may not have a

Re: Parallel SQL - column not found intermittent error

2017-06-14 Thread Yury Kats
I have seen this with very few indexed documents and multiple shards. In such a case, some shards may not have any documents, and when the query happens to hit such a shard, it does not find the fields it's looking for and turns this into "column not found". If you resubmit the query and hit a diff

Re: Parallel SQL - column not found intermittent error

2017-06-14 Thread Susheel Kumar
Also i tried with both docValues and non docValue fields/column. On Wed, Jun 14, 2017 at 11:42 AM, Susheel Kumar wrote: > Yes, Joel. Kind of every other command runs into this issue. I just > executed below queries and 3 of them failed while 1 succeeded. I just > have 6 documents ingested and

Re: Parallel SQL - column not found intermittent error

2017-06-14 Thread Susheel Kumar
Yes, Joel. Kind of every other command runs into this issue. I just executed below queries and 3 of them failed while 1 succeeded. I just have 6 documents ingested and no further indexing going on. Let me know what else to look for the state of index. ➜ solr-6.6.0 curl --data-urlencode 'stmt

Re: Parallel SQL - column not found intermittent error

2017-06-14 Thread Joel Bernstein
Are you able to reproduce the error, or is it just appearing in the logs? Do you know the state of index when it's occurring? Joel Bernstein http://joelsolr.blogspot.com/ On Wed, Jun 14, 2017 at 11:09 AM, Susheel Kumar wrote: > I have setup Solr-6.6-0 on local (local ZK and Solr) and then on s

Parallel SQL - column not found intermittent error

2017-06-14 Thread Susheel Kumar
I have setup Solr-6.6-0 on local (local ZK and Solr) and then on servers (3 ZK and 2 machines, 2 shards) and on both the env, i see this intermittent error "column not found". The same query works sometime and other time fails. Is that a bug or am I missing something... Console === -> solr-6.6