[SOLR-8659] Improve Solr JDBC Driver to support more SQL Clients

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 6.0
• Component/s: SolrJ
• Assignee: Unassigned
• Reporter: Kevin Risden
• Created: 08/Feb/16 21:32
• Updated: 08/Oct/19 14:50

Description

SOLR-8502 was a great start to getting JDBC support to be more complete. This ticket is to track items that could further improve the JDBC support for more SQL clients and their features. A few SQL clients are:

• DbVisualizer
• SQuirrel SQL
• Apache Zeppelin (incubating)
• Spark
• Python & Jython
• IntelliJ IDEA Database Tool
• ODBC clients like Excel/Tableau

Issue Links

• is related to: SOLR-8680 Distribute JDBC driver as a separate jar
• is related to: SOLR-8786 Ensure Solr's JDBC Driver works with Apache Zeppelin
• relates to: SOLR-8125 Umbrella ticket for Streaming and SQL issues
• relates to: SOLR-7986 JDBC Driver for SQL Interface
• relates to: SOLR-8502 Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
• relates to: SOLR-8593 Integrate Apache Calcite into the SQLHandler

Sub-Tasks

• Implement DatabaseMetaDataImpl.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern): Open
• Implement PreparedStatementImpl parameterization: Reopened
• SolrJ JDBC - Ensure that Spark works with SolrJ JDBC: Open
• SolrJ JDBC - Spark documentation: Open