You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Joel Bernstein (JIRA)" <ji...@apache.org> on 2015/08/28 03:55:46 UTC
[jira] [Commented] (SOLR-7986) JDBC Driver for SQL Interface
[ https://issues.apache.org/jira/browse/SOLR-7986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14717899#comment-14717899 ]
Joel Bernstein commented on SOLR-7986:
--------------------------------------
Some thoughts on the design:
1) The *Connection* class should be SolrCloud aware. This means that the *Database* it connects to is a SolrCloud Collection with each node running a /sql handler. This Collection will be a facade for the distributed database. SQL queries can refer to *Tables* (Collections) that reside in the same ZooKeeper or a remote Zookeeper.
2) The *Statement* and *ResultSet* can be a wrapper around a SolrStream class. The SolrStream class can be used to send SQL request of HTTP to the /sql handler.
3) The Statement will open and close the SolrStream.
4) The ResultSet can be used to iterate the Tuples from the SolrStream.
> JDBC Driver for SQL Interface
> -----------------------------
>
> Key: SOLR-7986
> URL: https://issues.apache.org/jira/browse/SOLR-7986
> Project: Solr
> Issue Type: Bug
> Components: clients - java
> Affects Versions: Trunk
> Reporter: Joel Bernstein
> Priority: Minor
>
> This ticket is to create a JDBC Driver (thin client) for the new SQL interface. As part of this ticket a driver will be added to the Solrj libary under the package: *org.apache.solr.client.solrj.io.jdbc*
> Initial implementation will include basic *Connection*, *Statement* and *ResultSet* implementations.
> Future releases can build on this implementation to support a wide range of JDBC clients and user interfaces.
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org