Building Data Visualization for SolrCloud 7.0 using Apache Zeppelin

Data Visualization allow you to natively interact with all your data via custom dashboards. Apache Zeppelin is a new and incubating multi-purposed web-based notebook which brings data ingestion, data exploration, visualization, sharing and collaboration features to Hadoop, Solr and Spark.

Apache Zeppelin turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable.

Multi-purpose Notebook 

The Notebook is the place for all your needs

  1.  Data Ingestion
  2.  Data Discovery
  3.  Data Analytics
  4.  Data Visualization & Collaboration

Now, I will explain few features for Apache Zeppelin:

1. Data Visualization

Some basic charts are already included in Apache Zeppelin. Visualizations are not limited to SparkSQL query, any output from any language backend can be recognized and visualized.

2. Pivot Chart

Apache Zeppelin aggregates values and displays them in pivot chart with simple drag and drop. You can easily create chart with multiple aggregated values including sum, count, average, min, max.

3. Dynamic Forms

Apache Zeppelin can dynamically create some input forms in your notebook.

Integrating Apache Solr with Apache Zeppelin

The Solr JDBC driver can support Apache Zeppelin.

This requires Apache Zeppelin 0.6.0 or greater which contains the JDBC interpreter.

To use Apache Zeppelin with Solr, you will need to create a JDBC interpreter for Solr. This will add SolrJ to the interpreter classpath. Once the interpreter has been created, you can create a notebook to issue queries. The Apache Zeppelin JDBC interpreter documentation provides additional information about JDBC prefixes and other features.

Create The Apache Solr JDBC Interpreter

image

Figure 1. Click “Interpreter” in the top navigation

image

Figure 2. Click “Create”

image

Figure 3. Enter information about your Solr installation

Create  a Notebook

image

Figure 4. Click Notebook → Create new note

image

Figure 5. Provide a name and click “Create Note”

Query with the Notebook

image

Figure 6. Results of Solr query

The below code block assumes that the Apache Solr driver is setup as the default JDBC interpreter driver. If that is not the case, instructions for using a different prefix is available here.

%Solr
select fielda, fieldb, from test limit 10