zeppelin-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From m...@apache.org
Subject svn commit: r1713200 - in /incubator/zeppelin/site: assets/themes/zeppelin/img/docs-img/ docs/ docs/interpreter/
Date Sun, 08 Nov 2015 00:39:25 GMT
Author: moon
Date: Sun Nov  8 00:39:24 2015
New Revision: 1713200

URL: http://svn.apache.org/viewvc?rev=1713200&view=rev
Log:
Add docs for Cassandra interpreter https://issues.apache.org/jira/browse/ZEPPELIN-382

Added:
    incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-DescribeSchema.png   (with props)
    incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InteractiveHelp.png   (with props)
    incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterBinding.png   (with props)
    incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterInstanceSelection.png   (with props)
    incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterName.png   (with props)
    incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterSelection.png   (with props)
    incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInList.png   (with props)
    incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInstance.png   (with props)
    incubator/zeppelin/site/docs/interpreter/cassandra.html
Modified:
    incubator/zeppelin/site/docs/index.html

Added: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-DescribeSchema.png
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-DescribeSchema.png?rev=1713200&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-DescribeSchema.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InteractiveHelp.png
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InteractiveHelp.png?rev=1713200&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InteractiveHelp.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterBinding.png
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterBinding.png?rev=1713200&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterBinding.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterInstanceSelection.png
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterInstanceSelection.png?rev=1713200&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterInstanceSelection.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterName.png
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterName.png?rev=1713200&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterName.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterSelection.png
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterSelection.png?rev=1713200&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterSelection.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInList.png
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInList.png?rev=1713200&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInList.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInstance.png
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInstance.png?rev=1713200&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/zeppelin/site/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInstance.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Modified: incubator/zeppelin/site/docs/index.html
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/index.html?rev=1713200&r1=1713199&r2=1713200&view=diff
==============================================================================
--- incubator/zeppelin/site/docs/index.html (original)
+++ incubator/zeppelin/site/docs/index.html Sun Nov  8 00:39:24 2015
@@ -379,16 +379,17 @@
 <p><strong><a href="manual/interpreters.html">Interpreters in zeppelin</a></strong></p>
 
 <ul>
+<li><a href="./interpreter/cassandra.html">cassandra</a></li>
 <li><a href="./interpreter/flink.html">flink</a></li>
+<li><a href="./interpreter/geode.html">geode</a></li>
 <li><a href="../docs/pleasecontribute.html">hive</a></li>
 <li><a href="./interpreter/ignite.html">ignite</a></li>
 <li><a href="./interpreter/lens.html">lens</a></li>
 <li><a href="../docs/pleasecontribute.html">md</a></li>
+<li><a href="./interpreter/postgresql.html">postgresql, hawq</a></li>
 <li><a href="../docs/pleasecontribute.html">sh</a></li>
 <li><a href="./interpreter/spark.html">spark</a></li>
 <li><a href="../docs/pleasecontribute.html">tajo</a></li>
-<li><a href="./interpreter/postgresql.html">postgresql, hawq</a></li>
-<li><a href="./interpreter/geode.html">geode</a></li>
 </ul>
 
 <h3>Display System</h3>

Added: incubator/zeppelin/site/docs/interpreter/cassandra.html
URL: http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/interpreter/cassandra.html?rev=1713200&view=auto
==============================================================================
--- incubator/zeppelin/site/docs/interpreter/cassandra.html (added)
+++ incubator/zeppelin/site/docs/interpreter/cassandra.html Sun Nov  8 00:39:24 2015
@@ -0,0 +1,1168 @@
+
+<!DOCTYPE html>
+<html lang="en">
+  <head>
+    <meta charset="utf-8">
+    <title>Cassandra Interpreter</title>
+    <meta name="description" content="Cassandra 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]-->
+
+    <!-- Le styles -->
+    <link href="/assets/themes/zeppelin/bootstrap/css/bootstrap.css" rel="stylesheet">
+    <link href="/assets/themes/zeppelin/css/style.css?body=1" rel="stylesheet" type="text/css">
+    <link href="/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="/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script>
+
+    <!-- atom & rss feed -->
+    <link href="/atom.xml" type="application/atom+xml" rel="alternate" title="Sitewide ATOM Feed">
+    <link href="/rss.xml" type="application/rss+xml" rel="alternate" title="Sitewide RSS Feed">
+  </head>
+
+  <body>
+    
+        <div 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="/">
+            <img src="/assets/themes/zeppelin/img/zeppelin_logo.png" width="50" alt="I'm zeppelin">
+            Apache Zeppelin <small>(incubating)</small>
+          </a>
+        </div>
+        <nav class="navbar-collapse collapse" role="navigation">
+          <ul class="nav navbar-nav">
+            
+            
+            
+
+
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+
+
+
+          </ul>
+          <ul class="nav navbar-nav navbar-right">
+            
+            
+            
+
+
+  
+    
+      
+    
+  
+    
+      
+      	
+      	<li><a href="/community.html">Community</a></li>
+      	
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+      	
+      	<li><a href="/docs/index.html">Docs</a></li>
+      	
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+      	
+      	<li><a href="/download.html">Download</a></li>
+      	
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+    
+      
+    
+  
+
+
+
+            <li><a href="https://github.com/apache/incubator-zeppelin">GitHub</a></li>
+            <li id="apache">
+              <a href="#" data-toggle="dropdown" class="dropdown-toggle">Apache<b class="caret"></b></a>
+               <ul class="dropdown-menu">
+                <li><a href="http://www.apache.org/foundation/how-it-works.html">Apache Software Foundation</a></li>
+                <li><a href="http://www.apache.org/licenses/">Apache License</a></li>
+                <li><a href="http://www.apache.org/foundation/sponsorship.html">Sponsorship</a></li>
+                <li><a href="http://www.apache.org/foundation/thanks.html">Thanks</a></li>
+            </ul>
+            </li>
+          </ul>
+        </nav><!--/.navbar-collapse -->
+      </div>
+    </div>
+
+
+
+
+    <div class="container">
+      
+<!--<div class="hero-unit Cassandra Interpreter">
+  <h1></h1>
+</div>
+-->
+
+<div class="row">
+  <div class="col-md-12">
+    <hr/>
+
+<h2>1. Cassandra CQL Interpreter for Apache Zeppelin</h2>
+
+<p><br/>
+<table class="table-configuration">
+  <tr>
+    <th>Name</th>
+    <th>Class</th>
+    <th>Description</th>
+  </tr>
+  <tr>
+    <td>%cassandra</td>
+    <td>CassandraInterpreter</td>
+    <td>Provides interpreter for Apache Cassandra CQL query language</td>
+  </tr>
+</table></p>
+
+<hr/>
+
+<h2>2. Enabling Cassandra Interpreter</h2>
+
+<p>In a notebook, to enable the <strong>Cassandra</strong> interpreter, click on the <strong>Gear</strong> icon and select <strong>Cassandra</strong></p>
+
+<p><center>
+ <img src="/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterBinding.png" alt="Interpreter Binding"></p>
+
+<p><img src="/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterSelection.png" alt="Interpreter Selection">
+ </center></p>
+
+<hr/>
+
+<h2>3. Using the Cassandra Interpreter</h2>
+
+<p>In a paragraph, use <strong><em>%cassandra</em></strong> to select the <strong>Cassandra</strong> interpreter and then input all commands.</p>
+
+<p>To access the interactive help, type <strong>HELP;</strong></p>
+
+<p><center>
+  <img src="/assets/themes/zeppelin/img/docs-img/cassandra-InteractiveHelp.png" alt="Interactive Help">
+ </center></p>
+
+<hr/>
+
+<h2>4. Interpreter Commands</h2>
+
+<p>The <strong>Cassandra</strong> interpreter accepts the following commands</p>
+
+<p><center>
+  <table class="table-configuration">
+    <tr>
+      <th>Command Type</th>
+      <th>Command Name</th>
+      <th>Description</th>
+    </tr>
+    <tr>
+      <td nowrap>Help command</td>
+      <td>HELP</td>
+      <td>Display the interactive help menu</td>
+    </tr>
+    <tr>
+      <td nowrap>Schema commands</td>
+      <td>DESCRIBE KEYSPACE, DESCRIBE CLUSTER, DESCRIBE TABLES ...</td>
+      <td>Custom commands to describe the Cassandra schema</td>
+    </tr>
+    <tr>
+      <td nowrap>Option commands</td>
+      <td>@consistency, @retryPolicy, @fetchSize ...</td>
+      <td>Inject runtime options to all statements in the paragraph</td>
+    </tr>
+    <tr>
+      <td nowrap>Prepared statement commands</td>
+      <td>@prepare, @bind, @remove_prepared</td>
+      <td>Let you register a prepared command and re-use it later by injecting bound values</td>
+    </tr>
+    <tr>
+      <td nowrap>Native CQL statements</td>
+      <td>All CQL-compatible statements (SELECT, INSERT, CREATE ...)</td>
+      <td>All CQL statements are executed directly against the Cassandra server</td>
+    </tr>
+  </table><br>
+</center></p>
+
+<hr/>
+
+<h2>5. CQL statements</h2>
+
+<p>This interpreter is compatible with any CQL statement supported by Cassandra. Ex: </p>
+<div class="highlight"><pre><code class="sql language-sql" data-lang="sql">    <span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">users</span><span class="p">(</span><span class="n">login</span><span class="p">,</span><span class="n">name</span><span class="p">)</span> <span class="k">VALUES</span><span class="p">(</span><span class="s1">&#39;jdoe&#39;</span><span class="p">,</span><span class="s1">&#39;John DOE&#39;</span><span class="p">);</span>
+    <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">users</span> <span class="k">WHERE</span> <span class="n">login</span><span class="o">=</span><span class="s1">&#39;jdoe&#39;</span><span class="p">;</span>
+</code></pre></div>
+<p>Each statement should be separated by a semi-colon ( <strong>;</strong> ) except the special commands below:</p>
+
+<ol>
+<li>@prepare</li>
+<li>@bind</li>
+<li>@remove_prepare</li>
+<li>@consistency</li>
+<li>@serialConsistency</li>
+<li>@timestamp</li>
+<li>@retryPolicy</li>
+<li>@fetchSize</li>
+</ol>
+
+<p>Multi-line statements as well as multiple statements on the same line are also supported as long as they are 
+separated by a semi-colon. Ex: </p>
+<div class="highlight"><pre><code class="sql language-sql" data-lang="sql">    <span class="n">USE</span> <span class="n">spark_demo</span><span class="p">;</span>
+
+    <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">albums_by_country</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">;</span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">countries</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">;</span>
+
+    <span class="k">SELECT</span> <span class="o">*</span>
+    <span class="k">FROM</span> <span class="n">artists</span>
+    <span class="k">WHERE</span> <span class="n">login</span><span class="o">=</span><span class="s1">&#39;jlennon&#39;</span><span class="p">;</span>
+</code></pre></div>
+<p>Batch statements are supported and can span multiple lines, as well as DDL(CREATE/ALTER/DROP) statements: </p>
+<div class="highlight"><pre><code class="sql language-sql" data-lang="sql">    <span class="k">BEGIN</span> <span class="n">BATCH</span>
+        <span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">users</span><span class="p">(</span><span class="n">login</span><span class="p">,</span><span class="n">name</span><span class="p">)</span> <span class="k">VALUES</span><span class="p">(</span><span class="s1">&#39;jdoe&#39;</span><span class="p">,</span><span class="s1">&#39;John DOE&#39;</span><span class="p">);</span>
+        <span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">users_preferences</span><span class="p">(</span><span class="n">login</span><span class="p">,</span><span class="n">account_type</span><span class="p">)</span> <span class="k">VALUES</span><span class="p">(</span><span class="s1">&#39;jdoe&#39;</span><span class="p">,</span><span class="s1">&#39;BASIC&#39;</span><span class="p">);</span>
+    <span class="n">APPLY</span> <span class="n">BATCH</span><span class="p">;</span>
+
+    <span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span> <span class="n">test</span><span class="p">(</span>
+        <span class="k">key</span> <span class="nb">int</span> <span class="k">PRIMARY</span> <span class="k">KEY</span><span class="p">,</span>
+        <span class="n">value</span> <span class="nb">text</span>
+    <span class="p">);</span>
+</code></pre></div>
+<p>CQL statements are <strong>case-insensitive</strong> (except for column names and values). 
+This means that the following statements are equivalent and valid: </p>
+<div class="highlight"><pre><code class="sql language-sql" data-lang="sql">    <span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">users</span><span class="p">(</span><span class="n">login</span><span class="p">,</span><span class="n">name</span><span class="p">)</span> <span class="k">VALUES</span><span class="p">(</span><span class="s1">&#39;jdoe&#39;</span><span class="p">,</span><span class="s1">&#39;John DOE&#39;</span><span class="p">);</span>
+    <span class="k">Insert</span> <span class="k">into</span> <span class="n">users</span><span class="p">(</span><span class="n">login</span><span class="p">,</span><span class="n">name</span><span class="p">)</span> <span class="k">vAlues</span><span class="p">(</span><span class="s1">&#39;hsue&#39;</span><span class="p">,</span><span class="s1">&#39;Helen SUE&#39;</span><span class="p">);</span>
+</code></pre></div>
+<p>The complete list of all CQL statements and versions can be found below:
+<center><br>
+ <table class="table-configuration">
+   <tr>
+     <th>Cassandra Version</th>
+     <th>Documentation Link</th>
+   </tr>
+   <tr>
+     <td><strong>2.2</strong></td>
+     <td>
+        <a target="_blank" 
+          href="http://docs.datastax.com/en/cql/3.3/cql/cqlIntro.html">
+          http://docs.datastax.com/en/cql/3.3/cql/cqlIntro.html
+        </a>
+     </td>
+   </tr><br>
+   <tr>
+     <td><strong>2.1 &amp; 2.0</strong></td>
+     <td>
+        <a target="_blank" 
+          href="http://docs.datastax.com/en/cql/3.1/cql/cql_intro_c.html">
+          http://docs.datastax.com/en/cql/3.1/cql/cql<em>intro</em>c.html
+        </a>
+     </td>
+   </tr><br>
+   <tr>
+     <td><strong>1.2</strong></td>
+     <td>
+        <a target="_blank" 
+          href="http://docs.datastax.com/en/cql/3.0/cql/aboutCQL.html">
+          http://docs.datastax.com/en/cql/3.0/cql/aboutCQL.html
+        </a>
+     </td>
+   </tr><br>
+ </table>
+</center></p>
+
+<hr/>
+
+<h2>6. Comments in statements</h2>
+
+<p>It is possible to add comments between statements. Single line comments start with the hash sign (#). Multi-line comments are enclosed between /** and **/. Ex: </p>
+<div class="highlight"><pre><code class="sql language-sql" data-lang="sql">    <span class="o">#</span><span class="k">First</span> <span class="k">comment</span>
+    <span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">users</span><span class="p">(</span><span class="n">login</span><span class="p">,</span><span class="n">name</span><span class="p">)</span> <span class="k">VALUES</span><span class="p">(</span><span class="s1">&#39;jdoe&#39;</span><span class="p">,</span><span class="s1">&#39;John DOE&#39;</span><span class="p">);</span>
+
+    <span class="cm">/**</span>
+<span class="cm">     Multi line</span>
+<span class="cm">     comments</span>
+<span class="cm">     **/</span>
+    <span class="k">Insert</span> <span class="k">into</span> <span class="n">users</span><span class="p">(</span><span class="n">login</span><span class="p">,</span><span class="n">name</span><span class="p">)</span> <span class="k">vAlues</span><span class="p">(</span><span class="s1">&#39;hsue&#39;</span><span class="p">,</span><span class="s1">&#39;Helen SUE&#39;</span><span class="p">);</span>
+</code></pre></div>
+<hr/>
+
+<h2>7. Syntax Validation</h2>
+
+<p>The interpreters is shipped with a built-in syntax validator. This validator only checks for basic syntax errors. 
+All CQL-related syntax validation is delegated directly to <strong>Cassandra</strong> </p>
+
+<p>Most of the time, syntax errors are due to <strong>missing semi-colons</strong> between statements or <strong>typo errors</strong>.</p>
+
+<hr/>
+
+<h2>8. Schema commands</h2>
+
+<p>To make schema discovery easier and more interactive, the following commands are supported:
+<center><br>
+ <table class="table-configuration">
+   <tr>
+     <th>Command</th>
+     <th>Description</th>
+   </tr>
+   <tr>
+     <td><strong>DESCRIBE CLUSTER;</strong></td>
+     <td>Show the current cluster name and its partitioner</td>
+   </tr><br>
+   <tr>
+     <td><strong>DESCRIBE KEYSPACES;</strong></td>
+     <td>List all existing keyspaces in the cluster and their configuration (replication factor, durable write ...)</td>
+   </tr><br>
+   <tr>
+     <td><strong>DESCRIBE TABLES;</strong></td>
+     <td>List all existing keyspaces in the cluster and for each, all the tables name</td>
+   </tr><br>
+   <tr>
+     <td><strong>DESCRIBE TYPES;</strong></td>
+     <td>List all existing user defined types in the <strong>current (logged) keyspace</strong></td>
+   </tr><br>
+   <tr>
+     <td nowrap><strong>DESCRIBE FUNCTIONS &lt;keyspace<em>name&gt;;</strong></td>
+     <td>List all existing user defined functions in the given keyspace</td>
+   </tr><br>
+   <tr>
+     <td nowrap><strong>DESCRIBE AGGREGATES &lt;keyspace</em>name&gt;;</strong></td>
+     <td>List all existing user defined aggregates in the given keyspace</td>
+   </tr><br>
+   <tr>
+     <td nowrap><strong>DESCRIBE KEYSPACE &lt;keyspace<em>name&gt;;</strong></td>
+     <td>Describe the given keyspace configuration and all its table details (name, columns, ...)</td>
+   </tr><br>
+   <tr>
+     <td nowrap><strong>DESCRIBE TABLE (&lt;keyspace</em>name&gt;).&lt;table<em>name&gt;;</strong></td>
+     <td>
+        Describe the given table. If the keyspace is not provided, the current logged in keyspace is used. 
+        If there is no logged in keyspace, the default system keyspace is used. 
+        If no table is found, an error message is raised
+     </td>
+   </tr><br>
+   <tr>
+     <td nowrap><strong>DESCRIBE TYPE (&lt;keyspace</em>name&gt;).&lt;type<em>name&gt;;</strong></td>
+     <td>
+        Describe the given type(UDT). If the keyspace is not provided, the current logged in keyspace is used. 
+        If there is no logged in keyspace, the default system keyspace is used. 
+        If no type is found, an error message is raised
+     </td>
+   </tr><br>
+   <tr>
+     <td nowrap><strong>DESCRIBE FUNCTION (&lt;keyspace</em>name&gt;).&lt;function<em>name&gt;;</strong></td>
+     <td>Describe the given user defined function. The keyspace is optional</td>
+   </tr><br>
+   <tr>
+     <td nowrap><strong>DESCRIBE AGGREGATE (&lt;keyspace</em>name&gt;).&lt;aggregate_name&gt;;</strong></td>
+     <td>Describe the given user defined aggregate. The keyspace is optional</td>
+   </tr><br>
+ </table>
+</center>              </p>
+
+<p>The schema objects (cluster, keyspace, table, type, function and aggregate) are displayed in a tabular format. 
+There is a drop-down menu on the top left corner to expand objects details. On the top right menu is shown the Icon legend.</p>
+
+<p><br/>
+<center>
+  <img src="/assets/themes/zeppelin/img/docs-img/cassandra-DescribeSchema.png" alt="Describe Schema">
+</center></p>
+
+<hr/>
+
+<h2>9. Runtime Parameters</h2>
+
+<p>Sometimes you want to be able to pass runtime query parameters to your statements. 
+Those parameters are not part of the CQL specs and are specific to the interpreter. 
+Below is the list of all parameters: </p>
+
+<p><br/>
+<center><br>
+ <table class="table-configuration">
+   <tr>
+     <th>Parameter</th>
+     <th>Syntax</th>
+     <th>Description</th>
+   </tr>
+   <tr>
+     <td nowrap>Consistency Level</td>
+     <td><strong>@consistency=<em>value</em></strong></td>
+     <td>Apply the given consistency level to all queries in the paragraph</td>
+   </tr>
+   <tr>
+     <td nowrap>Serial Consistency Level</td>
+     <td><strong>@serialConsistency=<em>value</em></strong></td>
+     <td>Apply the given serial consistency level to all queries in the paragraph</td>
+   </tr>
+   <tr>
+     <td nowrap>Timestamp</td>
+     <td><strong>@timestamp=<em>long value</em></strong></td>
+     <td>
+        Apply the given timestamp to all queries in the paragraph.
+        Please note that timestamp value passed directly in CQL statement will override this value
+      </td>
+   </tr>
+   <tr>
+     <td nowrap>Retry Policy</td>
+     <td><strong>@retryPolicy=<em>value</em></strong></td>
+     <td>Apply the given retry policy to all queries in the paragraph</td>
+   </tr>
+   <tr>
+     <td nowrap>Fetch Size</td>
+     <td><strong>@fetchSize=<em>integer value</em></strong></td>
+     <td>Apply the given fetch size to all queries in the paragraph</td>
+   </tr>
+ </table>
+</center></p>
+
+<p>Some parameters only accept restricted values: </p>
+
+<p><br/>
+<center><br>
+ <table class="table-configuration">
+   <tr>
+     <th>Parameter</th>
+     <th>Possible Values</th>
+   </tr>
+   <tr>
+     <td nowrap>Consistency Level</td>
+     <td><strong>ALL, ANY, ONE, TWO, THREE, QUORUM, LOCAL<em>ONE, LOCAL</em>QUORUM, EACH<em>QUORUM</strong></td>
+   </tr>
+   <tr>
+     <td nowrap>Serial Consistency Level</td>
+     <td><strong>SERIAL, LOCAL</em>SERIAL</strong></td>
+   </tr>
+   <tr>
+     <td nowrap>Timestamp</td>
+     <td>Any long value</td>
+   </tr>
+   <tr>
+     <td nowrap>Retry Policy</td>
+     <td><strong>DEFAULT, DOWNGRADING<em>CONSISTENCY, FALLTHROUGH, LOGGING</em>DEFAULT, LOGGING<em>DOWNGRADING, LOGGING</em>FALLTHROUGH</strong></td>
+   </tr>
+   <tr>
+     <td nowrap>Fetch Size</td>
+     <td>Any integer value</td>
+   </tr>
+ </table>
+</center> </p>
+
+<blockquote>
+<p>Please note that you should <strong>not</strong> add semi-colon ( <strong>;</strong> ) at the end of each parameter statement</p>
+</blockquote>
+
+<p>Some examples: </p>
+<div class="highlight"><pre><code class="sql language-sql" data-lang="sql">    <span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span> <span class="n">spark_demo</span><span class="p">.</span><span class="n">ts</span><span class="p">(</span>
+        <span class="k">key</span> <span class="nb">int</span> <span class="k">PRIMARY</span> <span class="k">KEY</span><span class="p">,</span>
+        <span class="n">value</span> <span class="nb">text</span>
+    <span class="p">);</span>
+    <span class="k">TRUNCATE</span> <span class="n">spark_demo</span><span class="p">.</span><span class="n">ts</span><span class="p">;</span>
+
+    <span class="o">#</span> <span class="k">Timestamp</span> <span class="k">in</span> <span class="n">the</span> <span class="n">past</span>
+    <span class="o">@</span><span class="k">timestamp</span><span class="o">=</span><span class="mi">10</span>
+
+    <span class="o">#</span> <span class="k">Force</span> <span class="k">timestamp</span> <span class="n">directly</span> <span class="k">in</span> <span class="n">the</span> <span class="k">first</span> <span class="k">insert</span>
+    <span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">spark_demo</span><span class="p">.</span><span class="n">ts</span><span class="p">(</span><span class="k">key</span><span class="p">,</span><span class="n">value</span><span class="p">)</span> <span class="k">VALUES</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="s1">&#39;first insert&#39;</span><span class="p">)</span> <span class="k">USING</span> <span class="k">TIMESTAMP</span> <span class="mi">100</span><span class="p">;</span>
+
+    <span class="o">#</span> <span class="k">Select</span> <span class="k">some</span> <span class="k">data</span> <span class="k">to</span> <span class="n">make</span> <span class="n">the</span> <span class="n">clock</span> <span class="n">turn</span>
+    <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">spark_demo</span><span class="p">.</span><span class="n">albums</span> <span class="k">LIMIT</span> <span class="mi">100</span><span class="p">;</span>
+
+    <span class="o">#</span> <span class="n">Now</span> <span class="k">insert</span> <span class="k">using</span> <span class="n">the</span> <span class="k">timestamp</span> <span class="k">parameter</span> <span class="k">set</span> <span class="k">at</span> <span class="n">the</span> <span class="n">beginning</span><span class="p">(</span><span class="mi">10</span><span class="p">)</span>
+    <span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">spark_demo</span><span class="p">.</span><span class="n">ts</span><span class="p">(</span><span class="k">key</span><span class="p">,</span><span class="n">value</span><span class="p">)</span> <span class="k">VALUES</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="s1">&#39;second insert&#39;</span><span class="p">);</span>
+
+    <span class="o">#</span> <span class="k">Check</span> <span class="k">for</span> <span class="n">the</span> <span class="k">result</span><span class="p">.</span> <span class="n">You</span> <span class="n">should</span> <span class="n">see</span> <span class="s1">&#39;first insert&#39;</span>
+    <span class="k">SELECT</span> <span class="n">value</span> <span class="k">FROM</span> <span class="n">spark_demo</span><span class="p">.</span><span class="n">ts</span> <span class="k">WHERE</span> <span class="k">key</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span>
+</code></pre></div>
+<p>Some remarks about query parameters:</p>
+
+<blockquote>
+<ol>
+<li><strong>many</strong> query parameters can be set in the same paragraph</li>
+<li>if the <strong>same</strong> query parameter is set many time with different values, the interpreter only take into account the first value</li>
+<li>each query parameter applies to <strong>all CQL statements</strong> in the same paragraph, unless you override the option using plain CQL text (like forcing timestamp with the USING clause)</li>
+<li>the order of each query parameter with regard to CQL statement does not matter</li>
+</ol>
+</blockquote>
+
+<hr/>
+
+<h2>10. Support for Prepared Statements</h2>
+
+<p>For performance reason, it is better to prepare statements before-hand and reuse them later by providing bound values. 
+This interpreter provides 3 commands to handle prepared and bound statements: </p>
+
+<ol>
+<li><strong>@prepare</strong></li>
+<li><strong>@bind</strong></li>
+<li><strong>@remove_prepared</strong></li>
+</ol>
+
+<p>Example: </p>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">    @prepare[statement_name]=...
+
+    @bind[statement_name]=’text’, 1223, ’2015-07-30 12:00:01’, null, true, [‘list_item1’, ’list_item2’]
+
+    @bind[statement_name_with_no_bound_value]
+
+    @remove_prepare[statement_name]
+</code></pre></div>
+<p><br/></p>
+
+<h4>a. @prepare</h4>
+
+<p><br/>
+You can use the syntax <em>&quot;@prepare[statement</em>name]=SELECT ...&quot;_ to create a prepared statement. 
+The <em>statement</em>name_ is <strong>mandatory</strong> because the interpreter prepares the given statement with the Java driver and 
+saves the generated prepared statement in an <strong>internal hash map</strong>, using the provided <em>statement</em>name_ as search key.</p>
+
+<blockquote>
+<p>Please note that this internal prepared statement map is shared with <strong>all notebooks</strong> and <strong>all paragraphs</strong> because 
+there is only one instance of the interpreter for Cassandra</p>
+
+<p>If the interpreter encounters <strong>many</strong> @prepare for the <strong>same <em>statement</em>name_ (key)</strong>, only the <strong>first</strong> statement will be taken into account.</p>
+</blockquote>
+
+<p>Example: </p>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">    @prepare[select]=SELECT * FROM spark_demo.albums LIMIT ?
+
+    @prepare[select]=SELECT * FROM spark_demo.artists LIMIT ?
+</code></pre></div>
+<p>For the above example, the prepared statement is <em>SELECT * FROM spark</em>demo.albums LIMIT ?<em>. 
+_SELECT * FROM spark</em>demo.artists LIMIT ?_ is ignored because an entry already exists in the prepared statements map with the key select. </p>
+
+<p>In the context of <strong>Zeppelin</strong>, a notebook can be scheduled to be executed at regular interval, 
+thus it is necessary to <strong>avoid re-preparing many time the same statement (considered an anti-pattern)</strong>.
+<br/>
+<br/></p>
+
+<h4>b. @bind</h4>
+
+<p><br/>
+Once the statement is prepared (possibly in a separated notebook/paragraph). You can bind values to it: </p>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">    @bind[select_first]=10
+</code></pre></div>
+<p>Bound values are not mandatory for the <strong>@bind</strong> statement. However if you provide bound values, they need to comply to some syntax:</p>
+
+<ul>
+<li>String values should be enclosed between simple quotes ( ‘ )</li>
+<li>Date values should be enclosed between simple quotes ( ‘ ) and respect the formats:
+
+<ol>
+<li>yyyy-MM-dd HH:MM:ss</li>
+<li>yyyy-MM-dd HH:MM:ss.SSS</li>
+</ol></li>
+<li><strong>null</strong> is parsed as-is</li>
+<li><strong>boolean</strong> (true|false) are parsed as-is</li>
+<li>collection values must follow the <strong><a href="http://docs.datastax.com/en/cql/3.1/cql/cql_using/use_collections_c.html">standard CQL syntax</a></strong>:
+
+<ul>
+<li>list: [‘list<em>item1’, ’list</em>item2’, ...]</li>
+<li>set: {‘set<em>item1’, ‘set</em>item2’, …}</li>
+<li>map: {‘key1’: ‘val1’, ‘key2’: ‘val2’, …}</li>
+</ul></li>
+<li><strong>tuple</strong> values should be enclosed between parenthesis (see <strong><a href="http://docs.datastax.com/en/cql/3.1/cql/cql_reference/tupleType.html">Tuple CQL syntax</a></strong>): (‘text’, 123, true)</li>
+<li><strong>udt</strong> values should be enclosed between brackets (see <strong><a href="http://docs.datastax.com/en/cql/3.1/cql/cql_using/cqlUseUDT.html">UDT CQL syntax</a></strong>): {stree<em>name: ‘Beverly Hills’, number: 104, zip</em>code: 90020, state: ‘California’, …}</li>
+</ul>
+
+<blockquote>
+<p>It is possible to use the @bind statement inside a batch:</p>
+<div class="highlight"><pre><code class="sql language-sql" data-lang="sql">    <span class="k">BEGIN</span> <span class="n">BATCH</span>
+        <span class="o">@</span><span class="n">bind</span><span class="p">[</span><span class="n">insert_user</span><span class="p">]</span><span class="o">=</span><span class="s1">&#39;jdoe&#39;</span><span class="p">,</span><span class="s1">&#39;John DOE&#39;</span>
+        <span class="k">UPDATE</span> <span class="n">users</span> <span class="k">SET</span> <span class="n">age</span> <span class="o">=</span> <span class="mi">27</span> <span class="k">WHERE</span> <span class="n">login</span><span class="o">=</span><span class="s1">&#39;hsue&#39;</span><span class="p">;</span>
+    <span class="n">APPLY</span> <span class="n">BATCH</span><span class="p">;</span>
+</code></pre></div></blockquote>
+
+<p><br/></p>
+
+<h4>c. @remove_prepare</h4>
+
+<p><br/>
+To avoid for a prepared statement to stay forever in the prepared statement map, you can use the 
+<strong>@remove<em>prepare[statement</em>name]</strong> syntax to remove it. 
+Removing a non-existing prepared statement yields no error.</p>
+
+<hr/>
+
+<h2>11. Using Dynamic Forms</h2>
+
+<p>Instead of hard-coding your CQL queries, it is possible to use the mustache syntax ( <strong>{{ }}</strong> ) to inject simple value or multiple choices forms. </p>
+
+<p>The syntax for simple parameter is: <strong>{{input_Label=default value}}</strong>. The default value is mandatory because the first time the paragraph is executed, 
+we launch the CQL query before rendering the form so at least one value should be provided. </p>
+
+<p>The syntax for multiple choices parameter is: <strong>{{input_Label=value1 | value2 | … | valueN }}</strong>. By default the first choice is used for CQL query 
+the first time the paragraph is executed. </p>
+
+<p>Example: </p>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">#Secondary index on performer style
+SELECT name, country, performer
+FROM spark_demo.performers
+WHERE name=&#39;{{performer=Sheryl Crow|Doof|Fanfarlo|Los Paranoia}}&#39;
+AND styles CONTAINS &#39;{{style=Rock}}&#39;;
+</code></pre></div>
+<p>In the above example, the first CQL query will be executed for <em>performer=&#39;Sheryl Crow&#39; AND style=&#39;Rock&#39;</em>. 
+For subsequent queries, you can change the value directly using the form. </p>
+
+<blockquote>
+<p>Please note that we enclosed the <strong>{{ }}</strong> block between simple quotes ( <strong>&#39;</strong> ) because Cassandra expects a String here. 
+We could have also use the <strong>{{style=&#39;Rock&#39;}}</strong> syntax but this time, the value displayed on the form is <strong><em>&#39;Rock&#39;</em></strong> and not <strong><em>Rock</em></strong>. </p>
+</blockquote>
+
+<p>It is also possible to use dynamic forms for <strong>prepared statements</strong>: </p>
+<div class="highlight"><pre><code class="text language-text" data-lang="text">@bind[select]==&#39;{{performer=Sheryl Crow|Doof|Fanfarlo|Los Paranoia}}&#39;, &#39;{{style=Rock}}&#39;
+</code></pre></div>
+<hr/>
+
+<h2>12. Execution parallelism and shared states</h2>
+
+<p>It is possible to execute many paragraphs in parallel. However, at the back-end side, we’re still using synchronous queries. 
+<em>Asynchronous execution</em> is only possible when it is possible to return a <code>Future</code> value in the <code>InterpreterResult</code>. 
+It may be an interesting proposal for the <strong>Zeppelin</strong> project.</p>
+
+<p>Another caveat is that the same <code>com.datastax.driver.core.Session</code> object is used for <strong>all</strong> notebooks and paragraphs.
+Consequently, if you use the <strong>USE <em>keyspace name</em>;</strong> statement to log into a keyspace, it will change the keyspace for
+<strong>all current users</strong> of the <strong>Cassandra</strong> interpreter because we only create 1 <code>com.datastax.driver.core.Session</code> object
+per instance of <strong>Cassandra</strong> interpreter.</p>
+
+<p>The same remark does apply to the <strong>prepared statement hash map</strong>, it is shared by <strong>all users</strong> using the same instance of <strong>Cassandra</strong> interpreter.</p>
+
+<p>Until <strong>Zeppelin</strong> offers a real multi-users separation, there is a work-around to segregate user environment and states: 
+<em>create different <strong>Cassandra</strong> interpreter instances</em></p>
+
+<p>For this, first go to the <strong>Interpreter</strong> menu and click on the <strong>Create</strong> button
+<br/>
+<br/>
+<center>
+  <img src="/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInstance.png" alt="Create Interpreter">
+</center></p>
+
+<p>In the interpreter creation form, put <strong>cass-instance2</strong> as <strong>Name</strong> and select the <strong>cassandra</strong> 
+in the interpreter drop-down list<br>
+<br/>
+<br/>
+<center>
+  <img src="/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterName.png" alt="Interpreter Name">
+</center>                         </p>
+
+<p>Click on <strong>Save</strong> to create the new interpreter instance. Now you should be able to see it in the interpreter list.</p>
+
+<p><br/>
+<br/>
+<center>
+  <img src="/assets/themes/zeppelin/img/docs-img/cassandra-NewInterpreterInList.png" alt="Interpreter In List">
+</center>                         </p>
+
+<p>Go back to your notebook and click on the <strong>Gear</strong> icon to configure interpreter bindings.
+You should be able to see and select the <strong>cass-instance2</strong> interpreter instance in the available
+interpreter list instead of the standard <strong>cassandra</strong> instance.</p>
+
+<p><br/>
+<br/>
+<center>
+  <img src="/assets/themes/zeppelin/img/docs-img/cassandra-InterpreterInstanceSelection.png" alt="Interpreter Instance Selection">
+</center> </p>
+
+<hr/>
+
+<h2>13. Interpreter Configuration</h2>
+
+<p>To configure the <strong>Cassandra</strong> interpreter, go to the <strong>Interpreter</strong> menu and scroll down to change the parameters.
+The <strong>Cassandra</strong> interpreter is using the official <strong><a href="https://github.com/datastax/java-driver">Cassandra Java Driver</a></strong> and most of the parameters are used
+to configure the Java driver</p>
+
+<p>Below are the configuration parameters and their default value.</p>
+
+<p><table class="table-configuration">
+   <tr>
+     <th>Property Name</th>
+     <th>Description</th>
+     <th>Default Value</th>
+   </tr>
+   <tr>
+     <td>cassandra.cluster</td>
+     <td>Name of the Cassandra cluster to connect to</td>
+     <td>Test Cluster</td>
+   </tr>
+   <tr>
+     <td>cassandra.compression.protocol</td>
+     <td>On wire compression. Possible values are: NONE, SNAPPY, LZ4</td>
+     <td>NONE</td>
+   </tr>
+   <tr>
+     <td>cassandra.credentials.username</td>
+     <td>If security is enable, provide the login</td>
+     <td>none</td>
+   </tr>
+   <tr>
+     <td>cassandra.credentials.password</td>
+     <td>If security is enable, provide the password</td>
+     <td>none</td>
+   </tr>
+   <tr>
+     <td>cassandra.hosts</td>
+     <td>
+        Comma separated Cassandra hosts (DNS name or IP address).
+        <br/>
+        Ex: &#39;192.168.0.12,node2,node3&#39;
+      </td>
+     <td>localhost</td>
+   </tr>
+   <tr>
+     <td>cassandra.interpreter.parallelism</td>
+     <td>Number of concurrent paragraphs(queries block) that can be executed</td>
+     <td>10</td>
+   </tr>
+   <tr>
+     <td>cassandra.keyspace</td>
+     <td>
+        Default keyspace to connect to.
+        <strong>
+          It is strongly recommended to let the default value
+          and prefix the table name with the actual keyspace
+          in all of your queries
+        </strong>
+     </td>
+     <td>system</td>
+   </tr>
+   <tr>
+     <td>cassandra.load.balancing.policy</td>
+     <td>
+        Load balancing policy. Default = <em>new TokenAwarePolicy(new DCAwareRoundRobinPolicy())</em>
+        To Specify your own policy, provide the <strong>fully qualify class name (FQCN)</strong> of your policy.
+        At runtime the interpreter will instantiate the policy using 
+        <strong>Class.forName(FQCN)</strong>
+     </td>
+     <td>DEFAULT</td>
+   </tr>
+   <tr>
+     <td>cassandra.max.schema.agreement.wait.second</td>
+     <td>Cassandra max schema agreement wait in second</td>
+     <td>10</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.core.connection.per.host.local</td>
+     <td>Protocol V2 and below default = 2. Protocol V3 and above default = 1</td>
+     <td>2</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.core.connection.per.host.remote</td>
+     <td>Protocol V2 and below default = 1. Protocol V3 and above default = 1</td>
+     <td>1</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.heartbeat.interval.seconds</td>
+     <td>Cassandra pool heartbeat interval in secs</td>
+     <td>30</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.idle.timeout.seconds</td>
+     <td>Cassandra idle time out in seconds</td>
+     <td>120</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.max.connection.per.host.local</td>
+     <td>Protocol V2 and below default = 8. Protocol V3 and above default = 1</td>
+     <td>8</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.max.connection.per.host.remote</td>
+     <td>Protocol V2 and below default = 2. Protocol V3 and above default = 1</td>
+     <td>2</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.max.request.per.connection.local</td>
+     <td>Protocol V2 and below default = 128. Protocol V3 and above default = 1024</td>
+     <td>128</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.max.request.per.connection.remote</td>
+     <td>Protocol V2 and below default = 128. Protocol V3 and above default = 256</td>
+     <td>128</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.new.connection.threshold.local</td>
+     <td>Protocol V2 and below default = 100. Protocol V3 and above default = 800</td>
+     <td>100</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.new.connection.threshold.remote</td>
+     <td>Protocol V2 and below default = 100. Protocol V3 and above default = 200</td>
+     <td>100</td>
+   </tr>
+   <tr>
+     <td>cassandra.pooling.pool.timeout.millisecs</td>
+     <td>Cassandra pool time out in millisecs</td>
+     <td>5000</td>
+   </tr>
+   <tr>
+     <td>cassandra.protocol.version</td>
+     <td>Cassandra binary protocol version</td>
+     <td>3</td>
+   </tr>
+   <tr>
+     <td>cassandra.query.default.consistency</td>
+     <td>
+      Cassandra query default consistency level
+      <br/>
+      Available values: ONE, TWO, THREE, QUORUM, LOCAL<em>ONE, LOCAL</em>QUORUM, EACH<em>QUORUM, ALL
+     </td>
+     <td>ONE</td>
+   </tr>
+   <tr>
+     <td>cassandra.query.default.fetchSize</td>
+     <td>Cassandra query default fetch size</td>
+     <td>5000</td>
+   </tr>
+   <tr>
+     <td>cassandra.query.default.serial.consistency</td>
+     <td>
+      Cassandra query default serial consistency level
+      <br/>
+      Available values: SERIAL, LOCAL</em>SERIAL
+     </td>
+     <td>SERIAL</td>
+   </tr>
+   <tr>
+     <td>cassandra.reconnection.policy</td>
+     <td>
+        Cassandra Reconnection Policy.
+        Default = new ExponentialReconnectionPolicy(1000, 10 * 60 * 1000)
+        To Specify your own policy, provide the <strong>fully qualify class name (FQCN)</strong> of your policy.
+        At runtime the interpreter will instantiate the policy using 
+        <strong>Class.forName(FQCN)</strong>
+     </td>
+     <td>DEFAULT</td>
+   </tr>
+   <tr>
+     <td>cassandra.retry.policy</td>
+     <td>
+        Cassandra Retry Policy.
+        Default = DefaultRetryPolicy.INSTANCE
+        To Specify your own policy, provide the <strong>fully qualify class name (FQCN)</strong> of your policy.
+        At runtime the interpreter will instantiate the policy using 
+        <strong>Class.forName(FQCN)</strong>
+     </td>
+     <td>DEFAULT</td>
+   </tr>
+   <tr>
+     <td>cassandra.socket.connection.timeout.millisecs</td>
+     <td>Cassandra socket default connection timeout in millisecs</td>
+     <td>500</td>
+   </tr>
+   <tr>
+     <td>cassandra.socket.read.timeout.millisecs</td>
+     <td>Cassandra socket read timeout in millisecs</td>
+     <td>12000</td>
+   </tr>
+   <tr>
+     <td>cassandra.socket.tcp.no_delay</td>
+     <td>Cassandra socket TCP no delay</td>
+     <td>true</td>
+   </tr>
+   <tr>
+     <td>cassandra.speculative.execution.policy</td>
+     <td>
+        Cassandra Speculative Execution Policy.
+        Default = NoSpeculativeExecutionPolicy.INSTANCE
+        To Specify your own policy, provide the <strong>fully qualify class name (FQCN)</strong> of your policy.
+        At runtime the interpreter will instantiate the policy using 
+        <strong>Class.forName(FQCN)</strong>
+     </td>
+     <td>DEFAULT</td>
+   </tr>
+ </table></p>
+
+<hr/>
+
+<h2>14. Bugs &amp; Contacts</h2>
+
+<p>If you encounter a bug for this interpreter, please create a <strong><a href="https://issues.apache.org/jira/browse/ZEPPELIN-382?jql=project%20%3D%20ZEPPELIN">JIRA</a></strong> ticket and ping me on Twitter
+ at <strong><a href="https://twitter.com/doanduyhai">@doanduyhai</a></strong></p>
+
+  </div>
+</div>
+
+
+      <hr>
+      <footer>
+        <!-- <p>&copy; 2015 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.incubator.apache.org');
+  ga('require', 'linkid', 'linkid.js');
+  ga('send', 'pageview');
+
+</script>
+
+
+
+  </body>
+</html>
+



Mime
View raw message