Re: Which method is more performant? SubQueries or Collapsing the results?

2022-09-24 Thread Vincenzo D'Amore
Hi, could you please post an example of the two queries? On Wed, 21 Sep 2022 at 06:41, Daxesh Parmar wrote: > Hii, > > Can anyone pls provide documentation for internal working of solr > Subqueries. and also if we compare the same with collapse and expand > queries, which one is efficient in te

Re: Which method is more performant? SubQueries or Collapsing the results?

2022-09-24 Thread Mikhail Khludnev
Hi, Daxesh. Absolutely 20, since it's a result transformer https://solr.apache.org/guide/solr/latest/query-guide/document-transformers.html . On Thu, Sep 22, 2022 at 12:25 PM Daxesh Parmar wrote: > Hii Mikhail. > Had one doubt regarding the internal workings of Sub-queries. > Suppose we have tot

Re: SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Farrukh Zamir
On Sat, 24 Sep 2022, 20:17 Farrukh Zamir, wrote: > Following are the links to images of my error mentioned in previous mail. > Sequence wise. > > > https://drive.google.com/file/d/16Z-nQHhvzXVQ2oSyfqsdCSZTofLDcuZ9/view?usp=drivesdk > > > https://drive.google.com/file/d/1oIMKI_3cdUwCiZ-86XLH8VfQXB

Re: SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Farrukh Zamir
Following are the links to images of my error mentioned in previous mail. Sequence wise. https://drive.google.com/file/d/16Z-nQHhvzXVQ2oSyfqsdCSZTofLDcuZ9/view?usp=drivesdk https://drive.google.com/file/d/1oIMKI_3cdUwCiZ-86XLH8VfQXB9URqwn/view?usp=drivesdk https://drive.google.com/file/d/1AL-DFI

Re: SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Mike Drob
The mailing list removes images, you may need to upload them and link from an external service. On Sat, Sep 24, 2022 at 7:22 AM Farrukh Zamir wrote: > Also i am seeing this error in log while /sql handler is initialized. > [image: Untitled23.png] > > On Sat, Sep 24, 2022 at 2:16 PM Farrukh Zamir

Re: SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Farrukh Zamir
Also i am seeing this error in log while /sql handler is initialized. [image: Untitled23.png] On Sat, Sep 24, 2022 at 2:16 PM Farrukh Zamir wrote: > Hi, > i have installed solr 9.0.0 on my server on windows. It installed > successfully. Cloud mode required for sql was also configured > successfu

SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Farrukh Zamir
Hi, i have installed solr 9.0.0 on my server on windows. It installed successfully. Cloud mode required for sql was also configured successfully./sql handle is also being shown in plugins in core. [image: image.png] But when i execute sql query. Following error shows. i have said the library path a