Added: zeppelin/site/docs/0.6.0/interpreter/lens.html
URL:
http://svn.apache.org/viewvc/zeppelin/site/docs/0.6.0/interpreter/lens.html?rev=1751605&view=auto
==============================================================================
--- zeppelin/site/docs/0.6.0/interpreter/lens.html (added)
+++ zeppelin/site/docs/0.6.0/interpreter/lens.html Wed Jul 6 06:25:29 2016
@@ -0,0 +1,326 @@
+
+<!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.0/assets/themes/zeppelin/bootstrap/css/bootstrap.css"
rel="stylesheet">
+ <link href="/docs/0.6.0/assets/themes/zeppelin/css/style.css?body=1"
rel="stylesheet" type="text/css">
+ <link href="/docs/0.6.0/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.0/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/docs.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.6.0/atom.xml" type="application/atom+xml"
rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.6.0/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.0">
+ <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.0</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.0/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.0/install/install.html">Install</a></li>
+ <li><a
href="/docs/0.6.0/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a
href="/docs/0.6.0/quickstart/explorezeppelinui.html">Explore Zeppelin
UI</a></li>
+ <li><a
href="/docs/0.6.0/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.0/manual/dynamicform.html">Dynamic
Form</a></li>
+ <li><a href="/docs/0.6.0/manual/publish.html">Publish your
Paragraph</a></li>
+ <li><a
href="/docs/0.6.0/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.0/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+ <li><a href="/docs/0.6.0/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.0/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.0/manual/interpreterinstallation.html">Interpreter
Installation</a></li>
+ <!--<li><a
href="/docs/0.6.0/manual/dynamicinterpreterload.html">Dynamic Interpreter
Loading</a></li>-->
+ <li><a
href="/docs/0.6.0/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.0/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a href="/docs/0.6.0/interpreter/flink.html">Flink</a></li>
+ <li><a href="/docs/0.6.0/interpreter/geode.html">Geode</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hbase.html">HBase</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hdfs.html">HDFS</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hive.html">Hive</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/ignite.html">Ignite</a></li>
+ <li><a href="/docs/0.6.0/interpreter/jdbc.html">JDBC</a></li>
+ <li><a href="/docs/0.6.0/interpreter/lens.html">Lens</a></li>
+ <li><a href="/docs/0.6.0/interpreter/livy.html">Livy</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/markdown.html">Markdown</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/python.html">Python</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+ <li><a href="/docs/0.6.0/interpreter/r.html">R</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/scalding.html">Scalding</a></li>
+ <li><a href="/docs/0.6.0/pleasecontribute.html">Shell</a></li>
+ <li><a href="/docs/0.6.0/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.0/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a
href="/docs/0.6.0/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a
href="/docs/0.6.0/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.0/displaysystem/back-end-angular.html">Angular (backend
API)</a></li>
+ <li><a
href="/docs/0.6.0/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.0/storage/storage.html#notebook-storage-in-local-git-repository">Git
Storage</a></li>
+ <li><a
href="/docs/0.6.0/storage/storage.html#notebook-storage-in-s3">S3
Storage</a></li>
+ <li><a
href="/docs/0.6.0/storage/storage.html#notebook-storage-in-azure">Azure
Storage</a></li>
+ <li><a
href="/docs/0.6.0/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.0/rest-api/rest-interpreter.html">Interpreter API</a></li>
+ <li><a href="/docs/0.6.0/rest-api/rest-notebook.html">Notebook
API</a></li>
+ <li><a
href="/docs/0.6.0/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.0/security/authentication.html">Authentication for
NGINX</a></li>
+ <li><a
href="/docs/0.6.0/security/shiroauthentication.html">Shiro
Authentication</a></li>
+ <li><a
href="/docs/0.6.0/security/notebook_authorization.html">Notebook
Authorization</a></li>
+ <li><a
href="/docs/0.6.0/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.0/development/writingzeppelininterpreter.html">Writing Zeppelin
Interpreter</a></li>
+ <li><a href="/docs/0.6.0/development/howtocontribute.html">How
to contribute (code)</a></li>
+ <li><a
href="/docs/0.6.0/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.0/interpreter/lens.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.6.0/interpreter/livy.html
URL:
http://svn.apache.org/viewvc/zeppelin/site/docs/0.6.0/interpreter/livy.html?rev=1751605&view=auto
==============================================================================
--- zeppelin/site/docs/0.6.0/interpreter/livy.html (added)
+++ zeppelin/site/docs/0.6.0/interpreter/livy.html Wed Jul 6 06:25:29 2016
@@ -0,0 +1,359 @@
+
+<!DOCTYPE html>
+<html lang="en">
+ <head>
+ <meta charset="utf-8">
+ <title>Livy 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.0/assets/themes/zeppelin/bootstrap/css/bootstrap.css"
rel="stylesheet">
+ <link href="/docs/0.6.0/assets/themes/zeppelin/css/style.css?body=1"
rel="stylesheet" type="text/css">
+ <link href="/docs/0.6.0/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.0/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/docs.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.6.0/atom.xml" type="application/atom+xml"
rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.6.0/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.0">
+ <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.0</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.0/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.0/install/install.html">Install</a></li>
+ <li><a
href="/docs/0.6.0/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a
href="/docs/0.6.0/quickstart/explorezeppelinui.html">Explore Zeppelin
UI</a></li>
+ <li><a
href="/docs/0.6.0/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.0/manual/dynamicform.html">Dynamic
Form</a></li>
+ <li><a href="/docs/0.6.0/manual/publish.html">Publish your
Paragraph</a></li>
+ <li><a
href="/docs/0.6.0/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.0/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+ <li><a href="/docs/0.6.0/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.0/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.0/manual/interpreterinstallation.html">Interpreter
Installation</a></li>
+ <!--<li><a
href="/docs/0.6.0/manual/dynamicinterpreterload.html">Dynamic Interpreter
Loading</a></li>-->
+ <li><a
href="/docs/0.6.0/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.0/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a href="/docs/0.6.0/interpreter/flink.html">Flink</a></li>
+ <li><a href="/docs/0.6.0/interpreter/geode.html">Geode</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hbase.html">HBase</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hdfs.html">HDFS</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hive.html">Hive</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/ignite.html">Ignite</a></li>
+ <li><a href="/docs/0.6.0/interpreter/jdbc.html">JDBC</a></li>
+ <li><a href="/docs/0.6.0/interpreter/lens.html">Lens</a></li>
+ <li><a href="/docs/0.6.0/interpreter/livy.html">Livy</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/markdown.html">Markdown</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/python.html">Python</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+ <li><a href="/docs/0.6.0/interpreter/r.html">R</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/scalding.html">Scalding</a></li>
+ <li><a href="/docs/0.6.0/pleasecontribute.html">Shell</a></li>
+ <li><a href="/docs/0.6.0/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.0/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a
href="/docs/0.6.0/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a
href="/docs/0.6.0/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.0/displaysystem/back-end-angular.html">Angular (backend
API)</a></li>
+ <li><a
href="/docs/0.6.0/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.0/storage/storage.html#notebook-storage-in-local-git-repository">Git
Storage</a></li>
+ <li><a
href="/docs/0.6.0/storage/storage.html#notebook-storage-in-s3">S3
Storage</a></li>
+ <li><a
href="/docs/0.6.0/storage/storage.html#notebook-storage-in-azure">Azure
Storage</a></li>
+ <li><a
href="/docs/0.6.0/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.0/rest-api/rest-interpreter.html">Interpreter API</a></li>
+ <li><a href="/docs/0.6.0/rest-api/rest-notebook.html">Notebook
API</a></li>
+ <li><a
href="/docs/0.6.0/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.0/security/authentication.html">Authentication for
NGINX</a></li>
+ <li><a
href="/docs/0.6.0/security/shiroauthentication.html">Shiro
Authentication</a></li>
+ <li><a
href="/docs/0.6.0/security/notebook_authorization.html">Notebook
Authorization</a></li>
+ <li><a
href="/docs/0.6.0/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.0/development/writingzeppelininterpreter.html">Writing Zeppelin
Interpreter</a></li>
+ <li><a href="/docs/0.6.0/development/howtocontribute.html">How
to contribute (code)</a></li>
+ <li><a
href="/docs/0.6.0/development/howtocontributewebsite.html">How to contribute
(website)</a></li>
+ </ul>
+ </li>
+ </ul>
+ </nav><!--/.navbar-collapse -->
+ </div>
+ </div>
+
+
+ <div class="content">
+
+<!--<div class="hero-unit Livy Interpreter">
+ <h1></h1>
+</div>
+-->
+
+<div class="row">
+ <div class="col-md-12">
+ <h1>Livy Interpreter for Apache Zeppelin</h1>
+
+<div id="toc"></div>
+
+<h2>Overview</h2>
+
+<p><a href="http://livy.io/";>Livy</a> is an open source REST interface for
interacting with Spark from anywhere. It supports executing snippets of code or
programs in a Spark context that runs locally or in YARN.</p>
+
+<ul>
+<li>Interactive Scala, Python and R shells</li>
+<li>Batch submissions in Scala, Java, Python</li>
+<li>Multi users can share the same server (impersonation support)</li>
+<li>Can be used for submitting jobs from anywhere with REST</li>
+<li>Does not require any code change to your programs</li>
+</ul>
+
+<h3>Requirements</h3>
+
+<p>Additional requirements for the Livy interpreter are:</p>
+
+<ul>
+<li>Spark 1.3 or above.</li>
+<li>Livy server.</li>
+</ul>
+
+<h2>Configuration</h2>
+
+<p>We added some common configurations for spark, and you can set any
configuration you want.
+This link contains all spark configurations:
http://spark.apache.org/docs/latest/configuration.html#available-properties.
+And instead of starting property with <code>spark.</code> it should be
replaced with <code>livy.spark.</code>.
+Example: <code>spark.master</code> to <code>livy.spark.master</code></p>
+
+<table class="table-configuration">
+ <tr>
+ <th>Property</th>
+ <th>Default</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>livy.spark.master</td>
+ <td>local[*]</td>
+ <td>Spark master uri. ex) spark://masterhost:7077</td>
+ </tr>
+ <tr>
+ <td>zeppelin.livy.url</td>
+ <td>http://localhost:8998</td>
+ <td>URL where livy server is running</td>
+ </tr>
+ <tr>
+ <td>zeppelin.livy.spark.maxResult</td>
+ <td>1000</td>
+ <td>Max number of SparkSQL result to display.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.driver.cores</td>
+ <td></td>
+ <td>Driver cores. ex) 1, 2.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.driver.memory</td>
+ <td></td>
+ <td>Driver memory. ex) 512m, 32g.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.executor.instances</td>
+ <td></td>
+ <td>Executor instances. ex) 1, 4.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.executor.cores</td>
+ <td></td>
+ <td>Num cores per executor. ex) 1, 4.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.executor.memory</td>
+ <td></td>
+ <td>Executor memory per worker instance. ex) 512m, 32g.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.dynamicAllocation.enabled</td>
+ <td></td>
+ <td>Use dynamic resource allocation. ex) True, False.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.dynamicAllocation.cachedExecutorIdleTimeout</td>
+ <td></td>
+ <td>Remove an executor which has cached data blocks.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.dynamicAllocation.minExecutors</td>
+ <td></td>
+ <td>Lower bound for the number of executors.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.dynamicAllocation.initialExecutors</td>
+ <td></td>
+ <td>Initial number of executors to run.</td>
+ </tr>
+ <tr>
+ <td>livy.spark.dynamicAllocation.maxExecutors</td>
+ <td></td>
+ <td>Upper bound for the number of executors.</td>
+ </tr>
+</table>
+
+<h2>How to use</h2>
+
+<p>Basically, you can use</p>
+
+<p><strong>spark</strong></p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">%livy.spark
+sc.version
+</code></pre></div>
+<p><strong>pyspark</strong></p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">%livy.pyspark
+print "1"
+</code></pre></div>
+<p><strong>sparkR</strong></p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">%livy.sparkr
+hello <- function( name ) {
+ sprintf( "Hello, %s", name );
+}
+
+hello("livy")
+</code></pre></div>
+<h2>Impersonation</h2>
+
+<p>When Zeppelin server is running with authentication enabled, then this
interpreter utilizes Livyâs user impersonation feature i.e. sends extra
parameter for creating and running a session ("proxyUser":
"${loggedInUser}"). This is particularly useful when multi users are
sharing a Notebook server.</p>
+
+<h2>Apply Zeppelin Dynamic Forms</h2>
+
+<p>You can leverage <a href="/docs/0.6.0/manual/dynamicform.html">Zeppelin
Dynamic Form</a>. You can use both the <code>text input</code> and <code>select
form</code> parameterization features.</p>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">%livy.pyspark
+print
"${group_by=product_id,product_id|product_name|customer_id|store_id}"
+</code></pre></div>
+<h2>FAQ</h2>
+
+<p>Livy debugging: If you see any of these in error console</p>
+
+<blockquote>
+<p>Connect to livyhost:8998 [livyhost/127.0.0.1, livyhost/0:0:0:0:0:0:0:1]
failed: Connection refused</p>
+</blockquote>
+
+<p>Looks like the livy server is not up yet or the config is wrong</p>
+
+<blockquote>
+<p>Exception: Session not found, Livy server would have restarted, or lost
session.</p>
+</blockquote>
+
+<p>The session would have timed out, you may need to restart the
interpreter.</p>
+
+<blockquote>
+<p>Blacklisted configuration values in session config: spark.master</p>
+</blockquote>
+
+<p>Edit <code>conf/spark-blacklist.conf</code> file in livy server and comment
out <code>#spark.master</code> line.</p>
+
+<p>If you choose to work on livy in <code>apps/spark/java</code> directory in
<a href="https://github.com/cloudera/hue";>https://github.com/cloudera/hue</a>,
+copy <code>spark-user-configurable-options.template</code> to
<code>spark-user-configurable-options.conf</code> file in livy server and
comment out <code>#spark.master</code>. </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.0/interpreter/livy.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.6.0/interpreter/markdown.html
URL:
http://svn.apache.org/viewvc/zeppelin/site/docs/0.6.0/interpreter/markdown.html?rev=1751605&view=auto
==============================================================================
--- zeppelin/site/docs/0.6.0/interpreter/markdown.html (added)
+++ zeppelin/site/docs/0.6.0/interpreter/markdown.html Wed Jul 6 06:25:29 2016
@@ -0,0 +1,219 @@
+
+<!DOCTYPE html>
+<html lang="en">
+ <head>
+ <meta charset="utf-8">
+ <title>Markdown Interpreter</title>
+ <meta name="description" content="Markdown Interpreter">
+ <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.0/assets/themes/zeppelin/bootstrap/css/bootstrap.css"
rel="stylesheet">
+ <link href="/docs/0.6.0/assets/themes/zeppelin/css/style.css?body=1"
rel="stylesheet" type="text/css">
+ <link href="/docs/0.6.0/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.0/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/docs.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.6.0/atom.xml" type="application/atom+xml"
rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.6.0/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.0">
+ <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.0</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.0/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.0/install/install.html">Install</a></li>
+ <li><a
href="/docs/0.6.0/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a
href="/docs/0.6.0/quickstart/explorezeppelinui.html">Explore Zeppelin
UI</a></li>
+ <li><a
href="/docs/0.6.0/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.0/manual/dynamicform.html">Dynamic
Form</a></li>
+ <li><a href="/docs/0.6.0/manual/publish.html">Publish your
Paragraph</a></li>
+ <li><a
href="/docs/0.6.0/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.0/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+ <li><a href="/docs/0.6.0/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.0/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.0/manual/interpreterinstallation.html">Interpreter
Installation</a></li>
+ <!--<li><a
href="/docs/0.6.0/manual/dynamicinterpreterload.html">Dynamic Interpreter
Loading</a></li>-->
+ <li><a
href="/docs/0.6.0/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.0/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a href="/docs/0.6.0/interpreter/flink.html">Flink</a></li>
+ <li><a href="/docs/0.6.0/interpreter/geode.html">Geode</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hbase.html">HBase</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hdfs.html">HDFS</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hive.html">Hive</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/ignite.html">Ignite</a></li>
+ <li><a href="/docs/0.6.0/interpreter/jdbc.html">JDBC</a></li>
+ <li><a href="/docs/0.6.0/interpreter/lens.html">Lens</a></li>
+ <li><a href="/docs/0.6.0/interpreter/livy.html">Livy</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/markdown.html">Markdown</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/python.html">Python</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+ <li><a href="/docs/0.6.0/interpreter/r.html">R</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/scalding.html">Scalding</a></li>
+ <li><a href="/docs/0.6.0/pleasecontribute.html">Shell</a></li>
+ <li><a href="/docs/0.6.0/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.0/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a
href="/docs/0.6.0/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a
href="/docs/0.6.0/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.0/displaysystem/back-end-angular.html">Angular (backend
API)</a></li>
+ <li><a
href="/docs/0.6.0/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.0/storage/storage.html#notebook-storage-in-local-git-repository">Git
Storage</a></li>
+ <li><a
href="/docs/0.6.0/storage/storage.html#notebook-storage-in-s3">S3
Storage</a></li>
+ <li><a
href="/docs/0.6.0/storage/storage.html#notebook-storage-in-azure">Azure
Storage</a></li>
+ <li><a
href="/docs/0.6.0/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.0/rest-api/rest-interpreter.html">Interpreter API</a></li>
+ <li><a href="/docs/0.6.0/rest-api/rest-notebook.html">Notebook
API</a></li>
+ <li><a
href="/docs/0.6.0/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.0/security/authentication.html">Authentication for
NGINX</a></li>
+ <li><a
href="/docs/0.6.0/security/shiroauthentication.html">Shiro
Authentication</a></li>
+ <li><a
href="/docs/0.6.0/security/notebook_authorization.html">Notebook
Authorization</a></li>
+ <li><a
href="/docs/0.6.0/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.0/development/writingzeppelininterpreter.html">Writing Zeppelin
Interpreter</a></li>
+ <li><a href="/docs/0.6.0/development/howtocontribute.html">How
to contribute (code)</a></li>
+ <li><a
href="/docs/0.6.0/development/howtocontributewebsite.html">How to contribute
(website)</a></li>
+ </ul>
+ </li>
+ </ul>
+ </nav><!--/.navbar-collapse -->
+ </div>
+ </div>
+
+
+ <div class="content">
+
+<!--<div class="hero-unit Markdown Interpreter">
+ <h1></h1>
+</div>
+-->
+
+<div class="row">
+ <div class="col-md-12">
+ <h1>Markdown Interpreter for Apache Zeppelin</h1>
+
+<div id="toc"></div>
+
+<h2>Overview</h2>
+
+<p><a href="http://daringfireball.net/projects/markdown/";>Markdown</a> is a
plain text formatting syntax designed so that it can be converted to HTML.
+Zeppelin uses markdown4j. For more examples and extension support, please
checkout <a href="https://code.google.com/p/markdown4j/";>here</a>.<br>
+In Zeppelin notebook, you can use <code>%md</code> in the beginning of a
paragraph to invoke the Markdown interpreter and generate static html from
Markdown plain text.</p>
+
+<p>In Zeppelin, Markdown interpreter is enabled by default.</p>
+
+<p><img
src="/docs/0.6.0/assets/themes/zeppelin/img/docs-img/markdown-interpreter-setting.png"
width="60%" /></p>
+
+<h2>Example</h2>
+
+<p>The following example demonstrates the basic usage of Markdown in a
Zeppelin notebook.</p>
+
+<p><img
src="/docs/0.6.0/assets/themes/zeppelin/img/docs-img/markdown-example.png"
width="70%" /></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.0/interpreter/markdown.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: zeppelin/site/docs/0.6.0/interpreter/postgresql.html
URL:
http://svn.apache.org/viewvc/zeppelin/site/docs/0.6.0/interpreter/postgresql.html?rev=1751605&view=auto
==============================================================================
--- zeppelin/site/docs/0.6.0/interpreter/postgresql.html (added)
+++ zeppelin/site/docs/0.6.0/interpreter/postgresql.html Wed Jul 6 06:25:29
2016
@@ -0,0 +1,400 @@
+
+<!DOCTYPE html>
+<html lang="en">
+ <head>
+ <meta charset="utf-8">
+ <title>PostgreSQL and HAWQ 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.0/assets/themes/zeppelin/bootstrap/css/bootstrap.css"
rel="stylesheet">
+ <link href="/docs/0.6.0/assets/themes/zeppelin/css/style.css?body=1"
rel="stylesheet" type="text/css">
+ <link href="/docs/0.6.0/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.0/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/docs.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/anchor.min.js"></script>
+ <script src="/docs/0.6.0/assets/themes/zeppelin/js/toc.js"></script>
+
+ <!-- atom & rss feed -->
+ <link href="/docs/0.6.0/atom.xml" type="application/atom+xml"
rel="alternate" title="Sitewide ATOM Feed">
+ <link href="/docs/0.6.0/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.0">
+ <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.0</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.0/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.0/install/install.html">Install</a></li>
+ <li><a
href="/docs/0.6.0/install/install.html#apache-zeppelin-configuration">Configuration</a></li>
+ <li><a
href="/docs/0.6.0/quickstart/explorezeppelinui.html">Explore Zeppelin
UI</a></li>
+ <li><a
href="/docs/0.6.0/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.0/manual/dynamicform.html">Dynamic
Form</a></li>
+ <li><a href="/docs/0.6.0/manual/publish.html">Publish your
Paragraph</a></li>
+ <li><a
href="/docs/0.6.0/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.0/install/virtual_machine.html">Zeppelin on Vagrant VM</a></li>
+ <li><a href="/docs/0.6.0/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.0/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.0/manual/interpreterinstallation.html">Interpreter
Installation</a></li>
+ <!--<li><a
href="/docs/0.6.0/manual/dynamicinterpreterload.html">Dynamic Interpreter
Loading</a></li>-->
+ <li><a
href="/docs/0.6.0/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.0/interpreter/alluxio.html">Alluxio</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/cassandra.html">Cassandra</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/elasticsearch.html">Elasticsearch</a></li>
+ <li><a href="/docs/0.6.0/interpreter/flink.html">Flink</a></li>
+ <li><a href="/docs/0.6.0/interpreter/geode.html">Geode</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hbase.html">HBase</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hdfs.html">HDFS</a></li>
+ <li><a href="/docs/0.6.0/interpreter/hive.html">Hive</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/ignite.html">Ignite</a></li>
+ <li><a href="/docs/0.6.0/interpreter/jdbc.html">JDBC</a></li>
+ <li><a href="/docs/0.6.0/interpreter/lens.html">Lens</a></li>
+ <li><a href="/docs/0.6.0/interpreter/livy.html">Livy</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/markdown.html">Markdown</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/python.html">Python</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/postgresql.html">Postgresql, HAWQ</a></li>
+ <li><a href="/docs/0.6.0/interpreter/r.html">R</a></li>
+ <li><a
href="/docs/0.6.0/interpreter/scalding.html">Scalding</a></li>
+ <li><a href="/docs/0.6.0/pleasecontribute.html">Shell</a></li>
+ <li><a href="/docs/0.6.0/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.0/displaysystem/basicdisplaysystem.html#text">Text</a></li>
+ <li><a
href="/docs/0.6.0/displaysystem/basicdisplaysystem.html#html">Html</a></li>
+ <li><a
href="/docs/0.6.0/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.0/displaysystem/back-end-angular.html">Angular (backend
API)</a></li>
+ <li><a
href="/docs/0.6.0/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.0/storage/storage.html#notebook-storage-in-local-git-repository">Git
Storage</a></li>
+ <li><a
href="/docs/0.6.0/storage/storage.html#notebook-storage-in-s3">S3
Storage</a></li>
+ <li><a
href="/docs/0.6.0/storage/storage.html#notebook-storage-in-azure">Azure
Storage</a></li>
+ <li><a
href="/docs/0.6.0/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.0/rest-api/rest-interpreter.html">Interpreter API</a></li>
+ <li><a href="/docs/0.6.0/rest-api/rest-notebook.html">Notebook
API</a></li>
+ <li><a
href="/docs/0.6.0/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.0/security/authentication.html">Authentication for
NGINX</a></li>
+ <li><a
href="/docs/0.6.0/security/shiroauthentication.html">Shiro
Authentication</a></li>
+ <li><a
href="/docs/0.6.0/security/notebook_authorization.html">Notebook
Authorization</a></li>
+ <li><a
href="/docs/0.6.0/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.0/development/writingzeppelininterpreter.html">Writing Zeppelin
Interpreter</a></li>
+ <li><a href="/docs/0.6.0/development/howtocontribute.html">How
to contribute (code)</a></li>
+ <li><a
href="/docs/0.6.0/development/howtocontributewebsite.html">How to contribute
(website)</a></li>
+ </ul>
+ </li>
+ </ul>
+ </nav><!--/.navbar-collapse -->
+ </div>
+ </div>
+
+
+ <div class="content">
+
+<!--<div class="hero-unit PostgreSQL and HAWQ Interpreter">
+ <h1></h1>
+</div>
+-->
+
+<div class="row">
+ <div class="col-md-12">
+ <h1>PostgreSQL, Apache HAWQ (incubating) Interpreter for Apache
Zeppelin</h1>
+
+<div id="toc"></div>
+
+<h2>Important Notice</h2>
+
+<p>Postgresql Interpreter will be deprecated and merged into JDBC Interpreter.
You can use Postgresql 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>psql.driver</td>
+ <td>org.postgresql.Driver</td>
+ </tr>
+ <tr>
+ <td>psql.url</td>
+ <td>jdbc:postgresql://localhost:5432/</td>
+ </tr>
+ <tr>
+ <td>psql.user</td>
+ <td>psqlUser</td>
+ </tr>
+ <tr>
+ <td>psql.password</td>
+ <td>psqlPassword</td>
+ </tr>
+</table>
+
+<h3>Dependencies</h3>
+
+<table class="table-configuration">
+ <tr>
+ <th>Artifact</th>
+ <th>Exclude</th>
+ </tr>
+ <tr>
+ <td>org.postgresql:postgresql:9.4-1201-jdbc41</td>
+ <td></td>
+ </tr>
+</table>
+
+<hr>
+
+<h2>Overview</h2>
+
+<p><a href="https://www.youtube.com/watch?v=wqXXQhJ5Uk8";><img align="right"
src="http://img.youtube.com/vi/wqXXQhJ5Uk8/0.jpg"; alt="zeppelin-view"
hspace="10" width="250"></img></a></p>
+
+<p>This interpreter seamlessly supports the following SQL data processing
engines:</p>
+
+<ul>
+<li><a href="http://www.postgresql.org/";>PostgreSQL</a> - OSS,
Object-relational database management system (ORDBMS)</li>
+<li><a href="http://hawq.incubator.apache.org/";>pache HAWQ (incubating)</a> -
Powerful open source SQL-On-Hadoop engine.</li>
+<li><a
href="http://pivotal.io/big-data/pivotal-greenplum-database";>Greenplum</a> -
MPP database built on open source PostgreSQL.</li>
+</ul>
+
+<p>This <a href="https://www.youtube.com/watch?v=wqXXQhJ5Uk8";>Video
Tutorial</a> illustrates some of the features provided by the <code>Postgresql
Interpreter</code>.</p>
+
+<table class="table-configuration">
+ <tr>
+ <th>Name</th>
+ <th>Class</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>%psql.sql</td>
+ <td>PostgreSqlInterpreter</td>
+ <td>Provides SQL environment for PostgreSQL, HAWQ and Greenplum</td>
+ </tr>
+</table>
+
+<h2>Create Interpreter</h2>
+
+<p>By default Zeppelin creates one <code>PSQL</code> instance. You can remove
it or create new instances.</p>
+
+<p>Multiple PSQL instances can be created, each configured to the same or
different backend databases. But over time a <code>Notebook</code> can have
only one PSQL interpreter instance <code>bound</code>. That means you
<em>cannot</em> connect to different databases in the same
<code>Notebook</code>. This is a known Zeppelin limitation.</p>
+
+<p>To create new PSQL instance open the <code>Interpreter</code> section and
click the <code>+Create</code> button. Pick a <code>Name</code> of your choice
and from the <code>Interpreter</code> drop-down select <code>psql</code>. Then
follow the configuration instructions and <code>Save</code> the new
instance.</p>
+
+<blockquote>
+<p>Note: The <code>Name</code> of the instance is used only to distinct the
instances while binding them to the <code>Notebook</code>. The
<code>Name</code> is irrelevant inside the <code>Notebook</code>. In the
<code>Notebook</code> you must use <code>%psql.sql</code> tag.</p>
+</blockquote>
+
+<h2>Bind to Notebook</h2>
+
+<p>In the <code>Notebook</code> click on the <code>settings</code> icon in the
top right corner. The select/deselect the interpreters to be bound with the
<code>Notebook</code>.</p>
+
+<h2>Configuration</h2>
+
+<p>You can modify the configuration of the PSQL from the
<code>Interpreter</code> section. The PSQL interpreter expenses the following
properties:</p>
+
+<table class="table-configuration">
+ <tr>
+ <th>Property Name</th>
+ <th>Description</th>
+ <th>Default Value</th>
+ </tr>
+ <tr>
+ <td>postgresql.url</td>
+ <td>JDBC URL to connect to </td>
+ <td>jdbc:postgresql://localhost:5432</td>
+ </tr>
+ <tr>
+ <td>postgresql.user</td>
+ <td>JDBC user name</td>
+ <td>gpadmin</td>
+ </tr>
+ <tr>
+ <td>postgresql.password</td>
+ <td>JDBC password</td>
+ <td></td>
+ </tr>
+ <tr>
+ <td>postgresql.driver.name</td>
+ <td>JDBC driver name. In this version the driver name is fixed and should
not be changed</td>
+ <td>org.postgresql.Driver</td>
+ </tr>
+ <tr>
+ <td>postgresql.max.result</td>
+ <td>Max number of SQL result to display to prevent the browser
overload</td>
+ <td>1000</td>
+ </tr>
+</table>
+
+<h2>How to use</h2>
+<div class="highlight"><pre><code class="text language-text"
data-lang="text">Tip: Use (CTRL + .) for SQL auto-completion.
+</code></pre></div>
+<h3>DDL and SQL commands</h3>
+
+<p>Start the paragraphs with the full <code>%psql.sql</code> prefix tag! The
short notation: <code>%psql</code> would still be able run the queries but the
syntax highlighting and the auto-completions will be disabled.</p>
+
+<p>You can use the standard CREATE / DROP / INSERT commands to create or
modify the data model:</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">psql</span><span
class="p">.</span><span class="k">sql</span>
+<span class="k">drop</span> <span class="k">table</span> <span
class="n">if</span> <span class="k">exists</span> <span
class="n">mytable</span><span class="p">;</span>
+<span class="k">create</span> <span class="k">table</span> <span
class="n">mytable</span> <span class="p">(</span><span class="n">i</span> <span
class="nb">int</span><span class="p">);</span>
+<span class="k">insert</span> <span class="k">into</span> <span
class="n">mytable</span> <span class="k">select</span> <span
class="n">generate_series</span><span class="p">(</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">100</span><span
class="p">);</span>
+</code></pre></div>
+<p>Then in a separate paragraph run the query.</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">psql</span><span
class="p">.</span><span class="k">sql</span>
+<span class="k">select</span> <span class="o">*</span> <span
class="k">from</span> <span class="n">mytable</span><span class="p">;</span>
+</code></pre></div>
+<blockquote>
+<p>Note: You can have multiple queries in the same paragraph but only the
result from the first is displayed. [<a
href="https://issues.apache.org/jira/browse/ZEPPELIN-178";>1</a>], [<a
href="https://issues.apache.org/jira/browse/ZEPPELIN-212";>2</a>].</p>
+</blockquote>
+
+<p>For example, this will execute both queries but only the count result will
be displayed. If you revert the order of the queries the mytable content will
be shown instead.</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">psql</span><span
class="p">.</span><span class="k">sql</span>
+<span class="k">select</span> <span class="k">count</span><span
class="p">(</span><span class="o">*</span><span class="p">)</span> <span
class="k">from</span> <span class="n">mytable</span><span class="p">;</span>
+<span class="k">select</span> <span class="o">*</span> <span
class="k">from</span> <span class="n">mytable</span><span class="p">;</span>
+</code></pre></div>
+<h3>PSQL command line tools</h3>
+
+<p>Use the Shell Interpreter (<code>%sh</code>) to access the command line <a
href="http://www.postgresql.org/docs/9.4/static/app-psql.html";>PSQL</a>
interactively:</p>
+<div class="highlight"><pre><code class="bash language-bash"
data-lang="bash">%sh
+psql -h phd3.localdomain -U gpadmin -p 5432 <span class="s"><<EOF</span>
+<span class="s"> \dn </span>
+<span class="s"> \q</span>
+<span class="s">EOF</span>
+</code></pre></div>
+<p>This will produce output like this:</p>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">
Name | Owner
+--------------------+---------
+ hawq_toolkit | gpadmin
+ information_schema | gpadmin
+ madlib | gpadmin
+ pg_catalog | gpadmin
+ pg_toast | gpadmin
+ public | gpadmin
+ retail_demo | gpadmin
+</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">psql</span><span
class="p">.</span><span class="k">sql</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>
+<h3>Example HAWQ PXF/HDFS Tables</h3>
+
+<p>Create HAWQ external table that read data from tab-separated-value data in
HDFS.</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">psql</span><span
class="p">.</span><span class="k">sql</span>
+<span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span
class="k">TABLE</span> <span class="n">retail_demo</span><span
class="p">.</span><span class="n">payment_methods_pxf</span> <span
class="p">(</span>
+ <span class="n">payment_method_id</span> <span
class="nb">smallint</span><span class="p">,</span>
+ <span class="n">payment_method_code</span> <span class="nb">character</span>
<span class="nb">varying</span><span class="p">(</span><span
class="mi">20</span><span class="p">)</span>
+<span class="p">)</span> <span class="k">LOCATION</span> <span
class="p">(</span><span
class="s1">'pxf://${NAME_NODE_HOST}:50070/retail_demo/payment_methods.tsv.gz?profile=HdfsTextSimple'</span><span
class="p">)</span> <span class="n">FORMAT</span> <span
class="s1">'TEXT'</span> <span class="p">(</span><span
class="k">DELIMITER</span> <span class="o">=</span> <span
class="n">E</span><span class="s1">'\t'</span><span class="p">);</span>
+</code></pre></div>
+<p>And retrieve content</p>
+<div class="highlight"><pre><code class="sql language-sql"
data-lang="sql"><span class="o">%</span><span class="n">psql</span><span
class="p">.</span><span class="k">sql</span>
+<span class="k">select</span> <span class="o">*</span> <span
class="k">from</span> <span class="n">retail_demo</span><span
class="p">.</span><span class="n">payment_methods_pxf</span>
+</code></pre></div>
+<h2>Auto-completion</h2>
+
+<p>The PSQL Interpreter provides a basic auto-completion functionality. On
<code>(Ctrl+.)</code> it list the most relevant suggestions in a pop-up window.
In addition to the SQL keyword the interpreter provides suggestions for the
Schema, Table, Column names as well.</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.0/interpreter/postgresql.html
------------------------------------------------------------------------------
svn:eol-style = native
![http://img.youtube.com/vi/wqXXQhJ5Uk8/0.jpg"](https://img.youtube.com/vi/wqXXQhJ5Uk8/0.jpg"){kind=link}