Solr JDBC - SQuirreL SQL
For SQuirreL SQL, you will need to create a new driver for Solr. This will add several SolrJ client .jars to the SQuirreL SQL classpath. The files required are:
- all .jars found in
$SOLR_HOME/dist/solrj-libs
- the SolrJ .jar found at
$SOLR_HOME/dist/solr-solrj-<version>.jar
Once the driver has been created, you can create a connection to Solr with the connection string format outlined in the generic section and use the editor to issue queries.
Add Solr JDBC Driver
Open Drivers
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_1.png)
Add Driver
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_2.png)
Name the Driver
Provide a name for the driver, and provide the URL format: jdbc:solr://<zk_connection_string>/?collection=<collection>
. Do not fill in values for the variables “zk_connection_string
” and “collection
”, those will be defined later when the connection to Solr is configured.
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_3.png)
Add Solr JDBC jars to Classpath
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_4.png)
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_9.png)
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_5.png)
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_7.png)
Add the Solr JDBC driver class name
After adding the .jars, you will need to additionally define the Class Name org.apache.solr.client.solrj.io.sql.DriverImpl
.
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_11.png)
Create an Alias
To define a JDBC connection, you must define an alias.
Open Aliases
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_10.png)
Add an Alias
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_12.png)
Configure the Alias
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_14.png)
Connect to the Alias
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_13.png)
Querying
Once you’ve successfully connected to Solr, you can use the SQL interface to enter queries and work with data.
![image](images/solr-jdbc-squirrel-sql/squirrelsql_solrjdbc_15.png)