Re: Solr JDBC with Core (vs Collection)

2017-03-08 Thread Dennis Gove
I don't have an answer to the original question, but I would like to point out that work is being done to make streaming available outside of SolrCloud under ticket https://issues.apache.org/jira/browse/SOLR-10200. - Dennis On Wed, Mar 8, 2017 at 2:13 PM, Alexandre Rafalovitch wrote: > I believ

Re: Can we query across collections in SOLR?

2016-10-22 Thread Dennis Gove
Take a look at Streaming Expressions in Solr 6.x - https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=61330338. This supports cross-collection joining. - Denns On Fri, Oct 21, 2016 at 7:42 AM, Preeti Bhat wrote: > Hi All, > > > > I have an requirement where in SQL we have two diff

Re: Streaming Expressions (/stream) StreamHandler java.lang.NullPointerException

2016-06-28 Thread Dennis Gove
I've not been able to replicate the null pointer exception being seen. I created a new collection called EventsAndDCF with 4 shards and 3 replicas using a simple conf $> /tmp/solr-go/bin/solr/bin/solr create -p 30001 -c EventsAndDCF -d ../../../test/main/conf/sample -n EventsAndDCF -shards 4 -repl

Bootstrapping a Solr Cloud

2016-06-28 Thread Dennis Gove
end in pull requests. Starting on July 6th I'll be away-from-keyboard for a few weeks so I apologize if I don't respond to issues right away but I will as soon as I get back. - Dennis Gove

Re: Why Doesn't Solr Really Quit on Zookeeper Exceptions?

2016-05-31 Thread Dennis Gove
The retry logic for errors in construction of SolrZooKeeper was added in https://issues.apache.org/jira/browse/SOLR-8599 and is in 5.5.1 and 6.0. I wonder if either that is not working as expected during startup or if startup is following a different code path. - Dennis On Tue, May 31, 2016 at 4:

Re: How to self join a collection with SOLR and have another condition

2016-05-11 Thread Dennis Gove
If you're able to use Solr 6 then you can use Streaming Expressions to solve this. The docs for Streaming Expressions in Solr 6 can be found at https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=61330338. One option would be to use an intersect to find documents in both sets. inters

Re: Solr best practices for many to many relations...

2016-04-15 Thread Dennis Gove
ns (or the same collection with different docType field values) and then during search perform a join (inner, outer, hash) across the collections. You could, if you wanted, even join with data NOT in solr using the jdbc streaming function. - Dennis Gove On Fri, Apr 15, 2016 at 3:21 AM, Bastien Lat

Shard State vs Replica State

2016-02-26 Thread Dennis Gove
In clusterstate.json (or just state.json in new versions) I'm seeing the following "shard1":{ "range":"8000-d554", "state":"active", "replicas":{ "core_node7":{ "core":"people_shard1_replica3", "base_url":"http://192.168.2.32:8983/solr";, "node_nam

Re: Solr 6 Distributed Join

2016-01-05 Thread Dennis Gove
>>> required="false" > > > >>> > > > >>> multiValued="false" docValues="true"/> > > > >>>> > >>> required="false" > > > >>> > > > >>> multiV

Re: How to achieve join like behavior on solr-cloud

2015-12-29 Thread Dennis Gove
Alok, You can use the Streaming API to achieve this goal but joins have not been added to a 5.X release (at least I don't see it on the changelog). They do exist on trunk and will be a part of Solr 6. Documentation is still under development but if you wanted to play around with it now you could

Re: Solr 6 - Relational Index querying

2015-12-28 Thread Dennis Gove
as really designed for OLAP type > queries which typically don't involve scoring. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Mon, Dec 28, 2015 at 8:49 AM, Dennis Gove wrote: > > > There have been a lot of new features added to the Streaming API

Re: Solr 6 - Relational Index querying

2015-12-28 Thread Dennis Gove
There have been a lot of new features added to the Streaming API and the documentation hasn't kept pace, but it is something I'd like to have filled in by the release of Solr 6. With the Streaming API you can take two (or more) totally disconnected collections and get a result set with documents f

Re: Joins with SolrCloud

2015-12-11 Thread Dennis Gove
but that is not a requirement. On Fri, Dec 11, 2015 at 11:00 AM, Dennis Gove wrote: > Mugeesh, > > You can use Streaming Aggregation to provide various types of > cross-collection joins. This is currently available in trunk and will be a > part of Solr 6. > > To follow wit

Re: Joins with SolrCloud

2015-12-11 Thread Dennis Gove
Mugeesh, You can use Streaming Aggregation to provide various types of cross-collection joins. This is currently available in trunk and will be a part of Solr 6. To follow with your example, let's assume the following setup: Restaurants: avail on machine1:8983 with 3 shards, zk at zk1:2345 Users:

Re: Solr 6 Distributed Join

2015-12-11 Thread Dennis Gove
Akiel, Without seeing your full url I assume that you're missing the stream=innerJoin(.) part of it. A full sample url would look like this http://localhost:8983/solr/careers/stream?stream=innerJoin(search(careers, fl="personId,companyId,title", q=companyId:*, sort="companyId asc",zkHost="loca

Re: Solr cross core join special condition

2015-11-11 Thread Dennis Gove
I am intending to backport SOLR-7584 to 5_x. It depends on a couple of changes in a patch related to the new SQL API which is not being backported. I've got to go through and pull out the pieces needed and create a patch for 5_x. Hopefully we'll have this in 5_x soon. On Wed, Nov 11, 2015 at 2:18