Package org.apache.solr.client.solrj.io.sql
JDBC Driver Package
Sample usage
Connection con = null; Statement stmt = null; ResultSet rs = null; try { con = DriverManager.getConnection("jdbc:solr://zkHost:port?collection=collection&aggregationMode=map_reduce"); stmt = con.createStatement(); rs = stmt.executeQuery("select a, sum(b) from tablex group by a"); while(rs.next()) { String a = rs.getString("a"); double sumB = rs.getString("sum(b)"); } } finally { rs.close(); stmt.close(); con.close(); }Connection properties can also be passed in using a Properties object.
The collection parameter is mandatory and should point to a SolrCloud collection that is configured with the /sql request handler.
The aggregationMode parameter is optional. It can be used to switch between Map/Reduce (map_reduce) or the JSON Facet API (facet) for group by aggregations. The default is "facet".
-
Class Summary Class Description DriverImpl Get a Connection with with a url and properties.