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">'jdoe'</span><span class="p">,</span><span
class="s1">'John DOE'</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">'jdoe'</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">'jlennon'</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">'jdoe'</span><span class="p">,</span><span
class="s1">'John DOE'</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">'jdoe'</span><span class="p">,</span><span
class="s1">'BASIC'</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">'jdoe'</span><span class="p">,</span><span
class="s1">'John DOE'</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">'hsue'</span><span class="p">,</span><span
class="s1">'Helen SUE'</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 & 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">'jdoe'</span><span class="p">,</span><span
class="s1">'John DOE'</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">'hsue'</span><span class="p">,</span><span
class="s1">'Helen SUE'</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
<keyspace<em>name>;</strong></td>
+ <td>List all existing user defined functions in the given keyspace</td>
+ </tr><br>
+ <tr>
+ <td nowrap><strong>DESCRIBE AGGREGATES
<keyspace</em>name>;</strong></td>
+ <td>List all existing user defined aggregates in the given keyspace</td>
+ </tr><br>
+ <tr>
+ <td nowrap><strong>DESCRIBE KEYSPACE
<keyspace<em>name>;</strong></td>
+ <td>Describe the given keyspace configuration and all its table details
(name, columns, ...)</td>
+ </tr><br>
+ <tr>
+ <td nowrap><strong>DESCRIBE TABLE
(<keyspace</em>name>).<table<em>name>;</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
(<keyspace</em>name>).<type<em>name>;</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
(<keyspace</em>name>).<function<em>name>;</strong></td>
+ <td>Describe the given user defined function. The keyspace is
optional</td>
+ </tr><br>
+ <tr>
+ <td nowrap><strong>DESCRIBE AGGREGATE
(<keyspace</em>name>).<aggregate_name>;</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">'first insert'</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">'second insert'</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">'first insert'</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>"@prepare[statement</em>name]=SELECT
..."_ 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">'jdoe'</span><span class="p">,</span><span
class="s1">'John DOE'</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">'hsue'</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='{{performer=Sheryl Crow|Doof|Fanfarlo|Los Paranoia}}'
+AND styles CONTAINS '{{style=Rock}}';
+</code></pre></div>
+<p>In the above example, the first CQL query will be executed for
<em>performer='Sheryl Crow' AND style='Rock'</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>'</strong> ) because Cassandra expects a String
here.
+We could have also use the <strong>{{style='Rock'}}</strong> syntax
but this time, the value displayed on the form is
<strong><em>'Rock'</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]=='{{performer=Sheryl Crow|Doof|Fanfarlo|Los
Paranoia}}', '{{style=Rock}}'
+</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: '192.168.0.12,node2,node3'
+ </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 & 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>© 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>
+
