You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Aroop (JIRA)" <ji...@apache.org> on 2018/06/20 21:42:00 UTC
[jira] [Commented] (SOLR-8659) Improve Solr JDBC Driver to support
more SQL Clients
[ https://issues.apache.org/jira/browse/SOLR-8659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16518628#comment-16518628 ]
Aroop commented on SOLR-8659:
-----------------------------
Tableau Desktop 2018 has ODBC support and I was able to use OpenLink to connect Solr to it.
The collections even show up on the schema dictionary, However, queries on collections fail due to Tableau's fixation with modeling everything as inner-queries and the integration does not work at this point. Tableau builds Queries like this " select a as T.A, T.b as B from (select * from collectionA) as T" and there does not seem to be any way to go around this, and these kind of queries fail on Solr obviously.
> Improve Solr JDBC Driver to support more SQL Clients
> ----------------------------------------------------
>
> Key: SOLR-8659
> URL: https://issues.apache.org/jira/browse/SOLR-8659
> Project: Solr
> Issue Type: Improvement
> Components: SolrJ
> Affects Versions: 6.0
> Reporter: Kevin Risden
> Priority: Major
> Attachments: iODBC_Demo__Unicode__-_Connected_to__remotesolr__and_Attach_screenshot_-_ASF_JIRA.png
>
>
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org