RE: Trying to retrieve two values from two different collections by sql (V 7.2.1)

2018-10-18 Thread Vadim Ivanov
com] Sent: Thursday, October 18, 2018 1:03 AM To: solr-user@lucene.apache.org Subject: Re: Trying to retrieve two values from two different collections by sql (V 7.2.1) Joins are not currently supported with Solr SQL. We should create a ticket through a proper exception in this scenario. Joel Bern

Re: Trying to retrieve two values from two different collections by sql (V 7.2.1)

2018-10-17 Thread Joel Bernstein
Joins are not currently supported with Solr SQL. We should create a ticket through a proper exception in this scenario. Joel Bernstein http://joelsolr.blogspot.com/ On Tue, Oct 16, 2018 at 10:56 PM deniz wrote: > found out sth strange regarding this case. If i change one of the values > int

Re: Trying to retrieve two values from two different collections by sql (V 7.2.1)

2018-10-16 Thread deniz
found out sth strange regarding this case. If i change one of the values into sth else, and the field names are not the same any more, then i can get the different values so the initial query was select *collection1.id* as collection1id, collection2.id as collection2id from collection1 join colle