Hi, I'm trying to get the SQL query requestHandler up and running using this config: <requestHandler name="/sql" class="solr.SQLHandler">.
My setup involves solr-9.0.0 in cloud mode with ZooKeeper. I went through the Solr documentation, but I'm hitting a roadblock with just that. Do you know any other sources that might help? I've already checked out the official Solr documentation here: https://solr.apache.org/guide/solr/latest/query-guide/sql-query.html#configuration Here's what I've tried so far, but sadly, no luck: - Tried a query on the admin page. - Attempted to connect via sqlalchemy-solr. - Gave a shot at sending a request to the _sql/ endpoint. On the config side of things: - Initially, I thought I could get away with no extra config, as per Solr's docs. Supposedly, the /sql request handler should already be good to go in a regular Solr installation. - Then I got a bit fancy and added the request handler config directly into the solrconfig.xml file like this: <requestHandler name="/sql" class="solr.SQLHandler"> <lst name="defaults"> <str name="config">solrconfig.xml</str> </lst> </requestHandler> To solve this puzzle, I tried these moves: Grabbed the solr-core-9.0.0.jar library from /server/solr-webapp/webapp/WEB-INF/lib/ and threw it into <solr_home>/server/lib/. I doubled down and copied the solr-sql-9.0.0.jar from <solr_home>/modules/sql/lib/ to both <solr_home>/server/lib/ and <solr_home>/server/lib/ext/. Oh, and I also tweaked the solrconfig.xml file by sticking in a line to point to the outside library directory: <lib dir="${solr.install.dir:../../../..}/lib/ext/" regex=".*\.jar" /> I'm reaching out to see if I'm on the right track here. If I am, I'm planning to keep poking around and maybe get some error logs to show you later. But if I'm off the mark, your tips or suggestions for other places to look would be awesome. Thanks a bunch for your help! Cheers, Koji
