Re: solr 7.x sql query returns null

2019-04-19 Thread Joel Bernstein
Ok I updated the ticket, we can move the discussion there. Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Apr 19, 2019 at 7:44 AM David Barnett wrote: > Hi Joel > > BUG created in jira SOLR-13414 > > Please let me know if you need more info > > Thanks > > Dave > On 18 Apr 2019, 20:50 -05

Re: solr 7.x sql query returns null

2019-04-19 Thread David Barnett
Hi Joel BUG created in jira SOLR-13414 Please let me know if you need more info Thanks Dave On 18 Apr 2019, 20:50 -0500, Joel Bernstein , wrote: > That stack trace points here: > https://github.com/apache/lucene-solr/blob/releases/lucene-solr/7.3.0/solr/core/src/java/org/apache/solr/handler/sql

Re: solr 7.x sql query returns null

2019-04-19 Thread David Barnett
Hi Kevin We have the same outcome on systems with a single shard (the original host) and also a system where we have created a replica on the same host The import / export does not to my knowledge create a new shard but I can confirm On 18 Apr 2019, 20:53 -0500, Kevin Risden , wrote: > Do you h

Re: solr 7.x sql query returns null

2019-04-18 Thread Kevin Risden
Do you have multiple shards (including replicas) on the same host for the collection in question? Do the number of shards per host change on the export/index? Kevin Risden On Thu, Apr 18, 2019, 20:50 Joel Bernstein wrote: > That stack trace points here: > > https://github.com/apache/lucene-solr

Re: solr 7.x sql query returns null

2019-04-18 Thread Joel Bernstein
That stack trace points here: https://github.com/apache/lucene-solr/blob/releases/lucene-solr/7.3.0/solr/core/src/java/org/apache/solr/handler/sql/SolrSchema.java#L103 So the Sql Schema is not initializing properly for this dataset. I'd be interested in understanding why. If you want to create a

Re: solr 7.x sql query returns null

2019-04-18 Thread David Barnett
Hi Joel, besides the solr log is there anywhere else i need to go ? anything I need to set to get more detail ? On Thu, 18 Apr 2019 at 10:46, Joel Bernstein wrote: > This let's make sure the jdbc URL is correct. > > Reloading the collection shouldn't effect much unless the schema is > different.

Re: solr 7.x sql query returns null

2019-04-18 Thread David Barnett
This query is directly from a web browser to eliminate any downstream components (we use Talend ESB to read / write data into our web application) Any of these queries fail - the URL format is http://localhost:8983/solr/data/sql?stmt=select id from data limit 10 http://localhost:8983/solr/data/

Re: solr 7.x sql query returns null

2019-04-18 Thread Joel Bernstein
This let's make sure the jdbc URL is correct. Reloading the collection shouldn't effect much unless the schema is different. But as Shawn mentioned the stack trace is not coming from Solr. Is there more in the logs beyond the Calcite exception? Joel Bernstein http://joelsolr.blogspot.com/ On T

Re: solr 7.x sql query returns null

2019-04-18 Thread Shawn Heisey
On 4/18/2019 1:47 AM, David Barnett wrote: I have a large solr 7.3 collection 400m + documents. I’m trying to use the Solr JDBC driver to query the data but I get a java.io.IOException: Failed to execute sqlQuery 'select id from document limit 10' against JDBC connection 'jdbc:calcitesolr:'. E

Re: solr 7.x sql query returns null

2019-04-18 Thread David Barnett
Its odd, if I export all docs to JSON, then delete the solr docs and import from my export it works Joel Is there any way to see what it’s complaining about ? On 18 Apr 2019, 09:17 -0500, Joel Bernstein , wrote: > I ask this because SQL/JDBC may return a similar error if you try to run it > on a

Re: solr 7.x sql query returns null

2019-04-18 Thread David Barnett
Hi Joel Yes it was always setup as cloud. On Thu, 18 Apr 2019, 15:17 Joel Bernstein, wrote: > Was the original index a Solr Cloud index? > > > > Joel Bernstein > http://joelsolr.blogspot.com/ > > > On Thu, Apr 18, 2019 at 7:48 AM David Barnett > wrote: > > > I have a large solr 7.3 collection

Re: solr 7.x sql query returns null

2019-04-18 Thread Joel Bernstein
I ask this because SQL/JDBC may return a similar error if you try to run it on a non-Solr Cloud index. Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Apr 18, 2019 at 10:16 AM Joel Bernstein wrote: > Was the original index a Solr Cloud index? > > > > Joel Bernstein > http://joelsolr.blog

Re: solr 7.x sql query returns null

2019-04-18 Thread Joel Bernstein
Was the original index a Solr Cloud index? Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Apr 18, 2019 at 7:48 AM David Barnett wrote: > I have a large solr 7.3 collection 400m + documents. > > I’m trying to use the Solr JDBC driver to query the data but I get a > > > java.io.IOExcepti