[
https://issues.apache.org/jira/browse/SOLR-7986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joel Bernstein updated SOLR-7986:
---------------------------------
Description:
This ticket is to create a JDBC Driver (thin client) for the new SQL interface
(SOLR-7560). As part of this ticket a driver will be added to the Solrj libary
under the package: *org.apache.solr.client.solrj.io.sql*
Initial implementation will include basic *Driver*, *Connection*, *Statement*
and *ResultSet* implementations.
Future releases can build on this implementation to support a wide range of
JDBC clients and tools.
*Syntax using parallel Map/Reduce for aggregations*:
{code}
Properties props = new Properties();
props.put("aggregatioMode", "map_reduce");
props.put("numWorkers", "10");
Class.forName("org.apache.solr.client.solrj.io.sql.DriverImpl").newInstance();
Connection con =
DriverManager.getConnection("jdbc:solr:<zkhost:port>?collection=<collection>",
props);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select ....");
while(rs.next()) {
}
{code}
*Syntax using JSON facet API for aggregations*:
{code}
Properties props = new Properties();
props.put("aggregationMode", "facet");
Class.forName("org.apache.solr.client.solrj.io.sql.DriverImpl").newInstance();
Connection con =
DriverManager.getConnection("jdbc:solr:<zkhost:port>?collection=<collection>",
props);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select ....");
while(rs.next()) {
}
{code}
was:
This ticket is to create a JDBC Driver (thin client) for the new SQL interface
(SOLR-7560). As part of this ticket a driver will be added to the Solrj libary
under the package: *org.apache.solr.client.solrj.io.sql*
Initial implementation will include basic *Driver*, *Connection*, *Statement*
and *ResultSet* implementations.
Future releases can build on this implementation to support a wide range of
JDBC clients and tools.
*Syntax using parallel Map/Reduce for aggregations*:
{code}
Properties props = new Properties();
props.put("aggregatioMode", "map_reduce");
props.put("numWorkers", "10");
Class.forName("org.apache.solr.client.solrj.io.sql.DriverImpl").newInstance();
Connection con =
DriverManager.getConnection("jdbc:solr:<zkhost:port>?collection=<collection>",
props);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select ....");
while(rs.next()) {
}
{code}
*Syntax using JSON facet APU for aggregations*:
{code}
Properties props = new Properties();
props.put("aggregationMode", "facet");
Class.forName("org.apache.solr.client.solrj.io.sql.DriverImpl").newInstance();
Connection con =
DriverManager.getConnection("jdbc:solr:<zkhost:port>?collection=<collection>",
props);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select ....");
while(rs.next()) {
}
{code}
> JDBC Driver for SQL Interface
> -----------------------------
>
> Key: SOLR-7986
> URL: https://issues.apache.org/jira/browse/SOLR-7986
> Project: Solr
> Issue Type: New Feature
> Components: clients - java
> Affects Versions: Trunk
> Reporter: Joel Bernstein
> Attachments: SOLR-7986.patch, SOLR-7986.patch, SOLR-7986.patch,
> SOLR-7986.patch
>
>
> This ticket is to create a JDBC Driver (thin client) for the new SQL
> interface (SOLR-7560). As part of this ticket a driver will be added to the
> Solrj libary under the package: *org.apache.solr.client.solrj.io.sql*
> Initial implementation will include basic *Driver*, *Connection*, *Statement*
> and *ResultSet* implementations.
> Future releases can build on this implementation to support a wide range of
> JDBC clients and tools.
> *Syntax using parallel Map/Reduce for aggregations*:
> {code}
> Properties props = new Properties();
> props.put("aggregatioMode", "map_reduce");
> props.put("numWorkers", "10");
> Class.forName("org.apache.solr.client.solrj.io.sql.DriverImpl").newInstance();
> Connection con =
> DriverManager.getConnection("jdbc:solr:<zkhost:port>?collection=<collection>",
> props);
> Statement stmt = con.createStatement();
> ResultSet rs = stmt.executeQuery("select ....");
> while(rs.next()) {
> }
> {code}
> *Syntax using JSON facet API for aggregations*:
> {code}
> Properties props = new Properties();
> props.put("aggregationMode", "facet");
> Class.forName("org.apache.solr.client.solrj.io.sql.DriverImpl").newInstance();
> Connection con =
> DriverManager.getConnection("jdbc:solr:<zkhost:port>?collection=<collection>",
> props);
> Statement stmt = con.createStatement();
> ResultSet rs = stmt.executeQuery("select ....");
> while(rs.next()) {
> }
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
