[
https://issues.apache.org/jira/browse/SOLR-9611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15555819#comment-15555819
]
Marius Grama commented on SOLR-9611:
------------------------------------
[~risdenk] in my case, the default driver for jdbc was set to the local
postgres installation. For this reason I was getting a jdbc exception when
trying to execute the jdbc snippet.
Note that, in my case, initially, also the generic jdbc interpreter, as well as
the solr interpreter, had the default.xxx fields set.
In any case, it makes sense to mention that the solr interpreter needs to be
attached to the newly created note (via its settings section).
> Zeppelin - Solr Ref Guide improvement
> -------------------------------------
>
> Key: SOLR-9611
> URL: https://issues.apache.org/jira/browse/SOLR-9611
> Project: Solr
> Issue Type: Improvement
> Security Level: Public(Default Security Level. Issues are Public)
> Components: documentation
> Reporter: Marius Grama
> Assignee: Kevin Risden
>
> I tried to use the documentation presented here:
> https://cwiki.apache.org/confluence/display/solr/Solr+JDBC+-+Apache+Zeppelin
> but I stumbled on the issue that my query wasn't correctly executed.
> (discovered afterwards that solr interpreter wasn't attached to my document)
> After some digging, I've just added the following properties to the jdbc
> interpreter:
> {code}
> solr.driver org.apache.solr.client.solrj.io.sql.DriverImpl
> solr.url jdbc:solr://localhost:9983/?collection=techproducts
> solr.user solr
> {code}
> and in my notebook i used the following snippet:
> {code}
> %jdbc(solr)
> SELECT cat_s, pubyear_i, title_t FROM books
> {code}
> I have used this documentation to make use of prefixed jdbc interpreter:
> http://zeppelin.apache.org/docs/0.6.0/interpreter/jdbc.html
> Could somebody maybe update the document:
> https://cwiki.apache.org/confluence/display/solr/Solr+JDBC+-+Apache+Zeppelin
> for an easier accomodation of new users that are trying Zeppelin - Solr
> integration?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
