You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@zeppelin.apache.org by mi...@apache.org on 2016/10/17 04:13:37 UTC
svn commit: r1765205 [12/21] - in /zeppelin/site: ./ contribution/
contribution/zeppelinweb/ docs/0.6.2/ docs/0.6.2/assets/
docs/0.6.2/assets/themes/ docs/0.6.2/assets/themes/zeppelin/
docs/0.6.2/assets/themes/zeppelin/bootstrap/ docs/0.6.2/assets/them...
Added: zeppelin/site/docs/0.6.2/interpreter/hive.html
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.6.2/interpreter/hive.html?rev=1765205&view=auto
==============================================================================
--- zeppelin/site/docs/0.6.2/interpreter/hive.html (added)
+++ zeppelin/site/docs/0.6.2/interpreter/hive.html Mon Oct 17 04:13:33 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.6.2/assets/themes/zeppelin/bootstrap/css/bootstrap.css" rel="stylesheet">
+ <link href="/docs/0.6.2/assets/themes/zeppelin/css/style.css?body=1" rel="stylesheet" type="text/css">
+ <link href="/docs/0.6.2/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.6.2/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/docs.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.6.2/atom.xml" type="application/atom+xml" rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.6.2/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.6.2">
+ <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.6.2</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.6.2/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.6.2/install/install.html">Install</a></li>
+ <li><a href="/docs/0.6.2/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a href="/docs/0.6.2/quickstart/explorezeppelinui.html">Explore Zeppelin UI</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/manual/dynamicform.html">Dynamic Form</a></li>
+ <li><a href="/docs/0.6.2/manual/publish.html">Publish your Paragraph</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/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.6.2/manual/interpreterinstallation.html">Interpreter Installation</a></li>
+ <!--<li><a href="/docs/0.6.2/manual/dynamicinterpreterload.html">Dynamic Interpreter Loading</a></li>-->
+ <li><a href="/docs/0.6.2/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.6.2/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a href="/docs/0.6.2/interpreter/bigquery.html">BigQuery</a></li>
+ <li><a href="/docs/0.6.2/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a href="/docs/0.6.2/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a href="/docs/0.6.2/interpreter/flink.html">Flink</a></li>
+ <li><a href="/docs/0.6.2/interpreter/geode.html">Geode</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hbase.html">HBase</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hdfs.html">HDFS</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hive.html">Hive</a></li>
+ <li><a href="/docs/0.6.2/interpreter/ignite.html">Ignite</a></li>
+ <li><a href="/docs/0.6.2/interpreter/jdbc.html">JDBC</a></li>
+ <li><a href="/docs/0.6.2/interpreter/lens.html">Lens</a></li>
+ <li><a href="/docs/0.6.2/interpreter/livy.html">Livy</a></li>
+ <li><a href="/docs/0.6.2/interpreter/markdown.html">Markdown</a></li>
+ <li><a href="/docs/0.6.2/interpreter/python.html">Python</a></li>
+ <li><a href="/docs/0.6.2/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+ <li><a href="/docs/0.6.2/interpreter/r.html">R</a></li>
+ <li><a href="/docs/0.6.2/interpreter/scalding.html">Scalding</a></li>
+ <li><a href="/docs/0.6.2/pleasecontribute.html">Shell</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a href="/docs/0.6.2/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/displaysystem/back-end-angular.html">Angular (backend API)</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/storage/storage.html#notebook-storage-in-local-git-repository">Git Storage</a></li>
+ <li><a href="/docs/0.6.2/storage/storage.html#notebook-storage-in-s3">S3 Storage</a></li>
+ <li><a href="/docs/0.6.2/storage/storage.html#notebook-storage-in-azure">Azure Storage</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/rest-api/rest-interpreter.html">Interpreter API</a></li>
+ <li><a href="/docs/0.6.2/rest-api/rest-notebook.html">Notebook API</a></li>
+ <li><a href="/docs/0.6.2/rest-api/rest-configuration.html">Configuration API</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Security</b><span></li>
+ <li><a href="/docs/0.6.2/security/authentication.html">Authentication for NGINX</a></li>
+ <li><a href="/docs/0.6.2/security/shiroauthentication.html">Shiro Authentication</a></li>
+ <li><a href="/docs/0.6.2/security/notebook_authorization.html">Notebook Authorization</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/development/writingzeppelininterpreter.html">Writing Zeppelin Interpreter</a></li>
+ <li><a href="/docs/0.6.2/development/howtocontribute.html">How to contribute (code)</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/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.6.2/interpreter/hive.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.6.2/interpreter/ignite.html
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.6.2/interpreter/ignite.html?rev=1765205&view=auto
==============================================================================
--- zeppelin/site/docs/0.6.2/interpreter/ignite.html (added)
+++ zeppelin/site/docs/0.6.2/interpreter/ignite.html Mon Oct 17 04:13:33 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.6.2/assets/themes/zeppelin/bootstrap/css/bootstrap.css" rel="stylesheet">
+ <link href="/docs/0.6.2/assets/themes/zeppelin/css/style.css?body=1" rel="stylesheet" type="text/css">
+ <link href="/docs/0.6.2/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.6.2/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/docs.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.6.2/atom.xml" type="application/atom+xml" rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.6.2/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.6.2">
+ <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.6.2</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.6.2/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.6.2/install/install.html">Install</a></li>
+ <li><a href="/docs/0.6.2/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a href="/docs/0.6.2/quickstart/explorezeppelinui.html">Explore Zeppelin UI</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/manual/dynamicform.html">Dynamic Form</a></li>
+ <li><a href="/docs/0.6.2/manual/publish.html">Publish your Paragraph</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/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.6.2/manual/interpreterinstallation.html">Interpreter Installation</a></li>
+ <!--<li><a href="/docs/0.6.2/manual/dynamicinterpreterload.html">Dynamic Interpreter Loading</a></li>-->
+ <li><a href="/docs/0.6.2/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.6.2/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a href="/docs/0.6.2/interpreter/bigquery.html">BigQuery</a></li>
+ <li><a href="/docs/0.6.2/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a href="/docs/0.6.2/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a href="/docs/0.6.2/interpreter/flink.html">Flink</a></li>
+ <li><a href="/docs/0.6.2/interpreter/geode.html">Geode</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hbase.html">HBase</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hdfs.html">HDFS</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hive.html">Hive</a></li>
+ <li><a href="/docs/0.6.2/interpreter/ignite.html">Ignite</a></li>
+ <li><a href="/docs/0.6.2/interpreter/jdbc.html">JDBC</a></li>
+ <li><a href="/docs/0.6.2/interpreter/lens.html">Lens</a></li>
+ <li><a href="/docs/0.6.2/interpreter/livy.html">Livy</a></li>
+ <li><a href="/docs/0.6.2/interpreter/markdown.html">Markdown</a></li>
+ <li><a href="/docs/0.6.2/interpreter/python.html">Python</a></li>
+ <li><a href="/docs/0.6.2/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+ <li><a href="/docs/0.6.2/interpreter/r.html">R</a></li>
+ <li><a href="/docs/0.6.2/interpreter/scalding.html">Scalding</a></li>
+ <li><a href="/docs/0.6.2/pleasecontribute.html">Shell</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a href="/docs/0.6.2/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/displaysystem/back-end-angular.html">Angular (backend API)</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/storage/storage.html#notebook-storage-in-local-git-repository">Git Storage</a></li>
+ <li><a href="/docs/0.6.2/storage/storage.html#notebook-storage-in-s3">S3 Storage</a></li>
+ <li><a href="/docs/0.6.2/storage/storage.html#notebook-storage-in-azure">Azure Storage</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/rest-api/rest-interpreter.html">Interpreter API</a></li>
+ <li><a href="/docs/0.6.2/rest-api/rest-notebook.html">Notebook API</a></li>
+ <li><a href="/docs/0.6.2/rest-api/rest-configuration.html">Configuration API</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Security</b><span></li>
+ <li><a href="/docs/0.6.2/security/authentication.html">Authentication for NGINX</a></li>
+ <li><a href="/docs/0.6.2/security/shiroauthentication.html">Shiro Authentication</a></li>
+ <li><a href="/docs/0.6.2/security/notebook_authorization.html">Notebook Authorization</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/development/writingzeppelininterpreter.html">Writing Zeppelin Interpreter</a></li>
+ <li><a href="/docs/0.6.2/development/howtocontribute.html">How to contribute (code)</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/interpreter/ignite.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.6.2/interpreter/jdbc.html
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.6.2/interpreter/jdbc.html?rev=1765205&view=auto
==============================================================================
--- zeppelin/site/docs/0.6.2/interpreter/jdbc.html (added)
+++ zeppelin/site/docs/0.6.2/interpreter/jdbc.html Mon Oct 17 04:13:33 2016
@@ -0,0 +1,577 @@
+
+<!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.6.2/assets/themes/zeppelin/bootstrap/css/bootstrap.css" rel="stylesheet">
+ <link href="/docs/0.6.2/assets/themes/zeppelin/css/style.css?body=1" rel="stylesheet" type="text/css">
+ <link href="/docs/0.6.2/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.6.2/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/docs.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.6.2/atom.xml" type="application/atom+xml" rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.6.2/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.6.2">
+ <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.6.2</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.6.2/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.6.2/install/install.html">Install</a></li>
+ <li><a href="/docs/0.6.2/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a href="/docs/0.6.2/quickstart/explorezeppelinui.html">Explore Zeppelin UI</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/manual/dynamicform.html">Dynamic Form</a></li>
+ <li><a href="/docs/0.6.2/manual/publish.html">Publish your Paragraph</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/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.6.2/manual/interpreterinstallation.html">Interpreter Installation</a></li>
+ <!--<li><a href="/docs/0.6.2/manual/dynamicinterpreterload.html">Dynamic Interpreter Loading</a></li>-->
+ <li><a href="/docs/0.6.2/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.6.2/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a href="/docs/0.6.2/interpreter/bigquery.html">BigQuery</a></li>
+ <li><a href="/docs/0.6.2/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a href="/docs/0.6.2/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a href="/docs/0.6.2/interpreter/flink.html">Flink</a></li>
+ <li><a href="/docs/0.6.2/interpreter/geode.html">Geode</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hbase.html">HBase</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hdfs.html">HDFS</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hive.html">Hive</a></li>
+ <li><a href="/docs/0.6.2/interpreter/ignite.html">Ignite</a></li>
+ <li><a href="/docs/0.6.2/interpreter/jdbc.html">JDBC</a></li>
+ <li><a href="/docs/0.6.2/interpreter/lens.html">Lens</a></li>
+ <li><a href="/docs/0.6.2/interpreter/livy.html">Livy</a></li>
+ <li><a href="/docs/0.6.2/interpreter/markdown.html">Markdown</a></li>
+ <li><a href="/docs/0.6.2/interpreter/python.html">Python</a></li>
+ <li><a href="/docs/0.6.2/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+ <li><a href="/docs/0.6.2/interpreter/r.html">R</a></li>
+ <li><a href="/docs/0.6.2/interpreter/scalding.html">Scalding</a></li>
+ <li><a href="/docs/0.6.2/pleasecontribute.html">Shell</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a href="/docs/0.6.2/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/displaysystem/back-end-angular.html">Angular (backend API)</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/storage/storage.html#notebook-storage-in-local-git-repository">Git Storage</a></li>
+ <li><a href="/docs/0.6.2/storage/storage.html#notebook-storage-in-s3">S3 Storage</a></li>
+ <li><a href="/docs/0.6.2/storage/storage.html#notebook-storage-in-azure">Azure Storage</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/rest-api/rest-interpreter.html">Interpreter API</a></li>
+ <li><a href="/docs/0.6.2/rest-api/rest-notebook.html">Notebook API</a></li>
+ <li><a href="/docs/0.6.2/rest-api/rest-configuration.html">Configuration API</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Security</b><span></li>
+ <li><a href="/docs/0.6.2/security/authentication.html">Authentication for NGINX</a></li>
+ <li><a href="/docs/0.6.2/security/shiroauthentication.html">Shiro Authentication</a></li>
+ <li><a href="/docs/0.6.2/security/notebook_authorization.html">Notebook Authorization</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/development/writingzeppelininterpreter.html">Writing Zeppelin Interpreter</a></li>
+ <li><a href="/docs/0.6.2/development/howtocontribute.html">How to contribute (code)</a></li>
+ <li><a href="/docs/0.6.2/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 <a href="https://drill.apache.org/docs/using-the-jdbc-driver">Drill JDBC Driver</a>)</li>
+<li>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>
+
+<p>Phoenix supports <code>thick</code> and <code>thin</code> connection types:</p>
+
+<ul>
+<li>Thick client is faster, but must connect directly to ZooKeeper and HBase RegionServers.</li>
+<li>Thin client has fewer dependencies and connects through a <a href="http://phoenix.apache.org/server.html">Phoenix Query Server</a> instance.</li>
+</ul>
+
+<p>Use the appropriate <code>phoenix.driver</code> and <code>phoenix.url</code> for your connection type.</p>
+
+<h4>Properties:</h4>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Name</th>
+ <th>Value</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>phoenix.driver</td>
+ <td>org.apache.phoenix.jdbc.PhoenixDriver</td>
+ <td>'Thick Client', connects directly to Phoenix</td>
+ </tr>
+ <tr>
+ <td>phoenix.driver</td>
+ <td>org.apache.phoenix.queryserver.client.Driver</td>
+ <td>'Thin Client', connects via Phoenix Query Server</td>
+ </tr>
+ <tr>
+ <td>phoenix.url</td>
+ <td>jdbc:phoenix:localhost:2181:/hbase-unsecure</td>
+ <td>'Thick Client', connects directly to Phoenix</td>
+ </tr>
+ <tr>
+ <td>phoenix.url</td>
+ <td>jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF</td>
+ <td>'Thin Client', connects via Phoenix Query Server</td>
+ </tr>
+ <tr>
+ <td>phoenix.user</td>
+ <td>phoenix<em>user</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>phoenix.password</td>
+ <td>phoenix</em>password</td>
+ <td></td>
+ </tr>
+ </table></p>
+
+<h4>Dependencies:</h4>
+
+<p>Include the dependency for your connection type (it should be only <em>one</em> of the following).</p>
+
+<p><table class="table-configuration">
+ <tr>
+ <th>Artifact</th>
+ <th>Excludes</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>org.apache.phoenix:phoenix-core:4.4.0-HBase-1.0</td>
+ <td></td>
+ <td>'Thick Client', connects directly to Phoenix</td>
+ </tr>
+ <tr>
+ <td>org.apache.phoenix:phoenix-server-client:4.7.0-HBase-1.1</td>
+ <td></td>
+ <td>'Thin Client' for Phoenix 4.7, connects via Phoenix Query Server</td>
+ </tr>
+ <tr>
+ <td>org.apache.phoenix:phoenix-queryserver-client:4.8.0-HBase-1.2</td>
+ <td></td>
+ <td>'Thin Client' for Phoenix 4.8+, connects via Phoenix Query Server</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.6.2/interpreter/jdbc.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.6.2/interpreter/lens.html
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.6.2/interpreter/lens.html?rev=1765205&view=auto
==============================================================================
--- zeppelin/site/docs/0.6.2/interpreter/lens.html (added)
+++ zeppelin/site/docs/0.6.2/interpreter/lens.html Mon Oct 17 04:13:33 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.6.2/assets/themes/zeppelin/bootstrap/css/bootstrap.css" rel="stylesheet">
+ <link href="/docs/0.6.2/assets/themes/zeppelin/css/style.css?body=1" rel="stylesheet" type="text/css">
+ <link href="/docs/0.6.2/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.6.2/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/docs.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script src="/docs/0.6.2/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.6.2/atom.xml" type="application/atom+xml" rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.6.2/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.6.2">
+ <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.6.2</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.6.2/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.6.2/install/install.html">Install</a></li>
+ <li><a href="/docs/0.6.2/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a href="/docs/0.6.2/quickstart/explorezeppelinui.html">Explore Zeppelin UI</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/manual/dynamicform.html">Dynamic Form</a></li>
+ <li><a href="/docs/0.6.2/manual/publish.html">Publish your Paragraph</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/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.6.2/manual/interpreterinstallation.html">Interpreter Installation</a></li>
+ <!--<li><a href="/docs/0.6.2/manual/dynamicinterpreterload.html">Dynamic Interpreter Loading</a></li>-->
+ <li><a href="/docs/0.6.2/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.6.2/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a href="/docs/0.6.2/interpreter/bigquery.html">BigQuery</a></li>
+ <li><a href="/docs/0.6.2/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a href="/docs/0.6.2/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a href="/docs/0.6.2/interpreter/flink.html">Flink</a></li>
+ <li><a href="/docs/0.6.2/interpreter/geode.html">Geode</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hbase.html">HBase</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hdfs.html">HDFS</a></li>
+ <li><a href="/docs/0.6.2/interpreter/hive.html">Hive</a></li>
+ <li><a href="/docs/0.6.2/interpreter/ignite.html">Ignite</a></li>
+ <li><a href="/docs/0.6.2/interpreter/jdbc.html">JDBC</a></li>
+ <li><a href="/docs/0.6.2/interpreter/lens.html">Lens</a></li>
+ <li><a href="/docs/0.6.2/interpreter/livy.html">Livy</a></li>
+ <li><a href="/docs/0.6.2/interpreter/markdown.html">Markdown</a></li>
+ <li><a href="/docs/0.6.2/interpreter/python.html">Python</a></li>
+ <li><a href="/docs/0.6.2/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+ <li><a href="/docs/0.6.2/interpreter/r.html">R</a></li>
+ <li><a href="/docs/0.6.2/interpreter/scalding.html">Scalding</a></li>
+ <li><a href="/docs/0.6.2/pleasecontribute.html">Shell</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a href="/docs/0.6.2/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/displaysystem/back-end-angular.html">Angular (backend API)</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/storage/storage.html#notebook-storage-in-local-git-repository">Git Storage</a></li>
+ <li><a href="/docs/0.6.2/storage/storage.html#notebook-storage-in-s3">S3 Storage</a></li>
+ <li><a href="/docs/0.6.2/storage/storage.html#notebook-storage-in-azure">Azure Storage</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/rest-api/rest-interpreter.html">Interpreter API</a></li>
+ <li><a href="/docs/0.6.2/rest-api/rest-notebook.html">Notebook API</a></li>
+ <li><a href="/docs/0.6.2/rest-api/rest-configuration.html">Configuration API</a></li>
+ <li role="separator" class="divider"></li>
+ <li class="title"><span><b>Security</b><span></li>
+ <li><a href="/docs/0.6.2/security/authentication.html">Authentication for NGINX</a></li>
+ <li><a href="/docs/0.6.2/security/shiroauthentication.html">Shiro Authentication</a></li>
+ <li><a href="/docs/0.6.2/security/notebook_authorization.html">Notebook Authorization</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/development/writingzeppelininterpreter.html">Writing Zeppelin Interpreter</a></li>
+ <li><a href="/docs/0.6.2/development/howtocontribute.html">How to contribute (code)</a></li>
+ <li><a href="/docs/0.6.2/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.6.2/interpreter/lens.html
------------------------------------------------------------------------------
svn:eol-style = native