Apache Solr JDBC – Apache Zeppelin (incubating)

Overview

My previous post in my Apache Solr JDBC blog series showed how to connect SQuirrel SQL to Apache Solr. This post highlights how to connect Apache Zeppelin (incubating) to Apache Solr using the JDBC driver. Apache Zeppelin (incubating) is a web-based notebook that enables interactive data analytics. The step by step guide below contains screenshots showing how to add the Apache Solr JDBC driver as an interpreter, use the interpreter in a notebook, and then perform some queries with the notebook. Note that this guide is using Apache Zeppelin 0.6.0 which isn’t released yet since it requires the generic JDBC interpreter. This post corresponds to the Apache Solr JIRA SOLR-8824 and Apache Solr Reference Guide page on Parallel SQL.

Create the Apache Solr JDBC Interpreter

zeppelin_solrjdbc_1

zeppelin_solrjdbc_2 zeppelin_solrjdbc_3

Create a Notebook

zeppelin_solrjdbc_4 zeppelin_solrjdbc_5

Query with the Notebook

zeppelin_solrjdbc_6

What is next?

My next post will highlight how to you can contribute to the Apache Solr JDBC driver. The official Solr documentation Apache Solr Reference Guide will be updated to include more detail about connection parameters and some information about specific clients. If you have any questions about the Solr JDBC driver or want to help contribute, the Solr website has a section on Community and how to use the solr-user mailing list.

The next post in my series, Apache Solr JDBC – How to get involved, is now posted.

And as I’ve stated in my prior posts, myself and my team at Avalon are available to provide expert help with Apache Solr, search on Hadoop (primarily Hortonworks or Cloudera), or general big data projects. If you’ve got an initiative that could use some expertise to guide you down the right path, you can reach us at info <at> avalonconsult.com.  You can also follow our LinkedIn page or sign up to our mail list to be alerted to future installments of my blog series on Apache Solr and the JDBC driver.

Kevin Risden About Kevin Risden

Kevin Risden, an Apache Lucene/Solr committer, has been consulting on search and Hadoop for over 3 years at Avalon Consulting, LLC. He has helped organizations successfully transform their big data into business results.

Leave a Comment

*