You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@zeppelin.apache.org by ah...@apache.org on 2017/03/13 14:55:42 UTC

svn commit: r1786704 - /zeppelin/site/docs/0.8.0-SNAPSHOT/interpreter/ignite.html

Author: ahyoungryu
Date: Mon Mar 13 14:55:42 2017
New Revision: 1786704

URL: http://svn.apache.org/viewvc?rev=1786704&view=rev
Log: (empty)

Modified:
    zeppelin/site/docs/0.8.0-SNAPSHOT/interpreter/ignite.html

Modified: zeppelin/site/docs/0.8.0-SNAPSHOT/interpreter/ignite.html
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.8.0-SNAPSHOT/interpreter/ignite.html?rev=1786704&r1=1786703&r2=1786704&view=diff
==============================================================================
--- zeppelin/site/docs/0.8.0-SNAPSHOT/interpreter/ignite.html (original)
+++ zeppelin/site/docs/0.8.0-SNAPSHOT/interpreter/ignite.html Mon Mar 13 14:55:42 2017
@@ -1,10 +1,205 @@
----
-layout: page
-title: "Ignite Interpreter for Apache Zeppelin"
-description: "Apache Ignite in-memory Data Fabric is a high-performance, integrated and distributed in-memory platform for computing and transacting on large-scale data sets in real-time, orders of magnitude faster than possible with traditional disk-based or flash technologies."
-group: interpreter
----
-<!--
+
+<!DOCTYPE html>
+<html lang="en">
+  <head>
+    <meta charset="utf-8">
+    <title>Apache Zeppelin 0.8.0-SNAPSHOT Documentation: Ignite Interpreter for Apache Zeppelin</title>
+    <meta name="description" content="Apache Ignite in-memory Data Fabric is a high-performance, integrated and distributed in-memory platform for computing and transacting on large-scale data sets in real-time, orders of magnitude faster than possible with traditional disk-based or flash technologies.">
+    <meta name="author" content="The Apache Software Foundation">
+
+    <!-- Enable responsive viewport -->
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+    <!-- Le HTML5 shim, for IE6-8 support of HTML elements -->
+    <!--[if lt IE 9]>
+    <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
+    <![endif]-->
+
+    <link href="//maxcdn.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.min.css" rel="stylesheet">
+
+    <!-- Le styles -->
+    <link href="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/css/bootstrap.css" rel="stylesheet">
+    <link href="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/css/style.css?body=1" rel="stylesheet" type="text/css">
+    <link href="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/css/syntax.css" rel="stylesheet"  type="text/css" media="screen" /> 
+    <!-- Le fav and touch icons -->
+    <!-- Update these with your own images
+    <link rel="shortcut icon" href="images/favicon.ico">
+    <link rel="apple-touch-icon" href="images/apple-touch-icon.png">
+    <link rel="apple-touch-icon" sizes="72x72" href="images/apple-touch-icon-72x72.png">
+    <link rel="apple-touch-icon" sizes="114x114" href="images/apple-touch-icon-114x114.png">
+    -->
+
+    <!-- Js -->
+    <script src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
+    <script src="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+    <script src="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/js/docs.js"></script>
+    <script src="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/js/anchor.min.js"></script>
+    <script src="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/js/toc.js"></script>
+    <script src="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/js/lunr.min.js"></script>
+    <script src="/docs/0.8.0-SNAPSHOT/assets/themes/zeppelin/js/search.js"></script>    
+
+    <!-- atom & rss feed -->
+    <link href="/docs/0.8.0-SNAPSHOT/atom.xml" type="application/atom+xml" rel="alternate" title="Sitewide ATOM Feed">
+    <link href="/docs/0.8.0-SNAPSHOT/rss.xml" type="application/rss+xml" rel="alternate" title="Sitewide RSS Feed">
+  </head>
+
+  <body>
+    
+        <div id="menu" class="navbar navbar-inverse navbar-fixed-top" role="navigation">
+      <div class="container">
+        <div class="navbar-header">
+          <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
+            <span class="sr-only">Toggle navigation</span>
+            <span class="icon-bar"></span>
+            <span class="icon-bar"></span>
+            <span class="icon-bar"></span>
+          </button>
+          <div class="navbar-brand">
+            <a class="navbar-brand-main" href="http://zeppelin.apache.org">
+              <img src="/assets/themes/zeppelin/img/zeppelin_logo.png" width="50" alt="I'm zeppelin">
+              <span style="vertical-align:middle">Zeppelin</span>
+            </a>
+            <a class="navbar-brand-version" href="/docs/0.8.0-SNAPSHOT">
+              <span><small>0.8.0-SNAPSHOT</small></span>
+            </a>
+          </div>
+        </div>
+        <nav class="navbar-collapse collapse" role="navigation">
+          <ul class="nav navbar-nav">
+            <li>
+              <a href="#" data-toggle="dropdown" class="dropdown-toggle">Quick Start <b class="caret"></b></a>
+              <ul class="dropdown-menu">
+                <li><a href="/docs/0.8.0-SNAPSHOT/index.html">What is Apache Zeppelin ?</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>Getting Started</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/install.html">Install</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/configuration.html">Configuration</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/quickstart/explorezeppelinui.html">Explore Zeppelin UI</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/quickstart/tutorial.html">Tutorial</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>Basic Feature Guide</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/manual/dynamicform.html">Dynamic Form</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/manual/publish.html">Publish your Paragraph</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/manual/notebookashomepage.html">Customize Zeppelin Homepage</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>More</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/upgrade.html">Upgrade Zeppelin Version</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/build.html">Build from source</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/quickstart/install_with_flink_and_spark_cluster.html">Install Zeppelin with Flink and Spark Clusters Tutorial</a></li>
+              </ul>
+            </li>
+            <li>
+              <a href="#" data-toggle="dropdown" class="dropdown-toggle">Interpreter <b class="caret"></b></a>
+              <ul class="dropdown-menu scrollable-menu">
+                <li><a href="/docs/0.8.0-SNAPSHOT/manual/interpreters.html">Overview</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>Usage</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/manual/interpreterinstallation.html">Interpreter Installation</a></li>
+                <!--<li><a href="/docs/0.8.0-SNAPSHOT/manual/dynamicinterpreterload.html">Dynamic Interpreter Loading</a></li>-->
+                <li><a href="/docs/0.8.0-SNAPSHOT/manual/dependencymanagement.html">Interpreter Dependency Management</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/manual/userimpersonation.html">Interpreter User Impersonation</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/manual/interpreterexechooks.html">Interpreter Execution Hooks (Experimental)</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>Available Interpreters</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/alluxio.html">Alluxio</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/beam.html">Beam</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/bigquery.html">BigQuery</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/cassandra.html">Cassandra</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/elasticsearch.html">Elasticsearch</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/flink.html">Flink</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/geode.html">Geode</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/hbase.html">HBase</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/hdfs.html">HDFS</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/hive.html">Hive</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/ignite.html">Ignite</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/jdbc.html">JDBC</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/kylin.html">Kylin</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/lens.html">Lens</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/livy.html">Livy</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/markdown.html">Markdown</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/pig.html">Pig</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/python.html">Python</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/r.html">R</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/scalding.html">Scalding</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/scio.html">Scio</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/shell.html">Shell</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/interpreter/spark.html">Spark</a></li>
+              </ul>
+            </li>
+            <li>
+              <a href="#" data-toggle="dropdown" class="dropdown-toggle">Display System <b class="caret"></b></a>
+              <ul class="dropdown-menu">
+                <li class="title"><span><b>Basic Display System</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#table">Table</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>Angular API</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/displaysystem/back-end-angular.html">Angular (backend API)</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/displaysystem/front-end-angular.html">Angular (frontend API)</a></li>
+              </ul>
+            </li>
+            <li>
+              <a href="#" data-toggle="dropdown" class="dropdown-toggle">More<b class="caret"></b></a>
+              <ul class="dropdown-menu scrollable-menu" style="right: 0; left: auto;">
+                <li class="title"><span><b>Notebook Storage</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/storage/storage.html#notebook-storage-in-local-git-repository">Git Storage</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/storage/storage.html#notebook-storage-in-s3">S3 Storage</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/storage/storage.html#notebook-storage-in-azure">Azure Storage</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/storage/storage.html#storage-in-zeppelinhub">ZeppelinHub Storage</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/storage/storage.html#notebook-storage-in-mongodb">MongoDB Storage</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>REST API</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/rest-api/rest-interpreter.html">Interpreter API</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/rest-api/rest-notebook.html">Notebook API</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/rest-api/rest-notebookRepo.html">Notebook Repository API</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/rest-api/rest-configuration.html">Configuration API</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/rest-api/rest-credential.html">Credential API</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/rest-api/rest-helium.html">Helium API</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>Security</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/security/shiroauthentication.html">Shiro Authentication</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/security/notebook_authorization.html">Notebook Authorization</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/security/datasource_authorization.html">Data Source Authorization</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>Advanced</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/spark_cluster_mode.html#spark-standalone-mode">Zeppelin on Spark Cluster Mode (Standalone)</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/spark_cluster_mode.html#spark-on-yarn-mode">Zeppelin on Spark Cluster Mode (YARN)</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/spark_cluster_mode.html#spark-on-mesos-mode">Zeppelin on Spark Cluster Mode (Mesos)</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/install/cdh.html">Zeppelin on CDH</a></li>
+                <li role="separator" class="divider"></li>
+                <li class="title"><span><b>Contibute</b><span></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/development/writingzeppelininterpreter.html">Writing Zeppelin Interpreter</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/development/writingzeppelinspell.html">Writing Zeppelin Spell (Experimental)</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/development/writingzeppelinvisualization.html">Writing Zeppelin Visualization (Experimental)</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/development/writingzeppelinapplication.html">Writing Zeppelin Application (Experimental)</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/development/howtocontribute.html">How to contribute (code)</a></li>
+                <li><a href="/docs/0.8.0-SNAPSHOT/development/howtocontributewebsite.html">How to contribute (website)</a></li>
+              </ul>
+            </li>
+            <li>
+              <a href="/docs/0.8.0-SNAPSHOT/search.html" class="nav-search-link">
+                <span class="fa fa-search nav-search-icon"></span>
+              </a>
+            </li>
+          </ul>
+        </nav><!--/.navbar-collapse -->
+      </div>
+    </div>
+
+
+    <div class="content">
+      
+<!--<div class="hero-unit Ignite Interpreter for Apache Zeppelin">
+  <h1></h1>
+</div>
+-->
+
+<div class="row">
+  <div class="col-md-12">
+    <!--
 Licensed under the Apache License, Version 2.0 (the "License");
 you may not use this file except in compliance with the License.
 You may obtain a copy of the License at
@@ -17,37 +212,42 @@ WITHOUT WARRANTIES OR CONDITIONS OF ANY
 See the License for the specific language governing permissions and
 limitations under the License.
 -->
-{% include JB/setup %}
 
-# Ignite Interpreter for Apache Zeppelin
+<h1>Ignite Interpreter for Apache Zeppelin</h1>
 
 <div id="toc"></div>
 
-## Overview
-[Apache Ignite](https://ignite.apache.org/) In-Memory Data Fabric is a high-performance, integrated and distributed in-memory platform for computing and transacting on large-scale data sets in real-time, orders of magnitude faster than possible with traditional disk-based or flash technologies.
+<h2>Overview</h2>
 
-![Apache Ignite](../assets/themes/zeppelin/img/docs-img/ignite-logo.png)
+<p><a href="https://ignite.apache.org/">Apache Ignite</a> In-Memory Data Fabric is a high-performance, integrated and distributed in-memory platform for computing and transacting on large-scale data sets in real-time, orders of magnitude faster than possible with traditional disk-based or flash technologies.</p>
 
-You can use Zeppelin to retrieve distributed data from cache using Ignite SQL interpreter. Moreover, Ignite interpreter allows you to execute any Scala code in cases when SQL doesn't fit to your requirements. For example, you can populate data into your caches or execute distributed computations.
+<p><img src="../assets/themes/zeppelin/img/docs-img/ignite-logo.png" alt="Apache Ignite"></p>
 
-## Installing and Running Ignite example
-In order to use Ignite interpreters, you may install Apache Ignite in some simple steps:
+<p>You can use Zeppelin to retrieve distributed data from cache using Ignite SQL interpreter. Moreover, Ignite interpreter allows you to execute any Scala code in cases when SQL doesn&#39;t fit to your requirements. For example, you can populate data into your caches or execute distributed computations.</p>
 
-1. Ignite provides examples only with source or binary release. Download Ignite [source release](https://ignite.apache.org/download.html#sources) or [binary release](https://ignite.apache.org/download.html#binaries) whatever you want. But you must download Ignite as the same version of Zeppelin's. If it is not, you can't use scala code on Zeppelin. The supported Ignite version is specified in [Supported Interpreter table](https://zeppelin.apache.org/supported_interpreters.html#ignite) for each Zeppelin release. If you're using Zeppelin master branch, please see `ignite.version` in `path/to/your-Zeppelin/ignite/pom.xml`.
-2. Examples are shipped as a separate Maven project, so to start running you simply need to import provided `<dest_dir>/apache-ignite-fabric-{version}-bin/examples/pom.xml` file into your favourite IDE, such as Eclipse.
+<h2>Installing and Running Ignite example</h2>
 
-* In case of Eclipse, Eclipse -> File -> Import -> Existing Maven Projects
-* Set examples directory path to Eclipse and select the pom.xml.
-* Then start `org.apache.ignite.examples.ExampleNodeStartup` (or whatever you want) to run at least one or more ignite node. When you run example code, you may notice that the number of node is increase one by one.
+<p>In order to use Ignite interpreters, you may install Apache Ignite in some simple steps:</p>
 
-> **Tip. If you want to run Ignite examples on the cli not IDE, you can export executable Jar file from IDE. Then run it by using below command.**
+<ol>
+<li>Ignite provides examples only with source or binary release. Download Ignite <a href="https://ignite.apache.org/download.html#sources">source release</a> or <a href="https://ignite.apache.org/download.html#binaries">binary release</a> whatever you want. But you must download Ignite as the same version of Zeppelin&#39;s. If it is not, you can&#39;t use scala code on Zeppelin. The supported Ignite version is specified in <a href="https://zeppelin.apache.org/supported_interpreters.html#ignite">Supported Interpreter table</a> for each Zeppelin release. If you&#39;re using Zeppelin master branch, please see <code>ignite.version</code> in <code>path/to/your-Zeppelin/ignite/pom.xml</code>.</li>
+<li>Examples are shipped as a separate Maven project, so to start running you simply need to import provided <code>&lt;dest_dir&gt;/apache-ignite-fabric-{version}-bin/examples/pom.xml</code> file into your favourite IDE, such as Eclipse.</li>
+</ol>
 
-```
-$ nohup java -jar </path/to/your Jar file name>
-```
+<ul>
+<li>In case of Eclipse, Eclipse -&gt; File -&gt; Import -&gt; Existing Maven Projects</li>
+<li>Set examples directory path to Eclipse and select the pom.xml.</li>
+<li>Then start <code>org.apache.ignite.examples.ExampleNodeStartup</code> (or whatever you want) to run at least one or more ignite node. When you run example code, you may notice that the number of node is increase one by one.</li>
+</ul>
 
-## Configuring Ignite Interpreter
-At the "Interpreters" menu, you may edit Ignite interpreter or create new one. Zeppelin provides these properties for Ignite.
+<blockquote>
+<p><strong>Tip. If you want to run Ignite examples on the cli not IDE, you can export executable Jar file from IDE. Then run it by using below command.</strong></p>
+</blockquote>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">$ nohup java -jar &lt;/path/to/your Jar file name&gt;
+</code></pre></div>
+<h2>Configuring Ignite Interpreter</h2>
+
+<p>At the &quot;Interpreters&quot; menu, you may edit Ignite interpreter or create new one. Zeppelin provides these properties for Ignite.</p>
 
 <table class="table-configuration">
   <tr>
@@ -82,31 +282,28 @@ At the "Interpreters" menu, you may edit
   </tr>
 </table>
 
-![Configuration of Ignite Interpreter](../assets/themes/zeppelin/img/docs-img/ignite-interpreter-setting.png)
+<p><img src="../assets/themes/zeppelin/img/docs-img/ignite-interpreter-setting.png" alt="Configuration of Ignite Interpreter"></p>
 
-## How to use
-After configuring Ignite interpreter, create your own notebook. Then you can bind interpreters like below image.
+<h2>How to use</h2>
 
-![Binding Interpreters](../assets/themes/zeppelin/img/docs-img/ignite-interpreter-binding.png)
+<p>After configuring Ignite interpreter, create your own notebook. Then you can bind interpreters like below image.</p>
 
-For more interpreter binding information see [here](../manual/interpreters.html#what-is-interpreter-setting).
+<p><img src="../assets/themes/zeppelin/img/docs-img/ignite-interpreter-binding.png" alt="Binding Interpreters"></p>
 
-### Ignite SQL interpreter
-In order to execute SQL query, use ` %ignite.ignitesql ` prefix. <br>
-Supposing you are running `org.apache.ignite.examples.streaming.wordcount.StreamWords`, then you can use "words" cache( Of course you have to specify this cache name to the Ignite interpreter setting section `ignite.jdbc.url` of Zeppelin ).
-For example, you can select top 10 words in the words cache using the following query
+<p>For more interpreter binding information see <a href="../manual/interpreters.html#what-is-interpreter-setting">here</a>.</p>
 
-```
-%ignite.ignitesql
-select _val, count(_val) as cnt from String group by _val order by cnt desc limit 10
-```
+<h3>Ignite SQL interpreter</h3>
 
-![IgniteSql on Zeppelin](../assets/themes/zeppelin/img/docs-img/ignite-sql-example.png)
-
-As long as your Ignite version and Zeppelin Ignite version is same, you can also use scala code. Please check the Zeppelin Ignite version before you download your own Ignite.
+<p>In order to execute SQL query, use <code>%ignite.ignitesql</code> prefix. <br>
+Supposing you are running <code>org.apache.ignite.examples.streaming.wordcount.StreamWords</code>, then you can use &quot;words&quot; cache( Of course you have to specify this cache name to the Ignite interpreter setting section <code>ignite.jdbc.url</code> of Zeppelin ).
+For example, you can select top 10 words in the words cache using the following query</p>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">%ignite.ignitesql
+select _val, count(_val) as cnt from String group by _val order by cnt desc limit 10
+</code></pre></div>
+<p><img src="../assets/themes/zeppelin/img/docs-img/ignite-sql-example.png" alt="IgniteSql on Zeppelin"></p>
 
-```
-%ignite
+<p>As long as your Ignite version and Zeppelin Ignite version is same, you can also use scala code. Please check the Zeppelin Ignite version before you download your own Ignite.</p>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">%ignite
 import org.apache.ignite._
 import org.apache.ignite.cache.affinity._
 import org.apache.ignite.cache.query._
@@ -114,15 +311,45 @@ import org.apache.ignite.configuration._
 
 import scala.collection.JavaConversions._
 
-val cache: IgniteCache[AffinityUuid, String] = ignite.cache("words")
+val cache: IgniteCache[AffinityUuid, String] = ignite.cache(&quot;words&quot;)
 
-val qry = new SqlFieldsQuery("select avg(cnt), min(cnt), max(cnt) from (select count(_val) as cnt from String group by _val)", true)
+val qry = new SqlFieldsQuery(&quot;select avg(cnt), min(cnt), max(cnt) from (select count(_val) as cnt from String group by _val)&quot;, true)
 
 val res = cache.query(qry).getAll()
 
 collectionAsScalaIterable(res).foreach(println _)
-```
+</code></pre></div>
+<p><img src="../assets/themes/zeppelin/img/docs-img/ignite-scala-example.png" alt="Using Scala Code"></p>
+
+<p>Apache Ignite also provides a guide docs for Zeppelin <a href="https://apacheignite.readme.io/docs/data-analysis-with-apache-zeppelin">&quot;Ignite with Apache Zeppelin&quot;</a></p>
+
+  </div>
+</div>
+
+
+      <hr>
+      <footer>
+        <!-- <p>&copy; 2017 The Apache Software Foundation</p>-->
+      </footer>
+    </div>
+
+    
+
+
+  <script type="text/javascript">
+  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+  ga('create', 'UA-45176241-5', 'zeppelin.apache.org');
+  ga('require', 'linkid', 'linkid.js');
+  ga('send', 'pageview');
+
+</script>
+
+
 
-![Using Scala Code](../assets/themes/zeppelin/img/docs-img/ignite-scala-example.png)
+  </body>
+</html>
 
-Apache Ignite also provides a guide docs for Zeppelin ["Ignite with Apache Zeppelin"](https://apacheignite.readme.io/docs/data-analysis-with-apache-zeppelin)