Added: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/hive.html
URL:
http://svn.apache.org/viewvc/zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/hive.html?rev=1751605&view=auto
==============================================================================
--- zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/hive.html (added)
+++ zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/hive.html Wed Jul 6 06:25:29
2016
@@ -0,0 +1,340 @@
+
+<!DOCTYPE html>
+<html lang="en">
+ <head>
+ <meta charset="utf-8">
+ <title>Hive Interpreter</title>
+ <meta name="description" content="">
+ <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.7.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/css/bootstrap.css"
rel="stylesheet">
+ <link
href="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/css/style.css?body=1"
rel="stylesheet" type="text/css">
+ <link href="/docs/0.7.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.7.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/docs.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.7.0-SNAPSHOT/atom.xml" type="application/atom+xml"
rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.7.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>
+ <a class="navbar-brand" href="/docs/0.7.0-SNAPSHOT">
+ <img src="/assets/themes/zeppelin/img/zeppelin_logo.png"
width="50" alt="I'm zeppelin">
+ <span style="vertical-align:middle">Zeppelin</span>
+ <span
style="vertical-align:baseline"><small>0.7.0-SNAPSHOT</small></span>
+ </a>
+ </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.7.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.7.0-SNAPSHOT/install/install.html">Install</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/quickstart/explorezeppelinui.html">Explore Zeppelin
UI</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/manual/dynamicform.html">Dynamic Form</a></li>
+ <li><a href="/docs/0.7.0-SNAPSHOT/manual/publish.html">Publish
your Paragraph</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/install/virtual_machine.html">Zeppelin on Vagrant
VM</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/install/upgrade.html">Upgrade Zeppelin
Version</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.7.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.7.0-SNAPSHOT/manual/interpreterinstallation.html">Interpreter
Installation</a></li>
+ <!--<li><a
href="/docs/0.7.0-SNAPSHOT/manual/dynamicinterpreterload.html">Dynamic
Interpreter Loading</a></li>-->
+ <li><a
href="/docs/0.7.0-SNAPSHOT/manual/dependencymanagement.html">Interpreter
Dependency Management</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Available
Interpreters</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/flink.html">Flink</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/geode.html">Geode</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hbase.html">HBase</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hdfs.html">HDFS</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hive.html">Hive</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/ignite.html">Ignite</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html">JDBC</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/lens.html">Lens</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/livy.html">Livy</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/markdown.html">Markdown</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/python.html">Python</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/postgresql.html">Postgresql,
HAWQ</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/r.html">R</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/scalding.html">Scalding</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/pleasecontribute.html">Shell</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/displaysystem/back-end-angular.html">Angular
(backend API)</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-local-git-repository">Git
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-s3">S3
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-azure">Azure
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#storage-in-zeppelinhub">ZeppelinHub
Storage</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>REST API</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-interpreter.html">Interpreter
API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-notebook.html">Notebook API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-configuration.html">Configuration
API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-credential.html">Credential
API</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Security</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/authentication.html">Authentication for
NGINX</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/shiroauthentication.html">Shiro
Authentication</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/notebook_authorization.html">Notebook
Authorization</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/interpreter_authorization.html">Interpreter
& Data Resource Authorization</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Contibute</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/writingzeppelininterpreter.html">Writing
Zeppelin Interpreter</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/writingzeppelinapplication.html">Writing
Zeppelin Application</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/howtocontribute.html">How to contribute
(code)</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/howtocontributewebsite.html">How to
contribute (website)</a></li>
+ </ul>
+ </li>
+ </ul>
+ </nav><!--/.navbar-collapse -->
+ </div>
+ </div>
+
+
+ <div class="content">
+
+<!--<div class="hero-unit Hive Interpreter">
+ <h1></h1>
+</div>
+-->
+
+<div class="row">
+ <div class="col-md-12">
+ <h1>Hive Interpreter for Apache Zeppelin</h1>
+
+<div id="toc"></div>
+
+<h2>Important Notice</h2>
+
+<p>Hive Interpreter will be deprecated and merged into JDBC Interpreter. You
can use Hive Interpreter by using JDBC Interpreter with same functionality. See
the example below of settings and dependencies.</p>
+
+<h3>Properties</h3>
+
+<table class="table-configuration">
+ <tr>
+ <th>Property</th>
+ <th>Value</th>
+ </tr>
+ <tr>
+ <td>hive.driver</td>
+ <td>org.apache.hive.jdbc.HiveDriver</td>
+ </tr>
+ <tr>
+ <td>hive.url</td>
+ <td>jdbc:hive2://localhost:10000</td>
+ </tr>
+ <tr>
+ <td>hive.user</td>
+ <td>hiveUser</td>
+ </tr>
+ <tr>
+ <td>hive.password</td>
+ <td>hivePassword</td>
+ </tr>
+</table>
+
+<h3>Dependencies</h3>
+
+<table class="table-configuration">
+ <tr>
+ <th>Artifact</th>
+ <th>Exclude</th>
+ </tr>
+ <tr>
+ <td>org.apache.hive:hive-jdbc:0.14.0</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>org.apache.hadoop:hadoop-common:2.6.0</td>
+ <td></td>
+ </tr>
+</table>
+
+<h3>Configuration</h3>
+
+<table class="table-configuration">
+ <tr>
+ <th>Property</th>
+ <th>Default</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>default.driver</td>
+ <td>org.apache.hive.jdbc.HiveDriver</td>
+ <td>Class path of JDBC driver</td>
+ </tr>
+ <tr>
+ <td>default.url</td>
+ <td>jdbc:hive2://localhost:10000</td>
+ <td>Url for connection</td>
+ </tr>
+ <tr>
+ <td>default.user</td>
+ <td></td>
+ <td><b>( Optional ) </b>Username of the connection</td>
+ </tr>
+ <tr>
+ <td>default.password</td>
+ <td></td>
+ <td><b>( Optional ) </b>Password of the connection</td>
+ </tr>
+ <tr>
+ <td>default.xxx</td>
+ <td></td>
+ <td><b>( Optional ) </b>Other properties used by the driver</td>
+ </tr>
+ <tr>
+ <td>${prefix}.driver</td>
+ <td></td>
+ <td>Driver class path of <code>%hive(${prefix})</code> </td>
+ </tr>
+ <tr>
+ <td>${prefix}.url</td>
+ <td></td>
+ <td>Url of <code>%hive(${prefix})</code> </td>
+ </tr>
+ <tr>
+ <td>${prefix}.user</td>
+ <td></td>
+ <td><b>( Optional ) </b>Username of the connection of
<code>%hive(${prefix})</code> </td>
+ </tr>
+ <tr>
+ <td>${prefix}.password</td>
+ <td></td>
+ <td><b>( Optional ) </b>Password of the connection of
<code>%hive(${prefix})</code> </td>
+ </tr>
+ <tr>
+ <td>${prefix}.xxx</td>
+ <td></td>
+ <td><b>( Optional ) </b>Other properties used by the driver of
<code>%hive(${prefix})</code> </td>
+ </tr>
+</table>
+
+<p>This interpreter provides multiple configuration with
<code>${prefix}</code>. User can set a multiple connection properties by this
prefix. It can be used like <code>%hive(${prefix})</code>.</p>
+
+<h2>Overview</h2>
+
+<p>The <a href="https://hive.apache.org/";>Apache Hive</a> ⢠data warehouse
software facilitates querying and managing large datasets residing in
distributed storage. Hive provides a mechanism to project structure onto this
data and query the data using a SQL-like language called HiveQL. At the same
time this language also allows traditional map/reduce programmers to plug in
their custom mappers and reducers when it is inconvenient or inefficient to
express this logic in HiveQL.</p>
+
+<h2>How to use</h2>
+
+<p>Basically, you can use</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">hive</span>
+<span class="k">select</span> <span class="o">*</span> <span
class="k">from</span> <span class="n">my_table</span><span class="p">;</span>
+</code></pre></div>
+<p>or</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">hive</span><span
class="p">(</span><span class="n">etl</span><span class="p">)</span>
+<span class="c1">-- 'etl' is a ${prefix}</span>
+<span class="k">select</span> <span class="o">*</span> <span
class="k">from</span> <span class="n">my_table</span><span class="p">;</span>
+</code></pre></div>
+<p>You can also run multiple queries up to 10 by default. Changing these
settings is not implemented yet.</p>
+
+<h3>Apply Zeppelin Dynamic Forms</h3>
+
+<p>You can leverage <a
href="/docs/0.7.0-SNAPSHOT/manual/dynamicform.html">Zeppelin Dynamic Form</a>
inside your queries. You can use both the <code>text input</code> and
<code>select form</code> parameterization features.</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">hive</span>
+<span class="k">SELECT</span> <span class="err">${</span><span
class="n">group_by</span><span class="err">}</span><span class="p">,</span>
<span class="k">count</span><span class="p">(</span><span
class="o">*</span><span class="p">)</span> <span class="k">as</span> <span
class="k">count</span>
+<span class="k">FROM</span> <span class="n">retail_demo</span><span
class="p">.</span><span class="n">order_lineitems_pxf</span>
+<span class="k">GROUP</span> <span class="k">BY</span> <span
class="err">${</span><span class="n">group_by</span><span
class="o">=</span><span class="n">product_id</span><span
class="p">,</span><span class="n">product_id</span><span
class="o">|</span><span class="n">product_name</span><span
class="o">|</span><span class="n">customer_id</span><span
class="o">|</span><span class="n">store_id</span><span class="err">}</span>
+<span class="k">ORDER</span> <span class="k">BY</span> <span
class="k">count</span> <span class="err">${</span><span
class="k">order</span><span class="o">=</span><span class="k">DESC</span><span
class="p">,</span><span class="k">DESC</span><span class="o">|</span><span
class="k">ASC</span><span class="err">}</span>
+<span class="k">LIMIT</span> <span class="err">${</span><span
class="k">limit</span><span class="o">=</span><span class="mi">10</span><span
class="err">}</span><span class="p">;</span>
+</code></pre></div>
+ </div>
+</div>
+
+
+ <hr>
+ <footer>
+ <!-- <p>© 2016 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>
+
+
+
+ </body>
+</html>
+
Propchange: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/hive.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/ignite.html
URL:
http://svn.apache.org/viewvc/zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/ignite.html?rev=1751605&view=auto
==============================================================================
--- zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/ignite.html (added)
+++ zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/ignite.html Wed Jul 6
06:25:29 2016
@@ -0,0 +1,311 @@
+
+<!DOCTYPE html>
+<html lang="en">
+ <head>
+ <meta charset="utf-8">
+ <title>Ignite Interpreter</title>
+ <meta name="description" content="Ignite user guide">
+ <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.7.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/css/bootstrap.css"
rel="stylesheet">
+ <link
href="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/css/style.css?body=1"
rel="stylesheet" type="text/css">
+ <link href="/docs/0.7.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.7.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/docs.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.7.0-SNAPSHOT/atom.xml" type="application/atom+xml"
rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.7.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>
+ <a class="navbar-brand" href="/docs/0.7.0-SNAPSHOT">
+ <img src="/assets/themes/zeppelin/img/zeppelin_logo.png"
width="50" alt="I'm zeppelin">
+ <span style="vertical-align:middle">Zeppelin</span>
+ <span
style="vertical-align:baseline"><small>0.7.0-SNAPSHOT</small></span>
+ </a>
+ </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.7.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.7.0-SNAPSHOT/install/install.html">Install</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/quickstart/explorezeppelinui.html">Explore Zeppelin
UI</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/manual/dynamicform.html">Dynamic Form</a></li>
+ <li><a href="/docs/0.7.0-SNAPSHOT/manual/publish.html">Publish
your Paragraph</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/install/virtual_machine.html">Zeppelin on Vagrant
VM</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/install/upgrade.html">Upgrade Zeppelin
Version</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.7.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.7.0-SNAPSHOT/manual/interpreterinstallation.html">Interpreter
Installation</a></li>
+ <!--<li><a
href="/docs/0.7.0-SNAPSHOT/manual/dynamicinterpreterload.html">Dynamic
Interpreter Loading</a></li>-->
+ <li><a
href="/docs/0.7.0-SNAPSHOT/manual/dependencymanagement.html">Interpreter
Dependency Management</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Available
Interpreters</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/flink.html">Flink</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/geode.html">Geode</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hbase.html">HBase</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hdfs.html">HDFS</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hive.html">Hive</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/ignite.html">Ignite</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html">JDBC</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/lens.html">Lens</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/livy.html">Livy</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/markdown.html">Markdown</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/python.html">Python</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/postgresql.html">Postgresql,
HAWQ</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/r.html">R</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/scalding.html">Scalding</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/pleasecontribute.html">Shell</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/displaysystem/back-end-angular.html">Angular
(backend API)</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-local-git-repository">Git
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-s3">S3
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-azure">Azure
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#storage-in-zeppelinhub">ZeppelinHub
Storage</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>REST API</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-interpreter.html">Interpreter
API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-notebook.html">Notebook API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-configuration.html">Configuration
API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-credential.html">Credential
API</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Security</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/authentication.html">Authentication for
NGINX</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/shiroauthentication.html">Shiro
Authentication</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/notebook_authorization.html">Notebook
Authorization</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/interpreter_authorization.html">Interpreter
& Data Resource Authorization</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Contibute</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/writingzeppelininterpreter.html">Writing
Zeppelin Interpreter</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/writingzeppelinapplication.html">Writing
Zeppelin Application</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/howtocontribute.html">How to contribute
(code)</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/howtocontributewebsite.html">How to
contribute (website)</a></li>
+ </ul>
+ </li>
+ </ul>
+ </nav><!--/.navbar-collapse -->
+ </div>
+ </div>
+
+
+ <div class="content">
+
+<!--<div class="hero-unit Ignite Interpreter">
+ <h1></h1>
+</div>
+-->
+
+<div class="row">
+ <div class="col-md-12">
+ <h1>Ignite Interpreter for Apache Zeppelin</h1>
+
+<div id="toc"></div>
+
+<h2>Overview</h2>
+
+<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>
+
+<p><img src="../assets/themes/zeppelin/img/docs-img/ignite-logo.png"
alt="Apache Ignite"></p>
+
+<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>
+
+<h2>Installing and Running Ignite example</h2>
+
+<p>In order to use Ignite interpreters, you may install Apache Ignite in some
simple steps:</p>
+
+<ol>
+<li>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's. If it is not, you can't use scala code on Zeppelin. You can
find ignite version in Zeppelin at the pom.xml which is placed under
<code>path/to/your-Zeppelin/ignite/pom.xml</code> ( Of course, in Zeppelin
source release ). Please check <code>ignite.version</code> .<br>Currently,
Zeppelin provides ignite only in Zeppelin source release. So, if you download
Zeppelin binary release(
<code>zeppelin-0.5.0-incubating-bin-spark-xxx-hadoop-xx</code> ), you can not
use ignite interpreter on Zeppelin. We are planning to include ignite in a
future binary release.</li>
+<li>Examples are shipped as a separate Maven project, so to start running you
simply need to import provided
<dest_dir>/apache-ignite-fabric-1.2.0-incubating-bin/pom.xml file into your
favourite IDE, such as Eclipse.</li>
+</ol>
+
+<ul>
+<li>In case of Eclipse, Eclipse -> File -> Import -> 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>
+
+<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 </path/to/your Jar file name>
+</code></pre></div>
+<h2>Configuring Ignite Interpreter</h2>
+
+<p>At the "Interpreters" menu, you may edit Ignite interpreter or
create new one. Zeppelin provides these properties for Ignite.</p>
+
+<table class="table-configuration">
+ <tr>
+ <th>Property Name</th>
+ <th>value</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>ignite.addresses</td>
+ <td>127.0.0.1:47500..47509</td>
+ <td>Coma separated list of Ignite cluster hosts. See [Ignite Cluster
Configuration](https://apacheignite.readme.io/v1.2/docs/cluster-config) section
for more details.</td>
+ </tr>
+ <tr>
+ <td>ignite.clientMode</td>
+ <td>true</td>
+ <td>You can connect to the Ignite cluster as client or server node. See
[Ignite Clients vs.
Servers](https://apacheignite.readme.io/v1.2/docs/clients-vs-servers) section
for details. Use true or false values in order to connect in client or server
mode respectively.</td>
+ </tr>
+ <tr>
+ <td>ignite.config.url</td>
+ <td></td>
+ <td>Configuration URL. Overrides all other settings.</td>
+ </tr>
+ <tr>
+ <td>ignite.jdbc.url</td>
+ <td>jdbc:ignite:cfg://default-ignite-jdbc.xml</td>
+ <td>Ignite JDBC connection URL.</td>
+ </tr>
+ <tr>
+ <td>ignite.peerClassLoadingEnabled</td>
+ <td>true</td>
+ <td>Enables peer-class-loading. See [Zero
Deployment](https://apacheignite.readme.io/v1.2/docs/zero-deployment) section
for details. Use true or false values in order to enable or disable P2P class
loading respectively.</td>
+ </tr>
+</table>
+
+<p><img
src="../assets/themes/zeppelin/img/docs-img/ignite-interpreter-setting.png"
alt="Configuration of Ignite Interpreter"></p>
+
+<h2>How to use</h2>
+
+<p>After configuring Ignite interpreter, create your own notebook. Then you
can bind interpreters like below image.</p>
+
+<p><img
src="../assets/themes/zeppelin/img/docs-img/ignite-interpreter-binding.png"
alt="Binding Interpreters"></p>
+
+<p>For more interpreter binding information see <a
href="http://zeppelin.apache.org/docs/manual/interpreters.html";>here</a>.</p>
+
+<h3>Ignite SQL interpreter</h3>
+
+<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 "words" 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>
+
+<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._
+import org.apache.ignite.configuration._
+
+import scala.collection.JavaConversions._
+
+val cache: IgniteCache[AffinityUuid, String] = ignite.cache("words")
+
+val qry = new SqlFieldsQuery("select avg(cnt), min(cnt), max(cnt) from
(select count(_val) as cnt from String group by _val)", 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";>"Ignite
with Apache Zeppelin"</a></p>
+
+ </div>
+</div>
+
+
+ <hr>
+ <footer>
+ <!-- <p>© 2016 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>
+
+
+
+ </body>
+</html>
+
Propchange: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/ignite.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html
URL:
http://svn.apache.org/viewvc/zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html?rev=1751605&view=auto
==============================================================================
--- zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html (added)
+++ zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html Wed Jul 6 06:25:29
2016
@@ -0,0 +1,538 @@
+
+<!DOCTYPE html>
+<html lang="en">
+ <head>
+ <meta charset="utf-8">
+ <title>Generic JDBC Interpreter</title>
+ <meta name="description" content="JDBC user guide">
+ <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.7.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/css/bootstrap.css"
rel="stylesheet">
+ <link
href="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/css/style.css?body=1"
rel="stylesheet" type="text/css">
+ <link href="/docs/0.7.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.7.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/docs.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.7.0-SNAPSHOT/atom.xml" type="application/atom+xml"
rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.7.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>
+ <a class="navbar-brand" href="/docs/0.7.0-SNAPSHOT">
+ <img src="/assets/themes/zeppelin/img/zeppelin_logo.png"
width="50" alt="I'm zeppelin">
+ <span style="vertical-align:middle">Zeppelin</span>
+ <span
style="vertical-align:baseline"><small>0.7.0-SNAPSHOT</small></span>
+ </a>
+ </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.7.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.7.0-SNAPSHOT/install/install.html">Install</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/quickstart/explorezeppelinui.html">Explore Zeppelin
UI</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/manual/dynamicform.html">Dynamic Form</a></li>
+ <li><a href="/docs/0.7.0-SNAPSHOT/manual/publish.html">Publish
your Paragraph</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/install/virtual_machine.html">Zeppelin on Vagrant
VM</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/install/upgrade.html">Upgrade Zeppelin
Version</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.7.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.7.0-SNAPSHOT/manual/interpreterinstallation.html">Interpreter
Installation</a></li>
+ <!--<li><a
href="/docs/0.7.0-SNAPSHOT/manual/dynamicinterpreterload.html">Dynamic
Interpreter Loading</a></li>-->
+ <li><a
href="/docs/0.7.0-SNAPSHOT/manual/dependencymanagement.html">Interpreter
Dependency Management</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Available
Interpreters</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/flink.html">Flink</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/geode.html">Geode</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hbase.html">HBase</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hdfs.html">HDFS</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hive.html">Hive</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/ignite.html">Ignite</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html">JDBC</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/lens.html">Lens</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/livy.html">Livy</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/markdown.html">Markdown</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/python.html">Python</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/postgresql.html">Postgresql,
HAWQ</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/r.html">R</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/scalding.html">Scalding</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/pleasecontribute.html">Shell</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/displaysystem/back-end-angular.html">Angular
(backend API)</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-local-git-repository">Git
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-s3">S3
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-azure">Azure
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#storage-in-zeppelinhub">ZeppelinHub
Storage</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>REST API</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-interpreter.html">Interpreter
API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-notebook.html">Notebook API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-configuration.html">Configuration
API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-credential.html">Credential
API</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Security</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/authentication.html">Authentication for
NGINX</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/shiroauthentication.html">Shiro
Authentication</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/notebook_authorization.html">Notebook
Authorization</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/interpreter_authorization.html">Interpreter
& Data Resource Authorization</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Contibute</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/writingzeppelininterpreter.html">Writing
Zeppelin Interpreter</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/writingzeppelinapplication.html">Writing
Zeppelin Application</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/howtocontribute.html">How to contribute
(code)</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/howtocontributewebsite.html">How to
contribute (website)</a></li>
+ </ul>
+ </li>
+ </ul>
+ </nav><!--/.navbar-collapse -->
+ </div>
+ </div>
+
+
+ <div class="content">
+
+<!--<div class="hero-unit Generic JDBC Interpreter">
+ <h1></h1>
+</div>
+-->
+
+<div class="row">
+ <div class="col-md-12">
+ <h1>Generic JDBC Interpreter for Apache Zeppelin</h1>
+
+<div id="toc"></div>
+
+<h2>Overview</h2>
+
+<p>This interpreter lets you create a JDBC connection to any data source, by
now it has been tested with:</p>
+
+<ul>
+<li>Postgres</li>
+<li>MySql</li>
+<li>MariaDB</li>
+<li>Redshift</li>
+<li>Apache Hive</li>
+<li>Apache Phoenix</li>
+<li>Apache Drill (Details on using [Drill JDBC
Driver](https://drill.apache.org/docs/using-the-jdbc-driverde* Apache Tajo</li>
+</ul>
+
+<p>If someone else used another database please report how it works to improve
functionality.</p>
+
+<h2>Create Interpreter</h2>
+
+<p>When you create a interpreter by default use PostgreSQL with the next
properties:</p>
+
+<table class="table-configuration">
+ <tr>
+ <th>name</th>
+ <th>value</th>
+ </tr>
+ <tr>
+ <td>common.max_count</td>
+ <td>1000</td>
+ </tr>
+ <tr>
+ <td>default.driver</td>
+ <td>org.postgresql.Driver</td>
+ </tr>
+ <tr>
+ <td>default.password</td>
+ <td>********</td>
+ </tr>
+ <tr>
+ <td>default.url</td>
+ <td>jdbc:postgresql://localhost:5432/</td>
+ </tr>
+ <tr>
+ <td>default.user</td>
+ <td>gpadmin</td>
+ </tr>
+</table>
+
+<p>It is not necessary to add driver jar to the classpath for PostgreSQL as it
is included in Zeppelin.</p>
+
+<h3>Simple connection</h3>
+
+<p>Prior to creating the interpreter it is necessary to add maven coordinate
or path of the JDBC driver to the Zeppelin classpath. To do this you must edit
dependencies artifact(ex. <code>mysql:mysql-connector-java:5.1.38</code>) in
interpreter menu as shown:</p>
+
+<div class="row">
+ <div class="col-md-11">
+ <img
src="../assets/themes/zeppelin/img/docs-img/jdbc-simple-connection-setting.png"
/>
+ </div>
+</div>
+
+<p>To create the interpreter you need to specify connection parameters as
shown in the table.</p>
+
+<table class="table-configuration">
+ <tr>
+ <th>name</th>
+ <th>value</th>
+ </tr>
+ <tr>
+ <td>common.max_count</td>
+ <td>1000</td>
+ </tr>
+ <tr>
+ <td>default.driver</td>
+ <td>driver name</td>
+ </tr>
+ <tr>
+ <td>default.password</td>
+ <td>********</td>
+ </tr>
+ <tr>
+ <td>default.url</td>
+ <td>jdbc url</td>
+ </tr>
+ <tr>
+ <td>default.user</td>
+ <td>user name</td>
+ </tr>
+</table>
+
+<h3>Multiple connections</h3>
+
+<p>JDBC interpreter also allows connections to multiple data sources. It is
necessary to set a prefix for each connection to reference it in the paragraph
in the form of <code>%jdbc(prefix)</code>. Before you create the interpreter it
is necessary to add each driver's maven coordinates or JDBC driver's
jar file path to the Zeppelin classpath. To do this you must edit the
dependencies of JDBC interpreter in interpreter menu as following:</p>
+
+<div class="row">
+ <div class="col-md-11">
+ <img
src="../assets/themes/zeppelin/img/docs-img/jdbc-multi-connection-setting.png"
/>
+ </div>
+</div>
+
+<p>You can add all the jars you need to make multiple connections into the
same JDBC interpreter. To create the interpreter you must specify the
parameters. For example we will create two connections to MySQL and Redshift,
the respective prefixes are <code>default</code> and <code>redshift</code>:</p>
+
+<table class="table-configuration">
+ <tr>
+ <th>name</th>
+ <th>value</th>
+ </tr>
+ <tr>
+ <td>common.max_count</td>
+ <td>1000</td>
+ </tr>
+ <tr>
+ <td>default.driver</td>
+ <td>com.mysql.jdbc.Driver</td>
+ </tr>
+ <tr>
+ <td>default.password</td>
+ <td>********</td>
+ </tr>
+ <tr>
+ <td>default.url</td>
+ <td>jdbc:mysql://localhost:3306/</td>
+ </tr>
+ <tr>
+ <td>default.user</td>
+ <td>mysql-user</td>
+ </tr>
+ <tr>
+ <td>redshift.driver</td>
+ <td>com.amazon.redshift.jdbc4.Driver</td>
+ </tr>
+ <tr>
+ <td>redshift.password</td>
+ <td>********</td>
+ </tr>
+ <tr>
+ <td>redshift.url</td>
+
<td>jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439</td>
+ </tr>
+ <tr>
+ <td>redshift.user</td>
+ <td>redshift-user</td>
+ </tr>
+</table>
+
+<h2>Bind to Notebook</h2>
+
+<p>In the <code>Notebook</code> click on the <code>settings</code> icon at the
top-right corner. Use select/deselect to specify the interpreters to be used in
the <code>Notebook</code>.</p>
+
+<h2>More Properties</h2>
+
+<p>You can modify the interpreter configuration in the
<code>Interpreter</code> section. The most common properties are as follows,
but you can specify other properties that need to be connected.</p>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Property Name</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>{prefix}.url</td>
+ <td>JDBC URL to connect, the URL must include the name of the database
</td>
+ </tr>
+ <tr>
+ <td>{prefix}.user</td>
+ <td>JDBC user name</td>
+ </tr>
+ <tr>
+ <td>{prefix}.password</td>
+ <td>JDBC password</td>
+ </tr>
+ <tr>
+ <td>{prefix}.driver</td>
+ <td>JDBC driver name.</td>
+ </tr>
+ <tr>
+ <td>common.max_result</td>
+ <td>Max number of SQL result to display to prevent the browser overload.
This is common properties for all connections</td>
+ </tr><br>
+ </table></p>
+
+<p>To develop this functionality use this <a
href="http://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html#getConnection%28java.lang.String,%20java.util.Properties%29";>method</a>.
For example if a connection needs a schema parameter, it would have to add the
property as follows:</p>
+
+<table class="table-configuration">
+ <tr>
+ <th>name</th>
+ <th>value</th>
+ </tr>
+ <tr>
+ <td>{prefix}.schema</td>
+ <td>schema_name</td>
+ </tr>
+</table>
+
+<h2>Examples</h2>
+
+<h3>Hive</h3>
+
+<h4>Properties</h4>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Name</th>
+ <th>Value</th>
+ </tr>
+ <tr>
+ <td>hive.driver</td>
+ <td>org.apache.hive.jdbc.HiveDriver</td>
+ </tr>
+ <tr>
+ <td>hive.url</td>
+ <td>jdbc:hive2://localhost:10000</td>
+ </tr>
+ <tr>
+ <td>hive.user</td>
+ <td>hive<em>user</td>
+ </tr>
+ <tr>
+ <td>hive.password</td>
+ <td>hive</em>password</td>
+ </tr>
+ </table></p>
+
+<h4>Dependencies</h4>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Artifact</th>
+ <th>Excludes</th>
+ </tr>
+ <tr>
+ <td>org.apache.hive:hive-jdbc:0.14.0</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>org.apache.hadoop:hadoop-common:2.6.0</td>
+ <td></td>
+ </tr>
+ </table></p>
+
+<h3>Phoenix</h3>
+
+<h4>Properties</h4>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Name</th>
+ <th>Value</th>
+ </tr>
+ <tr>
+ <td>phoenix.driver</td>
+ <td>org.apache.phoenix.jdbc.PhoenixDriver</td>
+ </tr>
+ <tr>
+ <td>phoenix.url</td>
+ <td>jdbc:phoenix:localhost:2181:/hbase-unsecure</td>
+ </tr>
+ <tr>
+ <td>phoenix.user</td>
+ <td>phoenix<em>user</td>
+ </tr>
+ <tr>
+ <td>phoenix.password</td>
+ <td>phoenix</em>password</td>
+ </tr>
+ </table></p>
+
+<h4>Dependencies</h4>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Artifact</th>
+ <th>Excludes</th>
+ </tr>
+ <tr>
+ <td>org.apache.phoenix:phoenix-core:4.4.0-HBase-1.0</td>
+ <td></td>
+ </tr>
+ </table></p>
+
+<h3>Tajo</h3>
+
+<h4>Properties</h4>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Name</th>
+ <th>Value</th>
+ </tr>
+ <tr>
+ <td>tajo.driver</td>
+ <td>org.apache.tajo.jdbc.TajoDriver</td>
+ </tr>
+ <tr>
+ <td>tajo.url</td>
+ <td>jdbc:tajo://localhost:26002/default</td>
+ </tr>
+ </table></p>
+
+<h4>Dependencies</h4>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Artifact</th>
+ <th>Excludes</th>
+ </tr>
+ <tr>
+ <td>org.apache.tajo:tajo-jdbc:0.11.0</td>
+ <td></td>
+ </tr>
+ </table></p>
+
+<h2>How to use</h2>
+
+<h3>Reference in paragraph</h3>
+
+<p>Start the paragraphs with the <code>%jdbc</code>, this will use the
<code>default</code> prefix for connection. If you want to use other connection
you should specify the prefix of it as follows <code>%jdbc(prefix)</code>:</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">jdbc</span>
+<span class="k">SELECT</span> <span class="o">*</span> <span
class="k">FROM</span> <span class="n">db_name</span><span class="p">;</span>
+</code></pre></div>
+<p>or</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">jdbc</span><span
class="p">(</span><span class="k">prefix</span><span class="p">)</span>
+<span class="k">SELECT</span> <span class="o">*</span> <span
class="k">FROM</span> <span class="n">db_name</span><span class="p">;</span>
+</code></pre></div>
+<h3>Apply Zeppelin Dynamic Forms</h3>
+
+<p>You can leverage <a href="../manual/dynamicform.html">Zeppelin Dynamic
Form</a> inside your queries. You can use both the <code>text input</code> and
<code>select form</code> parametrization features</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">jdbc</span><span
class="p">(</span><span class="k">prefix</span><span class="p">)</span>
+<span class="k">SELECT</span> <span class="n">name</span><span
class="p">,</span> <span class="n">country</span><span class="p">,</span> <span
class="n">performer</span>
+<span class="k">FROM</span> <span class="n">demo</span><span
class="p">.</span><span class="n">performers</span>
+<span class="k">WHERE</span> <span class="n">name</span><span
class="o">=</span><span class="s1">''</span>
+</code></pre></div>
+<h2>Bugs & Reporting</h2>
+
+<p>If you find a bug for this interpreter, please create a <a
href="https://issues.apache.org/jira/browse/ZEPPELIN-382?jql=project%20%3D%20ZEPPELIN";>JIRA</a>
ticket.</p>
+
+ </div>
+</div>
+
+
+ <hr>
+ <footer>
+ <!-- <p>© 2016 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>
+
+
+
+ </body>
+</html>
+
Propchange: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/lens.html
URL:
http://svn.apache.org/viewvc/zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/lens.html?rev=1751605&view=auto
==============================================================================
--- zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/lens.html (added)
+++ zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/lens.html Wed Jul 6 06:25:29
2016
@@ -0,0 +1,328 @@
+
+<!DOCTYPE html>
+<html lang="en">
+ <head>
+ <meta charset="utf-8">
+ <title>Lens Interpreter</title>
+ <meta name="description" content="Lens user guide">
+ <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.7.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/css/bootstrap.css"
rel="stylesheet">
+ <link
href="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/css/style.css?body=1"
rel="stylesheet" type="text/css">
+ <link href="/docs/0.7.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.7.0-SNAPSHOT/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/docs.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script
src="/docs/0.7.0-SNAPSHOT/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.7.0-SNAPSHOT/atom.xml" type="application/atom+xml"
rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.7.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>
+ <a class="navbar-brand" href="/docs/0.7.0-SNAPSHOT">
+ <img src="/assets/themes/zeppelin/img/zeppelin_logo.png"
width="50" alt="I'm zeppelin">
+ <span style="vertical-align:middle">Zeppelin</span>
+ <span
style="vertical-align:baseline"><small>0.7.0-SNAPSHOT</small></span>
+ </a>
+ </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.7.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.7.0-SNAPSHOT/install/install.html">Install</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/quickstart/explorezeppelinui.html">Explore Zeppelin
UI</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/manual/dynamicform.html">Dynamic Form</a></li>
+ <li><a href="/docs/0.7.0-SNAPSHOT/manual/publish.html">Publish
your Paragraph</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/install/virtual_machine.html">Zeppelin on Vagrant
VM</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/install/upgrade.html">Upgrade Zeppelin
Version</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.7.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.7.0-SNAPSHOT/manual/interpreterinstallation.html">Interpreter
Installation</a></li>
+ <!--<li><a
href="/docs/0.7.0-SNAPSHOT/manual/dynamicinterpreterload.html">Dynamic
Interpreter Loading</a></li>-->
+ <li><a
href="/docs/0.7.0-SNAPSHOT/manual/dependencymanagement.html">Interpreter
Dependency Management</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Available
Interpreters</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/flink.html">Flink</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/geode.html">Geode</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hbase.html">HBase</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hdfs.html">HDFS</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/hive.html">Hive</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/ignite.html">Ignite</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html">JDBC</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/lens.html">Lens</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/livy.html">Livy</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/markdown.html">Markdown</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/python.html">Python</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/postgresql.html">Postgresql,
HAWQ</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/r.html">R</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/interpreter/scalding.html">Scalding</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/pleasecontribute.html">Shell</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/displaysystem/back-end-angular.html">Angular
(backend API)</a></li>
+ <li><a
href="/docs/0.7.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.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-local-git-repository">Git
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-s3">S3
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#notebook-storage-in-azure">Azure
Storage</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/storage/storage.html#storage-in-zeppelinhub">ZeppelinHub
Storage</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>REST API</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-interpreter.html">Interpreter
API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-notebook.html">Notebook API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-configuration.html">Configuration
API</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/rest-api/rest-credential.html">Credential
API</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Security</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/authentication.html">Authentication for
NGINX</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/shiroauthentication.html">Shiro
Authentication</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/notebook_authorization.html">Notebook
Authorization</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/security/interpreter_authorization.html">Interpreter
& Data Resource Authorization</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Contibute</b><span></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/writingzeppelininterpreter.html">Writing
Zeppelin Interpreter</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/writingzeppelinapplication.html">Writing
Zeppelin Application</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/howtocontribute.html">How to contribute
(code)</a></li>
+ <li><a
href="/docs/0.7.0-SNAPSHOT/development/howtocontributewebsite.html">How to
contribute (website)</a></li>
+ </ul>
+ </li>
+ </ul>
+ </nav><!--/.navbar-collapse -->
+ </div>
+ </div>
+
+
+ <div class="content">
+
+<!--<div class="hero-unit Lens Interpreter">
+ <h1></h1>
+</div>
+-->
+
+<div class="row">
+ <div class="col-md-12">
+ <h1>Lens Interpreter for Apache Zeppelin</h1>
+
+<div id="toc"></div>
+
+<h2>Overview</h2>
+
+<p><a href="https://lens.apache.org/";>Apache Lens</a> provides an Unified
Analytics interface. Lens aims to cut the Data Analytics silos by providing a
single view of data across multiple tiered data stores and optimal execution
environment for the analytical query. It seamlessly integrates Hadoop with
traditional data warehouses to appear like one.</p>
+
+<p><img src="../assets/themes/zeppelin/img/docs-img/lens-logo.png" alt="Apache
Lens"></p>
+
+<h2>Installing and Running Lens</h2>
+
+<p>In order to use Lens interpreters, you may install Apache Lens in some
simple steps:</p>
+
+<ol>
+<li>Download Lens for latest version from <a
href="http://www.apache.org/dyn/closer.lua/lens/2.3-beta";>the ASF</a>. Or the
older release can be found <a href="http://archive.apache.org/dist/lens/";>in
the Archives</a>.</li>
+<li>Before running Lens, you have to set HIVE<em>HOME and HADOOP</em>HOME. If
you want to get more information about this, please refer to <a
href="http://lens.apache.org/lenshome/install-and-run.html#Installation";>here</a>.
Lens also provides Pseudo Distributed mode. <a
href="http://lens.apache.org/lenshome/pseudo-distributed-setup.html";>Lens
pseudo-distributed setup</a> is done by using <a
href="https://www.docker.com/";>docker</a>. Hive server and hadoop daemons are
run as separate processes in lens pseudo-distributed setup.</li>
+<li>Now, you can start lens server (or stop).</li>
+</ol>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">./bin/lens-ctl start (or stop)
+</code></pre></div>
+<h2>Configuring Lens Interpreter</h2>
+
+<p>At the "Interpreters" menu, you can edit Lens interpreter or
create new one. Zeppelin provides these properties for Lens.</p>
+
+<table class="table-configuration">
+ <tr>
+ <th>Property Name</th>
+ <th>value</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>lens.client.dbname</td>
+ <td>default</td>
+ <td>The database schema name</td>
+ </tr>
+ <tr>
+ <td>lens.query.enable.persistent.resultset</td>
+ <td>false</td>
+ <td>Whether to enable persistent resultset for queries. When enabled,
server will fetch results from driver, custom format them if any and store in a
configured location. The file name of query output is queryhandle-id, with
configured extensions</td>
+ </tr>
+ <tr>
+ <td>lens.server.base.url</td>
+ <td>http://hostname:port/lensapi</td>
+ <td>The base url for the lens server. you have to edit "hostname" and
"port" that you may use(ex. http://0.0.0.0:9999/lensapi)</td>
+ </tr>
+ <tr>
+ <td>lens.session.cluster.user </td>
+ <td>default</td>
+ <td>Hadoop cluster username</td>
+ </tr>
+ <tr>
+ <td>zeppelin.lens.maxResult</td>
+ <td>1000</td>
+ <td>Max number of rows to display</td>
+ </tr>
+ <tr>
+ <td>zeppelin.lens.maxThreads</td>
+ <td>10</td>
+ <td>If concurrency is true then how many threads?</td>
+ </tr>
+ <tr>
+ <td>zeppelin.lens.run.concurrent</td>
+ <td>true</td>
+ <td>Run concurrent Lens Sessions</td>
+ </tr>
+ <tr>
+ <td>xxx</td>
+ <td>yyy</td>
+ <td>anything else from [Configuring lens
server](https://lens.apache.org/admin/config-server.html)</td>
+ </tr>
+</table>
+
+<p><img
src="../assets/themes/zeppelin/img/docs-img/lens-interpreter-setting.png"
alt="Apache Lens Interpreter Setting"></p>
+
+<h3>Interpreter Binding for Zeppelin Notebook</h3>
+
+<p>After configuring Lens interpreter, create your own notebook, then you can
bind interpreters like below image.</p>
+
+<p><img
src="../assets/themes/zeppelin/img/docs-img/lens-interpreter-binding.png"
alt="Zeppelin Notebook Interpreter Binding"></p>
+
+<p>For more interpreter binding information see <a
href="http://zeppelin.apache.org/docs/manual/interpreters.html";>here</a>.</p>
+
+<h3>How to use</h3>
+
+<p>You can analyze your data by using <a
href="http://lens.apache.org/user/olap-cube.html";>OLAP Cube</a> <a
href="http://lens.apache.org/user/cli.html";>QL</a> which is a high level SQL
like language to query and describe data sets organized in data cubes.
+You may experience OLAP Cube like this <a
href="https://cwiki.apache.org/confluence/display/LENS/2015/07/13/20+Minute+video+demo+of+Apache+Lens+through+examples";>Video
tutorial</a>.
+As you can see in this video, they are using Lens Client
Shell(./bin/lens-cli.sh). All of these functions also can be used on Zeppelin
by using Lens interpreter.</p>
+
+<p><li> Create and Use(Switch) Databases.</p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">create database newDb
+</code></pre></div><div class="highlight"><pre><code class="text
language-text" data-lang="text">use newDb
+</code></pre></div>
+<p><li> Create Storage.</p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">create storage
your/path/to/lens/client/examples/resources/db-storage.xml
+</code></pre></div>
+<p><li> Create Dimensions, Show fields and join-chains of them.</p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">create dimension
your/path/to/lens/client/examples/resources/customer.xml
+</code></pre></div><div class="highlight"><pre><code class="text
language-text" data-lang="text">dimension show fields customer
+</code></pre></div><div class="highlight"><pre><code class="text
language-text" data-lang="text">dimension show joinchains customer
+</code></pre></div>
+<p><li> Create Caches, Show fields and join-chains of them.</p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">create cube
your/path/to/lens/client/examples/resources/sales-cube.xml
+</code></pre></div><div class="highlight"><pre><code class="text
language-text" data-lang="text">cube show fields sales
+</code></pre></div><div class="highlight"><pre><code class="text
language-text" data-lang="text">cube show joinchains sales
+</code></pre></div>
+<p><li> Create Dimtables and Fact.</p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">create dimtable
your/path/to/lens/client/examples/resources/customer_table.xml
+</code></pre></div><div class="highlight"><pre><code class="text
language-text" data-lang="text">create fact
your/path/to/lens/client/examples/resources/sales-raw-fact.xml
+</code></pre></div>
+<p><li> Add partitions to Dimtable and Fact.</p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">dimtable add single-partition --dimtable_name customer_table
--storage_name local --path
your/path/to/lens/client/examples/resources/customer-local-part.xml
+</code></pre></div><div class="highlight"><pre><code class="text
language-text" data-lang="text">fact add partitions --fact_name sales_raw_fact
--storage_name local --path
your/path/to/lens/client/examples/resources/sales-raw-local-parts.xml
+</code></pre></div>
+<p><li> Now, you can run queries on cubes.</p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">query execute cube select customer_city_name,
product_details.description, product_details.category, product_details.color,
store_sales from sales where time_range_in(delivery_time,
'2015-04-11-00', '2015-04-13-00')
+</code></pre></div>
+<p><img src="../assets/themes/zeppelin/img/docs-img/lens-result.png" alt="Lens
Query Result"></p>
+
+<p>These are just examples that provided in advance by Lens. If you want to
explore whole tutorials of Lens, see the <a
href="https://cwiki.apache.org/confluence/display/LENS/2015/07/13/20+Minute+video+demo+of+Apache+Lens+through+examples";>tutorial
video</a>.</p>
+
+<h2>Lens UI Service</h2>
+
+<p>Lens also provides web UI service. Once the server starts up, you can open
the service on http://serverhost:19999/index.html and browse. You may also
check the structure that you made and use query easily here.</p>
+
+<p><img src="../assets/themes/zeppelin/img/docs-img/lens-ui-service.png"
alt="Lens UI Service"></p>
+
+ </div>
+</div>
+
+
+ <hr>
+ <footer>
+ <!-- <p>© 2016 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>
+
+
+
+ </body>
+</html>
+
Propchange: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/lens.html
------------------------------------------------------------------------------
svn:eol-style = native
