Modified: zeppelin/site/docs/0.8.2/search.html URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.8.2/search.html?rev=1867692&r1=1867691&r2=1867692&view=diff ============================================================================== --- zeppelin/site/docs/0.8.2/search.html (original) +++ zeppelin/site/docs/0.8.2/search.html Sun Sep 29 07:25:59 2019 @@ -3,7 +3,7 @@ <html lang="en"> <head> <meta charset="utf-8"> - <title>Apache Zeppelin 0.8.0 Documentation: </title> + <title>Apache Zeppelin 0.8.2 Documentation: </title> <meta name="author" content="The Apache Software Foundation"> @@ -18,9 +18,9 @@ <link href="//maxcdn.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.min.css" rel="stylesheet"> <!-- Le styles --> - <link href="/docs/0.8.0/assets/themes//bootstrap/css/bootstrap.css" rel="stylesheet"> - <link href="/docs/0.8.0/assets/themes//css/style.css?body=1" rel="stylesheet" type="text/css"> - <link href="/docs/0.8.0/assets/themes//css/syntax.css" rel="stylesheet" type="text/css" media="screen" /> + <link href="/docs/0.8.2/assets/themes//bootstrap/css/bootstrap.css" rel="stylesheet"> + <link href="/docs/0.8.2/assets/themes//css/style.css?body=1" rel="stylesheet" type="text/css"> + <link href="/docs/0.8.2/assets/themes//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"> @@ -31,16 +31,16 @@ <!-- Js --> <script src="https://code.jquery.com/jquery-1.10.2.min.js";></script> - <script src="/docs/0.8.0/assets/themes//bootstrap/js/bootstrap.min.js"></script> - <script src="/docs/0.8.0/assets/themes//js/docs.js"></script> - <script src="/docs/0.8.0/assets/themes//js/anchor.min.js"></script> - <script src="/docs/0.8.0/assets/themes//js/toc.js"></script> - <script src="/docs/0.8.0/assets/themes//js/lunr.min.js"></script> - <script src="/docs/0.8.0/assets/themes//js/search.js"></script> + <script src="/docs/0.8.2/assets/themes//bootstrap/js/bootstrap.min.js"></script> + <script src="/docs/0.8.2/assets/themes//js/docs.js"></script> + <script src="/docs/0.8.2/assets/themes//js/anchor.min.js"></script> + <script src="/docs/0.8.2/assets/themes//js/toc.js"></script> + <script src="/docs/0.8.2/assets/themes//js/lunr.min.js"></script> + <script src="/docs/0.8.2/assets/themes//js/search.js"></script> <!-- atom & rss feed --> - <link href="/docs/0.8.0/atom.xml" type="application/atom+xml" rel="alternate" title="Sitewide ATOM Feed"> - <link href="/docs/0.8.0/rss.xml" type="application/rss+xml" rel="alternate" title="Sitewide RSS Feed"> + <link href="/docs/0.8.2/atom.xml" type="application/atom+xml" rel="alternate" title="Sitewide ATOM Feed"> + <link href="/docs/0.8.2/rss.xml" type="application/rss+xml" rel="alternate" title="Sitewide RSS Feed"> </head> <body> @@ -56,11 +56,11 @@ </button> <div class="navbar-brand"> <a class="navbar-brand-main" href="http://zeppelin.apache.org";> - <img src="/docs/0.8.0/assets/themes/zeppelin/img/zeppelin_logo.png" width="50" + <img src="/docs/0.8.2/assets/themes/zeppelin/img/zeppelin_logo.png" width="50" style="margin-top: -2px;" alt="I'm zeppelin"> <span style="margin-left: 5px; font-size: 27px;">Zeppelin</span> - <a class="navbar-brand-version" href="/docs/0.8.0" - style="font-size: 15px; color: white;"> 0.8.0 + <a class="navbar-brand-version" href="/docs/0.8.2" + style="font-size: 15px; color: white;"> 0.8.2 </a> </a> </div> @@ -71,13 +71,13 @@ <a href="#" data-toggle="dropdown" class="dropdown-toggle">Quick Start <b class="caret"></b></a> <ul class="dropdown-menu"> <li class="title"><span>Getting Started</span></li> - <li><a href="/docs/0.8.0/quickstart/install.html">Install</a></li> - <li><a href="/docs/0.8.0/quickstart/explore_ui.html">Explore UI</a></li> - <li><a href="/docs/0.8.0/quickstart/tutorial.html">Tutorial</a></li> - <li role="separator" class="divider"></li> - <li><a href="/docs/0.8.0/quickstart/spark_with_zeppelin.html">Spark with Zeppelin</a></li> - <li><a href="/docs/0.8.0/quickstart/sql_with_zeppelin.html">SQL with Zeppelin</a></li> - <li><a href="/docs/0.8.0/quickstart/python_with_zeppelin.html">Python with Zeppelin</a></li> + <li><a href="/docs/0.8.2/quickstart/install.html">Install</a></li> + <li><a href="/docs/0.8.2/quickstart/explore_ui.html">Explore UI</a></li> + <li><a href="/docs/0.8.2/quickstart/tutorial.html">Tutorial</a></li> + <li role="separator" class="divider"></li> + <li><a href="/docs/0.8.2/quickstart/spark_with_zeppelin.html">Spark with Zeppelin</a></li> + <li><a href="/docs/0.8.2/quickstart/sql_with_zeppelin.html">SQL with Zeppelin</a></li> + <li><a href="/docs/0.8.2/quickstart/python_with_zeppelin.html">Python with Zeppelin</a></li> </ul> </li> @@ -85,41 +85,41 @@ <a href="#" data-toggle="dropdown" class="dropdown-toggle">Usage<b class="caret"></b></a> <ul class="dropdown-menu scrollable-menu"> <li class="title"><span>Dynamic Form</span></li> - <li><a href="/docs/0.8.0/usage/dynamic_form/intro.html">What is Dynamic Form?</a></li> + <li><a href="/docs/0.8.2/usage/dynamic_form/intro.html">What is Dynamic Form?</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Display System</span></li> - <li><a href="/docs/0.8.0/usage/display_system/basic.html#text">Text Display</a></li> - <li><a href="/docs/0.8.0/usage/display_system/basic.html#html">HTML Display</a></li> - <li><a href="/docs/0.8.0/usage/display_system/basic.html#table">Table Display</a></li> - <li><a href="/docs/0.8.0/usage/display_system/basic.html#network">Network Display</a></li> - <li><a href="/docs/0.8.0/usage/display_system/angular_backend.html">Angular Display using Backend API</a></li> - <li><a href="/docs/0.8.0/usage/display_system/angular_frontend.html">Angular Display using Frontend API</a></li> + <li><a href="/docs/0.8.2/usage/display_system/basic.html#text">Text Display</a></li> + <li><a href="/docs/0.8.2/usage/display_system/basic.html#html">HTML Display</a></li> + <li><a href="/docs/0.8.2/usage/display_system/basic.html#table">Table Display</a></li> + <li><a href="/docs/0.8.2/usage/display_system/basic.html#network">Network Display</a></li> + <li><a href="/docs/0.8.2/usage/display_system/angular_backend.html">Angular Display using Backend API</a></li> + <li><a href="/docs/0.8.2/usage/display_system/angular_frontend.html">Angular Display using Frontend API</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Interpreter</span></li> - <li><a href="/docs/0.8.0/usage/interpreter/overview.html">Overview</a></li> - <li><a href="/docs/0.8.0/usage/interpreter/interpreter_binding_mode.html">Interpreter Binding Mode</a></li> - <li><a href="/docs/0.8.0/usage/interpreter/user_impersonation.html">User Impersonation</a></li> - <li><a href="/docs/0.8.0/usage/interpreter/dependency_management.html">Dependency Management</a></li> - <li><a href="/docs/0.8.0/usage/interpreter/installation.html">Installing Interpreters</a></li> - <!--<li><a href="/docs/0.8.0/usage/interpreter/dynamic_loading.html">Dynamic Interpreter Loading (Experimental)</a></li>--> - <li><a href="/docs/0.8.0/usage/interpreter/execution_hooks.html">Execution Hooks (Experimental)</a></li> + <li><a href="/docs/0.8.2/usage/interpreter/overview.html">Overview</a></li> + <li><a href="/docs/0.8.2/usage/interpreter/interpreter_binding_mode.html">Interpreter Binding Mode</a></li> + <li><a href="/docs/0.8.2/usage/interpreter/user_impersonation.html">User Impersonation</a></li> + <li><a href="/docs/0.8.2/usage/interpreter/dependency_management.html">Dependency Management</a></li> + <li><a href="/docs/0.8.2/usage/interpreter/installation.html">Installing Interpreters</a></li> + <!--<li><a href="/docs/0.8.2/usage/interpreter/dynamic_loading.html">Dynamic Interpreter Loading (Experimental)</a></li>--> + <li><a href="/docs/0.8.2/usage/interpreter/execution_hooks.html">Execution Hooks (Experimental)</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Other Features</span></li> - <li><a href="/docs/0.8.0/usage/other_features/publishing_paragraphs.html">Publishing Paragraphs</a></li> - <li><a href="/docs/0.8.0/usage/other_features/personalized_mode.html">Personalized Mode</a></li> - <li><a href="/docs/0.8.0/usage/other_features/customizing_homepage.html">Customizing Zeppelin Homepage</a></li> - <li><a href="/docs/0.8.0/usage/other_features/notebook_actions.html">Notebook Actions</a></li> - <li><a href="/docs/0.8.0/usage/other_features/cron_scheduler.html">Cron Scheduler</a></li> - <li><a href="/docs/0.8.0/usage/other_features/zeppelin_context.html">Zeppelin Context</a></li> + <li><a href="/docs/0.8.2/usage/other_features/publishing_paragraphs.html">Publishing Paragraphs</a></li> + <li><a href="/docs/0.8.2/usage/other_features/personalized_mode.html">Personalized Mode</a></li> + <li><a href="/docs/0.8.2/usage/other_features/customizing_homepage.html">Customizing Zeppelin Homepage</a></li> + <li><a href="/docs/0.8.2/usage/other_features/notebook_actions.html">Notebook Actions</a></li> + <li><a href="/docs/0.8.2/usage/other_features/cron_scheduler.html">Cron Scheduler</a></li> + <li><a href="/docs/0.8.2/usage/other_features/zeppelin_context.html">Zeppelin Context</a></li> <li role="separator" class="divider"></li> <li class="title"><span>REST API</span></li> - <li><a href="/docs/0.8.0/usage/rest_api/interpreter.html">Interpreter API</a></li> - <li><a href="/docs/0.8.0/usage/rest_api/zeppelin_server.html">Zeppelin Server API</a></li> - <li><a href="/docs/0.8.0/usage/rest_api/notebook.html">Notebook API</a></li> - <li><a href="/docs/0.8.0/usage/rest_api/notebook_repository.html">Notebook Repository API</a></li> - <li><a href="/docs/0.8.0/usage/rest_api/configuration.html">Configuration API</a></li> - <li><a href="/docs/0.8.0/usage/rest_api/credential.html">Credential API</a></li> - <li><a href="/docs/0.8.0/usage/rest_api/helium.html">Helium API</a></li> + <li><a href="/docs/0.8.2/usage/rest_api/interpreter.html">Interpreter API</a></li> + <li><a href="/docs/0.8.2/usage/rest_api/zeppelin_server.html">Zeppelin Server API</a></li> + <li><a href="/docs/0.8.2/usage/rest_api/notebook.html">Notebook API</a></li> + <li><a href="/docs/0.8.2/usage/rest_api/notebook_repository.html">Notebook Repository API</a></li> + <li><a href="/docs/0.8.2/usage/rest_api/configuration.html">Configuration API</a></li> + <li><a href="/docs/0.8.2/usage/rest_api/credential.html">Credential API</a></li> + <li><a href="/docs/0.8.2/usage/rest_api/helium.html">Helium API</a></li> </ul> </li> @@ -127,37 +127,37 @@ <a href="#" data-toggle="dropdown" class="dropdown-toggle">Setup<b class="caret"></b></a> <ul class="dropdown-menu scrollable-menu"> <li class="title"><span>Basics</span></li> - <li><a href="/docs/0.8.0/setup/basics/how_to_build.html">How to Build Zeppelin</a></li> - <li><a href="/docs/0.8.0/setup/basics/multi_user_support.html">Multi-user Support</a></li> + <li><a href="/docs/0.8.2/setup/basics/how_to_build.html">How to Build Zeppelin</a></li> + <li><a href="/docs/0.8.2/setup/basics/multi_user_support.html">Multi-user Support</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Deployment</span></li> - <!--<li><a href="/docs/0.8.0/setup/deployment/docker.html">Docker Image for Zeppelin</a></li>--> - <li><a href="/docs/0.8.0/setup/deployment/spark_cluster_mode.html#spark-standalone-mode">Spark Cluster Mode: Standalone</a></li> - <li><a href="/docs/0.8.0/setup/deployment/spark_cluster_mode.html#spark-on-yarn-mode">Spark Cluster Mode: YARN</a></li> - <li><a href="/docs/0.8.0/setup/deployment/spark_cluster_mode.html#spark-on-mesos-mode">Spark Cluster Mode: Mesos</a></li> - <li><a href="/docs/0.8.0/setup/deployment/flink_and_spark_cluster.html">Zeppelin with Flink, Spark Cluster</a></li> - <li><a href="/docs/0.8.0/setup/deployment/cdh.html">Zeppelin on CDH</a></li> - <li><a href="/docs/0.8.0/setup/deployment/virtual_machine.html">Zeppelin on VM: Vagrant</a></li> + <!--<li><a href="/docs/0.8.2/setup/deployment/docker.html">Docker Image for Zeppelin</a></li>--> + <li><a href="/docs/0.8.2/setup/deployment/spark_cluster_mode.html#spark-standalone-mode">Spark Cluster Mode: Standalone</a></li> + <li><a href="/docs/0.8.2/setup/deployment/spark_cluster_mode.html#spark-on-yarn-mode">Spark Cluster Mode: YARN</a></li> + <li><a href="/docs/0.8.2/setup/deployment/spark_cluster_mode.html#spark-on-mesos-mode">Spark Cluster Mode: Mesos</a></li> + <li><a href="/docs/0.8.2/setup/deployment/flink_and_spark_cluster.html">Zeppelin with Flink, Spark Cluster</a></li> + <li><a href="/docs/0.8.2/setup/deployment/cdh.html">Zeppelin on CDH</a></li> + <li><a href="/docs/0.8.2/setup/deployment/virtual_machine.html">Zeppelin on VM: Vagrant</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Security</span></li> - <li><a href="/docs/0.8.0/setup/security/authentication_nginx.html">HTTP Basic Auth using NGINX</a></li> - <li><a href="/docs/0.8.0/setup/security/shiro_authentication.html">Shiro Authentication</a></li> - <li><a href="/docs/0.8.0/setup/security/notebook_authorization.html">Notebook Authorization</a></li> - <li><a href="/docs/0.8.0/setup/security/datasource_authorization.html">Data Source Authorization</a></li> - <li><a href="/docs/0.8.0/setup/security/http_security_headers.html">HTTP Security Headers</a></li> + <li><a href="/docs/0.8.2/setup/security/authentication_nginx.html">HTTP Basic Auth using NGINX</a></li> + <li><a href="/docs/0.8.2/setup/security/shiro_authentication.html">Shiro Authentication</a></li> + <li><a href="/docs/0.8.2/setup/security/notebook_authorization.html">Notebook Authorization</a></li> + <li><a href="/docs/0.8.2/setup/security/datasource_authorization.html">Data Source Authorization</a></li> + <li><a href="/docs/0.8.2/setup/security/http_security_headers.html">HTTP Security Headers</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Notebook Storage</span></li> - <li><a href="/docs/0.8.0/setup/storage/storage.html#notebook-storage-in-local-git-repository">Git Storage</a></li> - <li><a href="/docs/0.8.0/setup/storage/storage.html#notebook-storage-in-s3">S3 Storage</a></li> - <li><a href="/docs/0.8.0/setup/storage/storage.html#notebook-storage-in-azure">Azure Storage</a></li> - <li><a href="/docs/0.8.0/setup/storage/storage.html#notebook-storage-in-zeppelinhub">ZeppelinHub Storage</a></li> - <li><a href="/docs/0.8.0/setup/storage/storage.html#notebook-storage-in-mongodb">MongoDB Storage</a></li> + <li><a href="/docs/0.8.2/setup/storage/storage.html#notebook-storage-in-local-git-repository">Git Storage</a></li> + <li><a href="/docs/0.8.2/setup/storage/storage.html#notebook-storage-in-s3">S3 Storage</a></li> + <li><a href="/docs/0.8.2/setup/storage/storage.html#notebook-storage-in-azure">Azure Storage</a></li> + <li><a href="/docs/0.8.2/setup/storage/storage.html#notebook-storage-in-zeppelinhub">ZeppelinHub Storage</a></li> + <li><a href="/docs/0.8.2/setup/storage/storage.html#notebook-storage-in-mongodb">MongoDB Storage</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Operation</span></li> - <li><a href="/docs/0.8.0/setup/operation/configuration.html">Configuration</a></li> - <li><a href="/docs/0.8.0/setup/operation/proxy_setting.html">Proxy Setting</a></li> - <li><a href="/docs/0.8.0/setup/operation/upgrading.html">Upgrading</a></li> - <li><a href="/docs/0.8.0/setup/operation/trouble_shooting.html">Trouble Shooting</a></li> + <li><a href="/docs/0.8.2/setup/operation/configuration.html">Configuration</a></li> + <li><a href="/docs/0.8.2/setup/operation/proxy_setting.html">Proxy Setting</a></li> + <li><a href="/docs/0.8.2/setup/operation/upgrading.html">Upgrading</a></li> + <li><a href="/docs/0.8.2/setup/operation/trouble_shooting.html">Trouble Shooting</a></li> </ul> </li> @@ -165,55 +165,55 @@ <a href="#" data-toggle="dropdown" class="dropdown-toggle">Interpreter <b class="caret"></b></a> <ul class="dropdown-menu scrollable-menu"> <li class="title"><span>Interpreters</span></li> - <li><a href="/docs/0.8.0/usage/interpreter/overview.html">Overview</a></li> + <li><a href="/docs/0.8.2/usage/interpreter/overview.html">Overview</a></li> <li role="separator" class="divider"></li> - <li><a href="/docs/0.8.0/interpreter/spark.html">Spark</a></li> - <li><a href="/docs/0.8.0/interpreter/jdbc.html">JDBC</a></li> - <li><a href="/docs/0.8.0/interpreter/python.html">Python</a></li> - <li role="separator" class="divider"></li> - <li><a href="/docs/0.8.0/interpreter/alluxio.html">Alluxio</a></li> - <li><a href="/docs/0.8.0/interpreter/beam.html">Beam</a></li> - <li><a href="/docs/0.8.0/interpreter/bigquery.html">BigQuery</a></li> - <li><a href="/docs/0.8.0/interpreter/cassandra.html">Cassandra</a></li> - <li><a href="/docs/0.8.0/interpreter/elasticsearch.html">Elasticsearch</a></li> - <li><a href="/docs/0.8.0/interpreter/flink.html">Flink</a></li> - <li><a href="/docs/0.8.0/interpreter/geode.html">Geode</a></li> - <li><a href="/docs/0.8.0/interpreter/groovy.html">Groovy</a></li> - <li><a href="/docs/0.8.0/interpreter/hbase.html">HBase</a></li> - <li><a href="/docs/0.8.0/interpreter/hdfs.html">HDFS</a></li> - <li><a href="/docs/0.8.0/interpreter/hive.html">Hive</a></li> - <li><a href="/docs/0.8.0/interpreter/ignite.html">Ignite</a></li> - <li><a href="/docs/0.8.0/interpreter/kylin.html">Kylin</a></li> - <li><a href="/docs/0.8.0/interpreter/lens.html">Lens</a></li> - <li><a href="/docs/0.8.0/interpreter/livy.html">Livy</a></li> - <li><a href="/docs/0.8.0/interpreter/markdown.html">Markdown</a></li> - <li><a href="/docs/0.8.0/interpreter/neo4j.html">Neo4j</a></li> - <li><a href="/docs/0.8.0/interpreter/pig.html">Pig</a></li> - <li><a href="/docs/0.8.0/interpreter/postgresql.html">Postgresql, HAWQ</a></li> - <li><a href="/docs/0.8.0/interpreter/r.html">R</a></li> - <li><a href="/docs/0.8.0/interpreter/scalding.html">Scalding</a></li> - <li><a href="/docs/0.8.0/interpreter/scio.html">Scio</a></li> - <li><a href="/docs/0.8.0/interpreter/shell.html">Shell</a></li> + <li><a href="/docs/0.8.2/interpreter/spark.html">Spark</a></li> + <li><a href="/docs/0.8.2/interpreter/jdbc.html">JDBC</a></li> + <li><a href="/docs/0.8.2/interpreter/python.html">Python</a></li> + <li role="separator" class="divider"></li> + <li><a href="/docs/0.8.2/interpreter/alluxio.html">Alluxio</a></li> + <li><a href="/docs/0.8.2/interpreter/beam.html">Beam</a></li> + <li><a href="/docs/0.8.2/interpreter/bigquery.html">BigQuery</a></li> + <li><a href="/docs/0.8.2/interpreter/cassandra.html">Cassandra</a></li> + <li><a href="/docs/0.8.2/interpreter/elasticsearch.html">Elasticsearch</a></li> + <li><a href="/docs/0.8.2/interpreter/flink.html">Flink</a></li> + <li><a href="/docs/0.8.2/interpreter/geode.html">Geode</a></li> + <li><a href="/docs/0.8.2/interpreter/groovy.html">Groovy</a></li> + <li><a href="/docs/0.8.2/interpreter/hbase.html">HBase</a></li> + <li><a href="/docs/0.8.2/interpreter/hdfs.html">HDFS</a></li> + <li><a href="/docs/0.8.2/interpreter/hive.html">Hive</a></li> + <li><a href="/docs/0.8.2/interpreter/ignite.html">Ignite</a></li> + <li><a href="/docs/0.8.2/interpreter/kylin.html">Kylin</a></li> + <li><a href="/docs/0.8.2/interpreter/lens.html">Lens</a></li> + <li><a href="/docs/0.8.2/interpreter/livy.html">Livy</a></li> + <li><a href="/docs/0.8.2/interpreter/markdown.html">Markdown</a></li> + <li><a href="/docs/0.8.2/interpreter/neo4j.html">Neo4j</a></li> + <li><a href="/docs/0.8.2/interpreter/pig.html">Pig</a></li> + <li><a href="/docs/0.8.2/interpreter/postgresql.html">Postgresql, HAWQ</a></li> + <li><a href="/docs/0.8.2/interpreter/r.html">R</a></li> + <li><a href="/docs/0.8.2/interpreter/scalding.html">Scalding</a></li> + <li><a href="/docs/0.8.2/interpreter/scio.html">Scio</a></li> + <li><a href="/docs/0.8.2/interpreter/shell.html">Shell</a></li> </ul> </li> <li> <a href="#" data-toggle="dropdown" class="dropdown-toggle">More<b class="caret"></b></a> <ul class="dropdown-menu scrollable-menu" style="right: 0; left: auto;"> <li class="title"><span>Extending Zeppelin</span></li> - <li><a href="/docs/0.8.0/development/writing_zeppelin_interpreter.html">Writing Zeppelin Interpreter</a></li> + <li><a href="/docs/0.8.2/development/writing_zeppelin_interpreter.html">Writing Zeppelin Interpreter</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Helium (Experimental)</span></li> - <li><a href="/docs/0.8.0/development/helium/overview.html">Overview</a></li> - <li><a href="/docs/0.8.0/development/helium/writing_application.html">Writing Helium Application</a></li> - <li><a href="/docs/0.8.0/development/helium/writing_spell.html">Writing Helium Spell</a></li> - <li><a href="/docs/0.8.0/development/helium/writing_visualization_basic.html">Writing Helium Visualization: Basics</a></li> - <li><a href="/docs/0.8.0/development/helium/writing_visualization_transformation.html">Writing Helium Visualization: Transformation</a></li> + <li><a href="/docs/0.8.2/development/helium/overview.html">Overview</a></li> + <li><a href="/docs/0.8.2/development/helium/writing_application.html">Writing Helium Application</a></li> + <li><a href="/docs/0.8.2/development/helium/writing_spell.html">Writing Helium Spell</a></li> + <li><a href="/docs/0.8.2/development/helium/writing_visualization_basic.html">Writing Helium Visualization: Basics</a></li> + <li><a href="/docs/0.8.2/development/helium/writing_visualization_transformation.html">Writing Helium Visualization: Transformation</a></li> <li role="separator" class="divider"></li> <li class="title"><span>Contributing to Zeppelin</span></li> - <li><a href="/docs/0.8.0/setup/basics/how_to_build.html">How to Build Zeppelin</a></li> - <li><a href="/docs/0.8.0/development/contribution/useful_developer_tools.html">Useful Developer Tools</a></li> - <li><a href="/docs/0.8.0/development/contribution/how_to_contribute_code.html">How to Contribute (code)</a></li> - <li><a href="/docs/0.8.0/development/contribution/how_to_contribute_website.html">How to Contribute (website)</a></li> + <li><a href="/docs/0.8.2/setup/basics/how_to_build.html">How to Build Zeppelin</a></li> + <li><a href="/docs/0.8.2/development/contribution/useful_developer_tools.html">Useful Developer Tools</a></li> + <li><a href="/docs/0.8.2/development/contribution/how_to_contribute_code.html">How to Contribute (code)</a></li> + <li><a href="/docs/0.8.2/development/contribution/how_to_contribute_website.html">How to Contribute (website)</a></li> <li role="separator" class="divider"></li> <li class="title"><span>External Resources</span></li> <li><a target="_blank" href="">Mailing List</a></li> @@ -222,7 +222,7 @@ </ul> </li> <li> - <a href="/docs/0.8.0/search.html" class="nav-search-link"> + <a href="/docs/0.8.2/search.html" class="nav-search-link"> <span class="fa fa-search nav-search-icon"></span> </a> </li> @@ -263,7 +263,7 @@ limitations under the License. </span> <br/> -<form role="search" action="/docs/0.8.0/search.html" id="site_search"> +<form role="search" action="/docs/0.8.2/search.html" id="site_search"> <div class="input-group" id="search-container"> <input type="text" class="form-control" size="16px" name="q" placeholder="Search all pages" id="search_box"> <span class="input-group-btn">
Modified: zeppelin/site/docs/0.8.2/search_data.json URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.8.2/search_data.json?rev=1867692&r1=1867691&r2=1867692&view=diff ============================================================================== --- zeppelin/site/docs/0.8.2/search_data.json (original) +++ zeppelin/site/docs/0.8.2/search_data.json Sun Sep 29 07:25:59 2019 @@ -81,7 +81,7 @@ "interpreter-cassandra": { "title": "Cassandra CQL Interpreter for Apache Zeppelin", - "content" : "Cassandra CQL Interpreter for Apache Zeppelin Name Class Description %cassandra CassandraInterpreter Provides interpreter for Apache Cassandra CQL query language Enabling Cassandra InterpreterIn a notebook, to enable the Cassandra interpreter, click on the Gear icon and select Cassandra Using the Cassandra InterpreterIn a paragraph, use %cassandra to select the Cassandra interpreter and then input all commands.To access the interactive help, type HELP; Interpreter CommandsThe Cassandra interpreter accepts the following commands Command Type Command Name Description Help command HELP Display the interactive help menu Schema commands DESCRIBE KEYSPACE, DESCRIBE CLUSTER, DESCRIBE TABLES ... Custom commands to describe the Cassandra schema Option commands @consistency, @retryPolicy, @fetchSize ... Inject runtime options to all statements in the parag raph Prepared statement commands @prepare, @bind, @remove_prepared Let you register a prepared command and re-use it later by injecting bound values Native CQL statements All CQL-compatible statements (SELECT, INSERT, CREATE, ...) All CQL statements are executed directly against the Cassandra server CQL statementsThis interpreter is compatible with any CQL statement supported by Cassandra. Ex:INSERT INTO users(login,name) VALUES(&#39;jdoe&#39;,&#39;John DOE&#39;);SELECT * FROM users WHERE login=&#39;jdoe&#39;;Each statement should be separated by a semi-colon ( ; ) except the special commands below:@prepare@bind@remove_prepare@consistency@serialConsistency@timestamp@retryPolicy@fetchSize@requestTimeOutMulti-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:USE spark_demo;SELECT * FROM albums_by_country LIMIT 1; SELECT * FROM co untries LIMIT 1;SELECT *FROM artistsWHERE login=&#39;jlennon&#39;;Batch statements are supported and can span multiple lines, as well as DDL (CREATE/ALTER/DROP) statements:BEGIN BATCH INSERT INTO users(login,name) VALUES(&#39;jdoe&#39;,&#39;John DOE&#39;); INSERT INTO users_preferences(login,account_type) VALUES(&#39;jdoe&#39;,&#39;BASIC&#39;);APPLY BATCH;CREATE TABLE IF NOT EXISTS test( key int PRIMARY KEY, value text);CQL statements are case-insensitive (except for column names and values). This means that the following statements are equivalent and valid:INSERT INTO users(login,name) VALUES(&#39;jdoe&#39;,&#39;John DOE&#39;);Insert into users(login,name) vAlues(&#39;hsue&#39;,&#39;Helen SUE&#39;);The complete list of all CQL statements and versions can be found below: Cassandra Version Documentation Link 3.x http://docs.datastax.com/en/cql/3.3/cql/cqlInt ro.html 2.2 http://docs.datastax.com/en/cql/3.3/cql/cqlIntro.html 2.1 &amp; 2.0 http://docs.datastax.com/en/cql/3.1/cql/cqlintroc.html 1.2 http://docs.datastax.com/en/cql/3.0/cql/aboutCQL.html Comments in statementsIt is possible to add comments between statements. Single line comments start with the hash sign (#) or double slashes (//). Multi-line comments are enclosed between /** and **/. Ex:#Single line comment style 1INSERT INTO users(login,name) VALUES(&#39;jdoe&#39;,&#39;John DOE&#39;);//Single line comment style 2/** Multi line comments **/Insert into users(login,name) vAlues(&#39;hsue&#39;,&#39;Helen SUE&#39;);Syntax ValidationThe interpreters is shipped with a built-in syntax validator. This validator only checks for basic syntax errors.All CQL-related syntax validation is delegated directl y to CassandraMost of the time, syntax errors are due to missing semi-colons between statements or typo errors.Schema commandsTo make schema discovery easier and more interactive, the following commands are supported: Command Description DESCRIBE CLUSTER; Show the current cluster name and its partitioner DESCRIBE KEYSPACES; List all existing keyspaces in the cluster and their configuration (replication factor, durable write ...) DESCRIBE TABLES; List all existing keyspaces in the cluster and for each, all the tables name DESCRIBE TYPES; List all existing keyspaces in the cluster and for each, all the user-defined types name DESCRIBE FUNCTIONS; List all existing keyspaces in the cluster and for each, all the functions name DESCRIBE AGGREGATES; List all existing keyspaces in the cluster and for each, all the aggregates name DESCRIBE MATERIALIZED VIEWS; List all existing keyspa ces in the cluster and for each, all the materialized views name DESCRIBE KEYSPACE &lt;keyspacename&gt;; Describe the given keyspace configuration and all its table details (name, columns, ...) DESCRIBE TABLE (&lt;keyspacename&gt;).&lt;tablename&gt;; 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 DESCRIBE TYPE (&lt;keyspacename&gt;).&lt;typename&gt;; 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 DESCRIBE FUNCTION (&lt;keyspacename&gt;).&lt;functionname&gt;; Describe the given function. 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 function is found, an error message is raised DESCRIBE AGGREGATE (&lt;keyspacename&gt;).&lt;aggregatename&gt;; Describe the given aggregate. 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 aggregate is found, an error message is raised DESCRIBE MATERIALIZED VIEW (&lt;keyspacename&gt;).&lt;view_name&gt;; Describe the given view. 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 view is found, an error message is raised The schema objects (cluster, keyspace, table, type, function and aggregate) are disp layed 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. Runtime ParametersSometimes 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: Parameter Syntax Description Consistency Level @consistency=value Apply the given consistency level to all queries in the paragraph Serial Consistency Level @serialConsistency=value Apply the given serial consistency level to all queries in the paragraph Timestamp @timestamp=long value Apply the given timestamp to all queries in the paragraph. Please note that timestamp value passed directly in CQL statement will override this value Retry Policy @retryPolicy=value Apply the given retry policy to all queries in t he paragraph Fetch Size @fetchSize=integer value Apply the given fetch size to all queries in the paragraph Request Time Out @requestTimeOut=integer value Apply the given request timeout in millisecs to all queries in the paragraph Some parameters only accept restricted values: Parameter Possible Values Consistency Level ALL, ANY, ONE, TWO, THREE, QUORUM, LOCALONE, LOCALQUORUM, EACHQUORUM Serial Consistency Level SERIAL, LOCALSERIAL Timestamp Any long value Retry Policy DEFAULT, DOWNGRADINGCONSISTENCY, FALLTHROUGH, LOGGINGDEFAULT, LOGGINGDOWNGRADING, LOGGINGFALLTHROUGH Fetch Size Any integer value Please note that you should not add semi-colon ( ; ) at the end of each parameter statementSome examples:CREATE TABLE IF NOT EXISTS spark_demo.ts( key int PRIMARY KEY, value text);TRUNCATE spark_demo.ts;// Timestamp in the past@timestamp=10// Force timestamp dir ectly in the first insertINSERT INTO spark_demo.ts(key,value) VALUES(1,&#39;first insert&#39;) USING TIMESTAMP 100;// Select some data to make the clock turnSELECT * FROM spark_demo.albums LIMIT 100;// Now insert using the timestamp parameter set at the beginning(10)INSERT INTO spark_demo.ts(key,value) VALUES(1,&#39;second insert&#39;);// Check for the result. You should see &#39;first insert&#39;SELECT value FROM spark_demo.ts WHERE key=1;Some remarks about query parameters:many query parameters can be set in the same paragraphif the same query parameter is set many time with different values, the interpreter only take into account the first valueeach query parameter applies to all CQL statements in the same paragraph, unless you override the option using plain CQL text (like forcing timestamp with the USING clause)the order of each query parameter with regard to CQL statement does not matterSupport for Prepared StatementsFor 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:@prepare@bind@remove_preparedExample:@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]@prepareYou can use the syntax &quot;@prepare[statement-name]=SELECT...&quot; to create a prepared statement.The statement-name is mandatory because the interpreter prepares the given statement with the Java driver andsaves the generated prepared statement in an internal hash map, using the provided statement-name as search key.Please note that this internal prepared statement map is shared with all notebooks and all paragraphs becausethere is only one instance of the interpreter for CassandraIf the interpreter encounters many @prepare for the same statement-name (key), only the first statement will be taken into account.Example:@prepare[select]=SELECT * FROM spark_demo.albums LIMIT ?@prepare[select]=SELECT * FROM spark_demo.artists LIMIT ?For the above example, the prepared statement is SELECT * FROM spark_demo.albums LIMIT ?.SELECT * FROM spark_demo.artists LIMIT ? is ignored because an entry already exists in the prepared statements map with the key select.In the context of Zeppelin, a notebook can be scheduled to be executed at regular interval,thus it is necessary to avoid re-preparing many time the same statement (considered an anti-pattern).@bindOnce the statement is prepared (possibly in a separated notebook/paragraph). You can bind values to it:@bind[select_first]=10Bound values are not mandatory for the @bind statement. However if you provide bound values, they need to comply to some syntax:String values should be enclosed between simple quotes (&#39;)Date values should be enclosed between simple quotes (&#3 9;) and respect the formats (full list is in the documentation):yyyy-MM-dd HH:MM:ssyyyy-MM-dd HH:MM:ss.SSSnull is parsed as-isboolean (true|false) are parsed as-iscollection values must follow the standard CQL syntax:list: [&#39;listitem1&#39;, &#39;listitem2&#39;, ...]set: {&#39;setitem1&#39;, &#39;setitem2&#39;, â¦}map: {&#39;key1&#39;: &#39;val1&#39;, &#39;key2&#39;: &#39;val2&#39;, â¦}tuple values should be enclosed between parenthesis (see Tuple CQL syntax): (&#39;text&#39;, 123, true)udt values should be enclosed between brackets (see UDT CQL syntax): {streename: &#39;Beverly Hills&#39;, number: 104, zipcode: 90020, state: &#39;California&#39;, â¦}It is possible to use the @bind statement inside a batch:BEGIN BATCH @bind[insert_user]=&#39;jdoe&#39;,&#39;John DOE&#39; UPDATE users SET age = 27 WHERE login=&#39;hsue&#39;;APPLY BATCH;@remove_prepareTo av oid for a prepared statement to stay forever in the prepared statement map, you can use the@remove_prepare[statement-name] syntax to remove it.Removing a non-existing prepared statement yields no error.Using Dynamic FormsInstead of hard-coding your CQL queries, it is possible to use [Zeppelin dynamic form] syntax to inject simple value or multiple choices forms.The legacy mustache syntax ( {{ }} ) to bind input text and select form is still supported but is deprecated and will be removed in future releases.LegacyThe syntax for simple parameter is: {{input_Label=default value}}. 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.The syntax for multiple choices parameter is: {{input_Label=value1 | value2 | ⦠| valueN }}. By default the first choice is used for CQL querythe first time the paragraph is executed.Example:#Secondary index on performer styleSELECT nam e, country, performerFROM spark_demo.performersWHERE name=&#39;${performer=Sheryl Crow|Doof|Fanfarlo|Los Paranoia}&#39;AND styles CONTAINS &#39;${style=Rock}&#39;;In the above example, the first CQL query will be executed for performer=&#39;Sheryl Crow&#39; AND style=&#39;Rock&#39;.For subsequent queries, you can change the value directly using the form.Please note that we enclosed the ${ } block between simple quotes ( &#39; ) because Cassandra expects a String here.We could have also use the ${style=&#39;Rock&#39;} syntax but this time, the value displayed on the form is &#39;Rock&#39; and not Rock.It is also possible to use dynamic forms for prepared statements:@bind[select]==&#39;${performer=Sheryl Crow|Doof|Fanfarlo|Los Paranoia}&#39;, &#39;${style=Rock}&#39;Shared statesIt is possible to execute many paragraphs in parallel. However, at the back-end side, we&#39;re still using synchronous queries.Asynchrono us execution is only possible when it is possible to return a Future value in the InterpreterResult.It may be an interesting proposal for the Zeppelin project.Recently, Zeppelin allows you to choose the level of isolation for your interpreters (see [Interpreter Binding Mode] ).Long story short, you have 3 available bindings:shared : same JVM and same Interpreter instance for all notesscoped : same JVM but different Interpreter instances, one for each noteisolated: different JVM running a single Interpreter instance, one JVM for each noteUsing the shared binding, the same com.datastax.driver.core.Session object is used for all notes and paragraphs.Consequently, if you use the USE keyspace_name; statement to log into a keyspace, it will change the keyspace forall current users of the Cassandra interpreter because we only create 1 com.datastax.driver.core.Session objectper instance of Cassandra interpreter.The same remark does apply to the prepared statement hash map, it is shared by a ll users using the same instance of Cassandra interpreter.When using scoped binding, in the same JVM Zeppelin will create multiple instances of the Cassandra interpreter, thus multiple com.datastax.driver.core.Session objects. Beware of resource and memory usage using this binding ! The isolated mode is the most extreme and will create as many JVM/com.datastax.driver.core.Session object as there are distinct notes.Interpreter ConfigurationTo configure the Cassandra interpreter, go to the Interpreter menu and scroll down to change the parameters.The Cassandra interpreter is using the official Cassandra Java Driver and most of the parameters are usedto configure the Java driverBelow are the configuration parameters and their default values. Property Name Description Default Value cassandra.cluster Name of the Cassandra cluster to connect to Test Cluster cassandra.compression.protocol On wire compression. Possible values are: NONE, SNAPPY, LZ4 NONE cassandra.credentials.username If security is enable, provide the login none cassandra.credentials.password If security is enable, provide the password none cassandra.hosts Comma separated Cassandra hosts (DNS name or IP address). Ex: 192.168.0.12,node2,node3 localhost cassandra.interpreter.parallelism Number of concurrent paragraphs(queries block) that can be executed 10 cassandra.keyspace Default keyspace to connect to. It is strongly recommended to let the default value and prefix the table name with the actual keyspace in all of your queries system cassandra.load.balancing.policy Load balancing policy. Default = new TokenAwarePolicy(new DCAwareRoundRobinPolicy()) To Specify your own policy, provide the fully qualify class name (FQCN) of your policy. At runti me the interpreter will instantiate the policy using Class.forName(FQCN) DEFAULT cassandra.max.schema.agreement.wait.second Cassandra max schema agreement wait in second 10 cassandra.pooling.core.connection.per.host.local Protocol V2 and below default = 2. Protocol V3 and above default = 1 2 cassandra.pooling.core.connection.per.host.remote Protocol V2 and below default = 1. Protocol V3 and above default = 1 1 cassandra.pooling.heartbeat.interval.seconds Cassandra pool heartbeat interval in secs 30 cassandra.pooling.idle.timeout.seconds Cassandra idle time out in seconds 120 cassandra.pooling.max.connection.per.host.local Protocol V2 and below default = 8. Protocol V3 and above default = 1 8 cassandra.pooling.max.connection.per.host.remote Protocol V2 and below default = 2. Protocol V3 and above default = 1 2 cassandra.pooling.max.re quest.per.connection.local Protocol V2 and below default = 128. Protocol V3 and above default = 1024 128 cassandra.pooling.max.request.per.connection.remote Protocol V2 and below default = 128. Protocol V3 and above default = 256 128 cassandra.pooling.new.connection.threshold.local Protocol V2 and below default = 100. Protocol V3 and above default = 800 100 cassandra.pooling.new.connection.threshold.remote Protocol V2 and below default = 100. Protocol V3 and above default = 200 100 cassandra.pooling.pool.timeout.millisecs Cassandra pool time out in millisecs 5000 cassandra.protocol.version Cassandra binary protocol version 4 cassandra.query.default.consistency Cassandra query default consistency level Available values: ONE, TWO, THREE, QUORUM, LOCAL_ONE, LOCAL_QUORUM, EACH_QUORUM, ALL ONE cassandra.query.default.fetchSize Cassandra q uery default fetch size 5000 cassandra.query.default.serial.consistency Cassandra query default serial consistency level Available values: SERIAL, LOCAL_SERIAL SERIAL cassandra.reconnection.policy Cassandra Reconnection Policy. Default = new ExponentialReconnectionPolicy(1000, 10 * 60 * 1000) To Specify your own policy, provide the fully qualify class name (FQCN) of your policy. At runtime the interpreter will instantiate the policy using Class.forName(FQCN) DEFAULT cassandra.retry.policy Cassandra Retry Policy. Default = DefaultRetryPolicy.INSTANCE To Specify your own policy, provide the fully qualify class name (FQCN) of your policy. At runtime the interpreter will instantiate the policy using Class.forName(FQCN) DEFAULT cassandra.socket.connection.timeout.millisecs Cassandra socket default connection timeou t in millisecs 500 cassandra.socket.read.timeout.millisecs Cassandra socket read timeout in millisecs 12000 cassandra.socket.tcp.no_delay Cassandra socket TCP no delay true cassandra.speculative.execution.policy Cassandra Speculative Execution Policy. Default = NoSpeculativeExecutionPolicy.INSTANCE To Specify your own policy, provide the fully qualify class name (FQCN) of your policy. At runtime the interpreter will instantiate the policy using Class.forName(FQCN) DEFAULT cassandra.ssl.enabled Enable support for connecting to the Cassandra configured with SSL. To connect to Cassandra configured with SSL use true and provide a truststore file and password with following options. false cassandra.ssl.truststore.path Filepath for the truststore file to use for connection to Cassandra with SSL. cassandra. ssl.truststore.password Password for the truststore file to use for connection to Cassandra with SSL. Change Log3.0 (Zeppelin 0.8.0) :Update documentationUpdate interactive documentationAdd support for binary protocol V4Implement new @requestTimeOut runtime optionUpgrade Java driver version to 3.0.1Allow interpreter to add dynamic forms programmatically when using FormType.SIMPLEAllow dynamic form using default Zeppelin syntaxFixing typo on FallThroughPolicyLook for data in AngularObjectRegistry before creating dynamic formAdd missing support for ALTER statements2.0 (Zeppelin 0.8.0) :Update help menu and add changelogAdd Support for User Defined Functions, User Defined Aggregates and Materialized ViewsUpgrade Java driver version to 3.0.0-rc11.0 (Zeppelin 0.5.5-incubating) :Initial versionBugs &amp; ContactsIf you encounter a bug for this interpreter, please create a JIRA ticket and ping me on Twitter at @doanduyhaiZeppelin Dynamic FormInterpreter Binding Mode", + "content" : "Cassandra CQL Interpreter for Apache Zeppelin Name Class Description %cassandra CassandraInterpreter Provides interpreter for Apache Cassandra CQL query language Enabling Cassandra InterpreterIn a notebook, to enable the Cassandra interpreter, click on the Gear icon and select Cassandra Using the Cassandra InterpreterIn a paragraph, use %cassandra to select the Cassandra interpreter and then input all commands.To access the interactive help, type HELP; Interpreter CommandsThe Cassandra interpreter accepts the following commands Command Type Command Name Description Help command HELP Display the interactive help menu Schema commands DESCRIBE KEYSPACE, DESCRIBE CLUSTER, DESCRIBE TABLES ... Custom commands to describe the Cassandra schema Option commands @consistency, @retryPolicy, @fetchSize ... Inject runtime options to all statements in the parag raph Prepared statement commands @prepare, @bind, @remove_prepared Let you register a prepared command and re-use it later by injecting bound values Native CQL statements All CQL-compatible statements (SELECT, INSERT, CREATE, ...) All CQL statements are executed directly against the Cassandra server CQL statementsThis interpreter is compatible with any CQL statement supported by Cassandra. Ex:INSERT INTO users(login,name) VALUES(&#39;jdoe&#39;,&#39;John DOE&#39;);SELECT * FROM users WHERE login=&#39;jdoe&#39;;Each statement should be separated by a semi-colon ( ; ) except the special commands below:@prepare@bind@remove_prepare@consistency@serialConsistency@timestamp@retryPolicy@fetchSize@requestTimeOutMulti-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:USE spark_demo;SELECT * FROM albums_by_country LIMIT 1; SELECT * FROM co untries LIMIT 1;SELECT *FROM artistsWHERE login=&#39;jlennon&#39;;Batch statements are supported and can span multiple lines, as well as DDL (CREATE/ALTER/DROP) statements:BEGIN BATCH INSERT INTO users(login,name) VALUES(&#39;jdoe&#39;,&#39;John DOE&#39;); INSERT INTO users_preferences(login,account_type) VALUES(&#39;jdoe&#39;,&#39;BASIC&#39;);APPLY BATCH;CREATE TABLE IF NOT EXISTS test( key int PRIMARY KEY, value text);CQL statements are case-insensitive (except for column names and values). This means that the following statements are equivalent and valid:INSERT INTO users(login,name) VALUES(&#39;jdoe&#39;,&#39;John DOE&#39;);Insert into users(login,name) vAlues(&#39;hsue&#39;,&#39;Helen SUE&#39;);The complete list of all CQL statements and versions can be found below: Cassandra Version Documentation Link 3.x http://docs.datastax.com/en/cql/3.3/cql/cqlInt ro.html 2.2 http://docs.datastax.com/en/cql/3.3/cql/cqlIntro.html 2.1 &amp; 2.0 http://docs.datastax.com/en/cql/3.1/cql/cqlintroc.html 1.2 http://docs.datastax.com/en/cql/3.0/cql/aboutCQL.html Comments in statementsIt is possible to add comments between statements. Single line comments start with the hash sign (#) or double slashes (//). Multi-line comments are enclosed between /** and **/. Ex:#Single line comment style 1INSERT INTO users(login,name) VALUES(&#39;jdoe&#39;,&#39;John DOE&#39;);//Single line comment style 2/** Multi line comments **/Insert into users(login,name) vAlues(&#39;hsue&#39;,&#39;Helen SUE&#39;);Syntax ValidationThe interpreters is shipped with a built-in syntax validator. This validator only checks for basic syntax errors.All CQL-related syntax validation is delegated directl y to CassandraMost of the time, syntax errors are due to missing semi-colons between statements or typo errors.Schema commandsTo make schema discovery easier and more interactive, the following commands are supported: Command Description DESCRIBE CLUSTER; Show the current cluster name and its partitioner DESCRIBE KEYSPACES; List all existing keyspaces in the cluster and their configuration (replication factor, durable write ...) DESCRIBE TABLES; List all existing keyspaces in the cluster and for each, all the tables name DESCRIBE TYPES; List all existing keyspaces in the cluster and for each, all the user-defined types name DESCRIBE FUNCTIONS; List all existing keyspaces in the cluster and for each, all the functions name DESCRIBE AGGREGATES; List all existing keyspaces in the cluster and for each, all the aggregates name DESCRIBE MATERIALIZED VIEWS; List all existing keyspa ces in the cluster and for each, all the materialized views name DESCRIBE KEYSPACE &lt;keyspacename&gt;; Describe the given keyspace configuration and all its table details (name, columns, ...) DESCRIBE TABLE (&lt;keyspacename&gt;).&lt;tablename&gt;; 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 DESCRIBE TYPE (&lt;keyspacename&gt;).&lt;typename&gt;; 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 DESCRIBE FUNCTION (&lt;keyspacename&gt;).&lt;functionname&gt;; Describe the given function. 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 function is found, an error message is raised DESCRIBE AGGREGATE (&lt;keyspacename&gt;).&lt;aggregatename&gt;; Describe the given aggregate. 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 aggregate is found, an error message is raised DESCRIBE MATERIALIZED VIEW (&lt;keyspacename&gt;).&lt;view_name&gt;; Describe the given view. 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 view is found, an error message is raised The schema objects (cluster, keyspace, table, type, function and aggregate) are disp layed 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. Runtime ParametersSometimes 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: Parameter Syntax Description Consistency Level @consistency=value Apply the given consistency level to all queries in the paragraph Serial Consistency Level @serialConsistency=value Apply the given serial consistency level to all queries in the paragraph Timestamp @timestamp=long value Apply the given timestamp to all queries in the paragraph. Please note that timestamp value passed directly in CQL statement will override this value Retry Policy @retryPolicy=value Apply the given retry policy to all queries in t he paragraph Fetch Size @fetchSize=integer value Apply the given fetch size to all queries in the paragraph Request Time Out @requestTimeOut=integer value Apply the given request timeout in millisecs to all queries in the paragraph Some parameters only accept restricted values: Parameter Possible Values Consistency Level ALL, ANY, ONE, TWO, THREE, QUORUM, LOCALONE, LOCALQUORUM, EACHQUORUM Serial Consistency Level SERIAL, LOCALSERIAL Timestamp Any long value Retry Policy DEFAULT, DOWNGRADINGCONSISTENCY, FALLTHROUGH, LOGGINGDEFAULT, LOGGINGDOWNGRADING, LOGGINGFALLTHROUGH Fetch Size Any integer value Please note that you should not add semi-colon ( ; ) at the end of each parameter statementSome examples:CREATE TABLE IF NOT EXISTS spark_demo.ts( key int PRIMARY KEY, value text);TRUNCATE spark_demo.ts;// Timestamp in the past@timestamp=10// Force timestamp dir ectly in the first insertINSERT INTO spark_demo.ts(key,value) VALUES(1,&#39;first insert&#39;) USING TIMESTAMP 100;// Select some data to make the clock turnSELECT * FROM spark_demo.albums LIMIT 100;// Now insert using the timestamp parameter set at the beginning(10)INSERT INTO spark_demo.ts(key,value) VALUES(1,&#39;second insert&#39;);// Check for the result. You should see &#39;first insert&#39;SELECT value FROM spark_demo.ts WHERE key=1;Some remarks about query parameters:many query parameters can be set in the same paragraphif the same query parameter is set many time with different values, the interpreter only take into account the first valueeach query parameter applies to all CQL statements in the same paragraph, unless you override the option using plain CQL text (like forcing timestamp with the USING clause)the order of each query parameter with regard to CQL statement does not matterSupport for Prepared StatementsFor 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:@prepare@bind@remove_preparedExample:@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]@prepareYou can use the syntax &quot;@prepare[statement-name]=SELECT...&quot; to create a prepared statement.The statement-name is mandatory because the interpreter prepares the given statement with the Java driver andsaves the generated prepared statement in an internal hash map, using the provided statement-name as search key.Please note that this internal prepared statement map is shared with all notebooks and all paragraphs becausethere is only one instance of the interpreter for CassandraIf the interpreter encounters many @prepare for the same statement-name (key), only the first statement will be taken into account.Example:@prepare[select]=SELECT * FROM spark_demo.albums LIMIT ?@prepare[select]=SELECT * FROM spark_demo.artists LIMIT ?For the above example, the prepared statement is SELECT * FROM spark_demo.albums LIMIT ?.SELECT * FROM spark_demo.artists LIMIT ? is ignored because an entry already exists in the prepared statements map with the key select.In the context of Zeppelin, a notebook can be scheduled to be executed at regular interval,thus it is necessary to avoid re-preparing many time the same statement (considered an anti-pattern).@bindOnce the statement is prepared (possibly in a separated notebook/paragraph). You can bind values to it:@bind[select_first]=10Bound values are not mandatory for the @bind statement. However if you provide bound values, they need to comply to some syntax:String values should be enclosed between simple quotes (&#39;)Date values should be enclosed between simple quotes (&#3 9;) and respect the formats (full list is in the documentation):yyyy-MM-dd HH:MM:ssyyyy-MM-dd HH:MM:ss.SSSnull is parsed as-isboolean (true|false) are parsed as-iscollection values must follow the standard CQL syntax:list: [&#39;listitem1&#39;, &#39;listitem2&#39;, ...]set: {&#39;setitem1&#39;, &#39;setitem2&#39;, â¦}map: {&#39;key1&#39;: &#39;val1&#39;, &#39;key2&#39;: &#39;val2&#39;, â¦}tuple values should be enclosed between parenthesis (see Tuple CQL syntax): (&#39;text&#39;, 123, true)udt values should be enclosed between brackets (see UDT CQL syntax): {streename: &#39;Beverly Hills&#39;, number: 104, zipcode: 90020, state: &#39;California&#39;, â¦}It is possible to use the @bind statement inside a batch:BEGIN BATCH @bind[insert_user]=&#39;jdoe&#39;,&#39;John DOE&#39; UPDATE users SET age = 27 WHERE login=&#39;hsue&#39;;APPLY BATCH;@remove_prepareTo av oid for a prepared statement to stay forever in the prepared statement map, you can use the@remove_prepare[statement-name] syntax to remove it.Removing a non-existing prepared statement yields no error.Using Dynamic FormsInstead of hard-coding your CQL queries, it is possible to use [Zeppelin dynamic form] syntax to inject simple value or multiple choices forms.The legacy mustache syntax ( {{ }} ) to bind input text and select form is still supported but is deprecated and will be removed in future releases.LegacyThe syntax for simple parameter is: {{input_Label=default value}}. 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.The syntax for multiple choices parameter is: {{input_Label=value1 | value2 | ⦠| valueN }}. By default the first choice is used for CQL querythe first time the paragraph is executed.Example:#Secondary index on performer styleSELECT nam e, country, performerFROM spark_demo.performersWHERE name=&#39;${performer=Sheryl Crow|Doof|Fanfarlo|Los Paranoia}&#39;AND styles CONTAINS &#39;${style=Rock}&#39;;In the above example, the first CQL query will be executed for performer=&#39;Sheryl Crow&#39; AND style=&#39;Rock&#39;.For subsequent queries, you can change the value directly using the form.Please note that we enclosed the ${ } block between simple quotes ( &#39; ) because Cassandra expects a String here.We could have also use the ${style=&#39;Rock&#39;} syntax but this time, the value displayed on the form is &#39;Rock&#39; and not Rock.It is also possible to use dynamic forms for prepared statements:@bind[select]==&#39;${performer=Sheryl Crow|Doof|Fanfarlo|Los Paranoia}&#39;, &#39;${style=Rock}&#39;Shared statesIt is possible to execute many paragraphs in parallel. However, at the back-end side, we&#39;re still using synchronous queries.Asynchrono us execution is only possible when it is possible to return a Future value in the InterpreterResult.It may be an interesting proposal for the Zeppelin project.Recently, Zeppelin allows you to choose the level of isolation for your interpreters (see [Interpreter Binding Mode] ).Long story short, you have 3 available bindings:shared : same JVM and same Interpreter instance for all notesscoped : same JVM but different Interpreter instances, one for each noteisolated: different JVM running a single Interpreter instance, one JVM for each noteUsing the shared binding, the same com.datastax.driver.core.Session object is used for all notes and paragraphs.Consequently, if you use the USE keyspace_name; statement to log into a keyspace, it will change the keyspace forall current users of the Cassandra interpreter because we only create 1 com.datastax.driver.core.Session objectper instance of Cassandra interpreter.The same remark does apply to the prepared statement hash map, it is shared by a ll users using the same instance of Cassandra interpreter.When using scoped binding, in the same JVM Zeppelin will create multiple instances of the Cassandra interpreter, thus multiple com.datastax.driver.core.Session objects. Beware of resource and memory usage using this binding ! The isolated mode is the most extreme and will create as many JVM/com.datastax.driver.core.Session object as there are distinct notes.Interpreter ConfigurationTo configure the Cassandra interpreter, go to the Interpreter menu and scroll down to change the parameters.The Cassandra interpreter is using the official Cassandra Java Driver and most of the parameters are usedto configure the Java driverBelow are the configuration parameters and their default values. Property Name Description Default Value cassandra.cluster Name of the Cassandra cluster to connect to Test Cluster cassandra.compression.protocol On wire compression. Possible values are: NONE, SNAPPY, LZ4 NONE cassandra.credentials.username If security is enable, provide the login none cassandra.credentials.password If security is enable, provide the password none cassandra.hosts Comma separated Cassandra hosts (DNS name or IP address). Ex: 192.168.0.12,node2,node3 localhost cassandra.interpreter.parallelism Number of concurrent paragraphs(queries block) that can be executed 10 cassandra.keyspace Default keyspace to connect to. It is strongly recommended to let the default value and prefix the table name with the actual keyspace in all of your queries system cassandra.load.balancing.policy Load balancing policy. Default = new TokenAwarePolicy(new DCAwareRoundRobinPolicy()) To Specify your own policy, provide the fully qualify class name (FQCN) of your policy. At runti me the interpreter will instantiate the policy using Class.forName(FQCN) DEFAULT cassandra.max.schema.agreement.wait.second Cassandra max schema agreement wait in second 10 cassandra.pooling.core.connection.per.host.local Protocol V2 and below default = 2. Protocol V3 and above default = 1 2 cassandra.pooling.core.connection.per.host.remote Protocol V2 and below default = 1. Protocol V3 and above default = 1 1 cassandra.pooling.heartbeat.interval.seconds Cassandra pool heartbeat interval in secs 30 cassandra.pooling.idle.timeout.seconds Cassandra idle time out in seconds 120 cassandra.pooling.max.connection.per.host.local Protocol V2 and below default = 8. Protocol V3 and above default = 1 8 cassandra.pooling.max.connection.per.host.remote Protocol V2 and below default = 2. Protocol V3 and above default = 1 2 cassandra.pooling.max.re quest.per.connection.local Protocol V2 and below default = 128. Protocol V3 and above default = 1024 128 cassandra.pooling.max.request.per.connection.remote Protocol V2 and below default = 128. Protocol V3 and above default = 256 128 cassandra.pooling.new.connection.threshold.local Protocol V2 and below default = 100. Protocol V3 and above default = 800 100 cassandra.pooling.new.connection.threshold.remote Protocol V2 and below default = 100. Protocol V3 and above default = 200 100 cassandra.pooling.pool.timeout.millisecs Cassandra pool time out in millisecs 5000 cassandra.protocol.version Cassandra binary protocol version 4 cassandra.query.default.consistency Cassandra query default consistency level Available values: ONE, TWO, THREE, QUORUM, LOCAL_ONE, LOCAL_QUORUM, EACH_QUORUM, ALL ONE cassandra.query.default.fetchSize Cassandra q uery default fetch size 5000 cassandra.query.default.serial.consistency Cassandra query default serial consistency level Available values: SERIAL, LOCAL_SERIAL SERIAL cassandra.reconnection.policy Cassandra Reconnection Policy. Default = new ExponentialReconnectionPolicy(1000, 10 * 60 * 1000) To Specify your own policy, provide the fully qualify class name (FQCN) of your policy. At runtime the interpreter will instantiate the policy using Class.forName(FQCN) DEFAULT cassandra.retry.policy Cassandra Retry Policy. Default = DefaultRetryPolicy.INSTANCE To Specify your own policy, provide the fully qualify class name (FQCN) of your policy. At runtime the interpreter will instantiate the policy using Class.forName(FQCN) DEFAULT cassandra.socket.connection.timeout.millisecs Cassandra socket default connection timeou t in millisecs 500 cassandra.socket.read.timeout.millisecs Cassandra socket read timeout in millisecs 12000 cassandra.socket.tcp.no_delay Cassandra socket TCP no delay true cassandra.speculative.execution.policy Cassandra Speculative Execution Policy. Default = NoSpeculativeExecutionPolicy.INSTANCE To Specify your own policy, provide the fully qualify class name (FQCN) of your policy. At runtime the interpreter will instantiate the policy using Class.forName(FQCN) DEFAULT cassandra.ssl.enabled Enable support for connecting to the Cassandra configured with SSL. To connect to Cassandra configured with SSL use true and provide a truststore file and password with following options. false cassandra.ssl.truststore.path Filepath for the truststore file to use for connection to Cassandra with SSL. cassandra. ssl.truststore.password Password for the truststore file to use for connection to Cassandra with SSL. Change Log3.0 (Zeppelin 0.8.2) :Update documentationUpdate interactive documentationAdd support for binary protocol V4Implement new @requestTimeOut runtime optionUpgrade Java driver version to 3.0.1Allow interpreter to add dynamic forms programmatically when using FormType.SIMPLEAllow dynamic form using default Zeppelin syntaxFixing typo on FallThroughPolicyLook for data in AngularObjectRegistry before creating dynamic formAdd missing support for ALTER statements2.0 (Zeppelin 0.8.2) :Update help menu and add changelogAdd Support for User Defined Functions, User Defined Aggregates and Materialized ViewsUpgrade Java driver version to 3.0.0-rc11.0 (Zeppelin 0.5.5-incubating) :Initial versionBugs &amp; ContactsIf you encounter a bug for this interpreter, please create a JIRA ticket and ping me on Twitter at @doanduyhaiZeppelin Dynamic FormInterpreter Binding Mode", "url": " /interpreter/cassandra", "group": "interpreter", "excerpt": "Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance."
