| |
| <!DOCTYPE html> |
| <html lang="en"> |
| <head> |
| <meta charset="utf-8"> |
| <title>Apache Zeppelin 0.8.2 Documentation: SQL with Zeppelin</title> |
| <meta name="description" content=""> |
| <meta name="author" content="The Apache Software Foundation"> |
| |
| <!-- Enable responsive viewport --> |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> |
| |
| <!-- Le HTML5 shim, for IE6-8 support of HTML elements --> |
| <!--[if lt IE 9]> |
| <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script> |
| <![endif]--> |
| |
| <link href="//maxcdn.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.min.css" rel="stylesheet"> |
| |
| <!-- Le styles --> |
| <link href="/docs/0.8.2/assets/themes/zeppelin/bootstrap/css/bootstrap.css" rel="stylesheet"> |
| <link href="/docs/0.8.2/assets/themes/zeppelin/css/style.css?body=1" rel="stylesheet" type="text/css"> |
| <link href="/docs/0.8.2/assets/themes/zeppelin/css/syntax.css" rel="stylesheet" type="text/css" media="screen" /> |
| <!-- Le fav and touch icons --> |
| <!-- Update these with your own images |
| <link rel="shortcut icon" href="images/favicon.ico"> |
| <link rel="apple-touch-icon" href="images/apple-touch-icon.png"> |
| <link rel="apple-touch-icon" sizes="72x72" href="images/apple-touch-icon-72x72.png"> |
| <link rel="apple-touch-icon" sizes="114x114" href="images/apple-touch-icon-114x114.png"> |
| --> |
| |
| <!-- Js --> |
| <script src="https://code.jquery.com/jquery-1.10.2.min.js"></script> |
| <script src="/docs/0.8.2/assets/themes/zeppelin/bootstrap/js/bootstrap.min.js"></script> |
| <script src="/docs/0.8.2/assets/themes/zeppelin/js/docs.js"></script> |
| <script src="/docs/0.8.2/assets/themes/zeppelin/js/anchor.min.js"></script> |
| <script src="/docs/0.8.2/assets/themes/zeppelin/js/toc.js"></script> |
| <script src="/docs/0.8.2/assets/themes/zeppelin/js/lunr.min.js"></script> |
| <script src="/docs/0.8.2/assets/themes/zeppelin/js/search.js"></script> |
| |
| <!-- atom & 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> |
| |
| <div id="menu" class="navbar navbar-inverse navbar-fixed-top" role="navigation"> |
| <div class="container navbar-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> |
| <div class="navbar-brand"> |
| <a class="navbar-brand-main" href="http://zeppelin.apache.org"> |
| <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.2" |
| style="font-size: 15px; color: white;"> 0.8.2 |
| </a> |
| </a> |
| </div> |
| </div> |
| <nav class="navbar-collapse collapse" role="navigation"> |
| <ul class="nav navbar-nav"> |
| <li> |
| <a href="#" data-toggle="dropdown" class="dropdown-toggle">Quick Start <b class="caret"></b></a> |
| <ul class="dropdown-menu"> |
| <li class="title"><span>Getting Started</span></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> |
| |
| <li> |
| <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.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.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.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.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.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> |
| |
| <li> |
| <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.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.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.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.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.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> |
| |
| <li> |
| <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.2/usage/interpreter/overview.html">Overview</a></li> |
| <li role="separator" class="divider"></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.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.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.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> |
| <li><a target="_blank" href="">Apache Zeppelin Wiki</a></li> |
| <li><a target="_blank" href="">Stackoverflow Questions about Zeppelin</a></li> |
| </ul> |
| </li> |
| <li> |
| <a href="/docs/0.8.2/search.html" class="nav-search-link"> |
| <span class="fa fa-search nav-search-icon"></span> |
| </a> |
| </li> |
| </ul> |
| </nav><!--/.navbar-collapse --> |
| </div> |
| </div> |
| |
| |
| |
| <div class="content"> |
| |
| <!--<div class="hero-unit SQL with Zeppelin"> |
| <h1></h1> |
| </div> |
| --> |
| |
| <div class="row"> |
| <div class="col-md-12"> |
| <!-- |
| Licensed under the Apache License, Version 2.0 (the "License"); |
| you may not use this file except in compliance with the License. |
| You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| --> |
| |
| <h1>SQL support in Zeppelin</h1> |
| |
| <div id="toc"></div> |
| |
| <p><br/></p> |
| |
| <p>The following guides explain how to use Apache Zeppelin that enables you to write in SQL:</p> |
| |
| <ul> |
| <li>provides <a href="../interpreter/jdbc.html">JDBC Interpreter</a> which allows you can connect any JDBC data sources seamlessly |
| |
| <ul> |
| <li><a href="../interpreter/jdbc.html#postgres">Postgres</a></li> |
| <li><a href="../interpreter/jdbc.html#mysql">MySQL</a> </li> |
| <li><a href="../interpreter/jdbc.html#mariadb">MariaDB</a></li> |
| <li><a href="../interpreter/jdbc.html#redshift">AWS Redshift</a> </li> |
| <li><a href="../interpreter/jdbc.html#hive">Apache Hive</a></li> |
| <li><a href="../interpreter/jdbc.html#apache-phoenix">Apache Phoenix</a> </li> |
| <li><a href="../interpreter/jdbc.html#apache-drill">Apache Drill</a></li> |
| <li><a href="../interpreter/jdbc.html#apache-tajo">Apache Tajo</a></li> |
| <li>and so on </li> |
| </ul></li> |
| <li><a href="../interpreter/spark.html">Spark Interpreter</a> supports <a href="http://spark.apache.org/sql/">SparkSQL</a></li> |
| <li><a href="../interpreter/python.html">Python Interpreter</a> supports <a href="../interpreter/python.html#sql-over-pandas-dataframes">pandasSQL</a> </li> |
| <li><p>can create query result including <strong>UI widgets</strong> using <a href="../usage/dynamic_form/intro.html">Dynamic Form</a></p> |
| <div class="highlight"><pre><code class="sql language-sql" data-lang="sql"><span class="o">%</span><span class="k">sql</span> |
| <span class="k">select</span> <span class="n">age</span><span class="p">,</span> <span class="k">count</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span> <span class="n">value</span> |
| <span class="k">from</span> <span class="n">bank</span> |
| <span class="k">where</span> <span class="n">age</span> <span class="o"><</span> <span class="err">${</span><span class="n">maxAge</span><span class="o">=</span><span class="mi">30</span><span class="err">}</span> |
| <span class="k">group</span> <span class="k">by</span> <span class="n">age</span> |
| <span class="k">order</span> <span class="k">by</span> <span class="n">age</span> |
| </code></pre></div></li> |
| </ul> |
| |
| <p><br/></p> |
| |
| <p>For the further information about SQL support in Zeppelin, please check </p> |
| |
| <ul> |
| <li><a href="../interpreter/jdbc.html">JDBC Interpreter</a></li> |
| <li><a href="../interpreter/spark.html">Spark Interpreter</a></li> |
| <li><a href="../interpreter/python.html">Python Interpreter</a></li> |
| <li><a href="../interpreter/ignite.html#ignite-sql-interpreter">IgniteSQL Interpreter</a> for <a href="https://ignite.apache.org/">Apache Ignite</a></li> |
| <li><a href="../interpreter/kylin.html">Kylin Interpreter</a> for <a href="http://kylin.apache.org/">Apache Kylin</a></li> |
| </ul> |
| |
| </div> |
| </div> |
| |
| |
| <hr> |
| <footer> |
| <!-- <p>© 2019 The Apache Software Foundation</p>--> |
| </footer> |
| </div> |
| |
| |
| |
| |
| <script type="text/javascript"> |
| (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ |
| (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), |
| m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) |
| })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); |
| |
| ga('create', 'UA-45176241-5', 'zeppelin.apache.org'); |
| ga('require', 'linkid', 'linkid.js'); |
| ga('send', 'pageview'); |
| |
| </script> |
| |
| |
| |
| </body> |
| </html> |
| |
