You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@zeppelin.apache.org by mi...@apache.org on 2016/09/28 03:59:23 UTC
svn commit: r1762602 - in /zeppelin/site/docs/0.7.0-SNAPSHOT: atom.xml
interpreter/jdbc.html rss.xml search_data.json
Author: minalee
Date: Wed Sep 28 03:59:23 2016
New Revision: 1762602
URL: http://svn.apache.org/viewvc?rev=1762602&view=rev
Log:
https://github.com/apache/zeppelin/pull/1436
Modified:
zeppelin/site/docs/0.7.0-SNAPSHOT/atom.xml
zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html
zeppelin/site/docs/0.7.0-SNAPSHOT/rss.xml
zeppelin/site/docs/0.7.0-SNAPSHOT/search_data.json
Modified: zeppelin/site/docs/0.7.0-SNAPSHOT/atom.xml
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.7.0-SNAPSHOT/atom.xml?rev=1762602&r1=1762601&r2=1762602&view=diff
==============================================================================
--- zeppelin/site/docs/0.7.0-SNAPSHOT/atom.xml (original)
+++ zeppelin/site/docs/0.7.0-SNAPSHOT/atom.xml Wed Sep 28 03:59:23 2016
@@ -4,7 +4,7 @@
<title>Apache Zeppelin</title>
<link href="http://zeppelin.apache.org/" rel="self"/>
<link href="http://zeppelin.apache.org"/>
- <updated>2016-09-27T12:46:46+09:00</updated>
+ <updated>2016-09-28T12:58:09+09:00</updated>
<id>http://zeppelin.apache.org</id>
<author>
<name>The Apache Software Foundation</name>
Modified: zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html?rev=1762602&r1=1762601&r2=1762602&view=diff
==============================================================================
--- zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html (original)
+++ zeppelin/site/docs/0.7.0-SNAPSHOT/interpreter/jdbc.html Wed Sep 28 03:59:23 2016
@@ -456,41 +456,79 @@ limitations under the License.
<h3>Phoenix</h3>
-<h4>Properties</h4>
+<p>Phoenix supports <code>thick</code> and <code>thin</code> connection types:</p>
+
+<ul>
+<li>Thick client is faster, but must connect directly to ZooKeeper and HBase RegionServers.</li>
+<li>Thin client has fewer dependencies and connects through a <a href="http://phoenix.apache.org/server.html">Phoenix Query Server</a> instance.</li>
+</ul>
+
+<p>Use the appropriate <code>phoenix.driver</code> and <code>phoenix.url</code> for your connection type.</p>
+
+<h4>Properties:</h4>
<p><table class="table-configuration">
<tr>
<th>Name</th>
<th>Value</th>
+ <th>Description</th>
</tr>
<tr>
<td>phoenix.driver</td>
<td>org.apache.phoenix.jdbc.PhoenixDriver</td>
+ <td>'Thick Client', connects directly to Phoenix</td>
+ </tr>
+ <tr>
+ <td>phoenix.driver</td>
+ <td>org.apache.phoenix.queryserver.client.Driver</td>
+ <td>'Thin Client', connects via Phoenix Query Server</td>
</tr>
<tr>
<td>phoenix.url</td>
<td>jdbc:phoenix:localhost:2181:/hbase-unsecure</td>
+ <td>'Thick Client', connects directly to Phoenix</td>
+ </tr>
+ <tr>
+ <td>phoenix.url</td>
+ <td>jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF</td>
+ <td>'Thin Client', connects via Phoenix Query Server</td>
</tr>
<tr>
<td>phoenix.user</td>
<td>phoenix<em>user</td>
+ <td></td>
</tr>
<tr>
<td>phoenix.password</td>
<td>phoenix</em>password</td>
+ <td></td>
</tr>
</table></p>
-<h4>Dependencies</h4>
+<h4>Dependencies:</h4>
+
+<p>Include the dependency for your connection type (it should be only <em>one</em> of the following).</p>
<p><table class="table-configuration">
<tr>
<th>Artifact</th>
<th>Excludes</th>
+ <th>Description</th>
</tr>
<tr>
<td>org.apache.phoenix:phoenix-core:4.4.0-HBase-1.0</td>
<td></td>
+ <td>'Thick Client', connects directly to Phoenix</td>
+ </tr>
+ <tr>
+ <td>org.apache.phoenix:phoenix-server-client:4.7.0-HBase-1.1</td>
+ <td></td>
+ <td>'Thin Client' for Phoenix 4.7, connects via Phoenix Query Server</td>
+ </tr>
+ <tr>
+ <td>org.apache.phoenix:phoenix-queryserver-client:4.8.0-HBase-1.2</td>
+ <td></td>
+ <td>'Thin Client' for Phoenix 4.8+, connects via Phoenix Query Server</td>
</tr>
</table></p>
Modified: zeppelin/site/docs/0.7.0-SNAPSHOT/rss.xml
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.7.0-SNAPSHOT/rss.xml?rev=1762602&r1=1762601&r2=1762602&view=diff
==============================================================================
--- zeppelin/site/docs/0.7.0-SNAPSHOT/rss.xml (original)
+++ zeppelin/site/docs/0.7.0-SNAPSHOT/rss.xml Wed Sep 28 03:59:23 2016
@@ -5,8 +5,8 @@
<description>Apache Zeppelin - The Apache Software Foundation</description>
<link>http://zeppelin.apache.org</link>
<link>http://zeppelin.apache.org</link>
- <lastBuildDate>2016-09-27T12:46:46+09:00</lastBuildDate>
- <pubDate>2016-09-27T12:46:46+09:00</pubDate>
+ <lastBuildDate>2016-09-28T12:58:09+09:00</lastBuildDate>
+ <pubDate>2016-09-28T12:58:09+09:00</pubDate>
<ttl>1800</ttl>
Modified: zeppelin/site/docs/0.7.0-SNAPSHOT/search_data.json
URL: http://svn.apache.org/viewvc/zeppelin/site/docs/0.7.0-SNAPSHOT/search_data.json?rev=1762602&r1=1762601&r2=1762602&view=diff
==============================================================================
--- zeppelin/site/docs/0.7.0-SNAPSHOT/search_data.json (original)
+++ zeppelin/site/docs/0.7.0-SNAPSHOT/search_data.json Wed Sep 28 03:59:23 2016
@@ -4,7 +4,7 @@
"/atom.xml": {
"title": "Atom Feed",
- "content" : " Apache Zeppelin 2016-09-27T12:46:46+09:00 http://zeppelin.apache.org The Apache Software Foundation dev@zeppelin.apache.org ",
+ "content" : " Apache Zeppelin 2016-09-28T12:58:09+09:00 http://zeppelin.apache.org The Apache Software Foundation dev@zeppelin.apache.org ",
"url": " /atom.xml",
"group": "",
"excerpt": ""
@@ -269,7 +269,7 @@
"/interpreter/jdbc.html": {
"title": "Generic JDBC Interpreter for Apache Zeppelin",
- "content" : "<!--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 athttp://www.apache.org/licenses/LICENSE-2.0Unless required by applicable law or agreed to in writing, softwaredistributed 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 andlimitations under the License.-->Generic JDBC Interpreter for Apache ZeppelinOverviewThis interpreter lets you create a JDBC connection to any data source, by now it has been tested with:PostgresMySqlMariaDBRedshiftApache HiveApache PhoenixApache Drill (Details on using Drill JDBC Driver)Apache TajoIf someone else used another database please report how it works to improve functionality.Create InterpreterWhen you create a interpreter by default use PostgreSQL with
the next properties: name value common.max_count 1000 default.driver org.postgresql.Driver default.password ******** default.url jdbc:postgresql://localhost:5432/ default.user gpadmin It is not necessary to add driver jar to the classpath for PostgreSQL as it is included in Zeppelin.Simple connectionPrior to creating the interpreter it is necessary to add maven coordinate or path of the JDBC driver to the Zeppelin classpath. To do this you must edit dependencies artifact(ex. mysql:mysql-connector-java:5.1.38) in interpreter menu as shown: To create the interpreter you need to specify connection parameters as shown in the table. name value common.max_count 1000 default.driver driver name default.password ******** default.url jdbc url default.user user name Multiple connectionsJDBC interpreter also allows connections to multiple data sources. It is
necessary to set a prefix for each connection to reference it in the paragraph in the form of %jdbc(prefix). Before you create the interpreter it is necessary to add each driver&#39;s maven coordinates or JDBC driver&#39;s jar file path to the Zeppelin classpath. To do this you must edit the dependencies of JDBC interpreter in interpreter menu as following: You can add all the jars you need to make multiple connections into the same JDBC interpreter. To create the interpreter you must specify the parameters. For example we will create two connections to MySQL and Redshift, the respective prefixes are default and redshift: name value common.max_count 1000 default.driver com.mysql.jdbc.Driver default.password ******** default.url jdbc:mysql://localhost:3306/ default.user mysql-user redshift.driver com.amazon.redshift.jdbc4.Driver redshift.password ******** redshift.url jdbc:redshift:
//examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439 redshift.user redshift-user Bind to NotebookIn the Notebook click on the settings icon at the top-right corner. Use select/deselect to specify the interpreters to be used in the Notebook.More PropertiesYou can modify the interpreter configuration in the Interpreter section. The most common properties are as follows, but you can specify other properties that need to be connected. Property Name Description {prefix}.url JDBC URL to connect, the URL must include the name of the database {prefix}.user JDBC user name {prefix}.password JDBC password {prefix}.driver JDBC driver name. common.max_result Max number of SQL result to display to prevent the browser overload. This is common properties for all connections zeppelin.jdbc.auth.type Types of authentications&#39; methods supported are SIMPLE, and KERBERO
S zeppelin.jdbc.principal The principal name to load from the keytab zeppelin.jdbc.keytab.location The path to the keytab file To develop this functionality use this method. For example if a connection needs a schema parameter, it would have to add the property as follows: name value {prefix}.schema schema_name ExamplesHiveProperties Name Value hive.driver org.apache.hive.jdbc.HiveDriver hive.url jdbc:hive2://localhost:10000 hive.user hiveuser hive.password hivepassword Dependencies Artifact Excludes org.apache.hive:hive-jdbc:0.14.0 org.apache.hadoop:hadoop-common:2.6.0 PhoenixProperties Name Value phoenix.driver org.apache.phoenix.jdbc.PhoenixDriver phoenix.url jdbc:phoenix:localhost:2181:/hbase-unsecure phoenix.user phoenixuser phoenix.password phoenixpa
ssword Dependencies Artifact Excludes org.apache.phoenix:phoenix-core:4.4.0-HBase-1.0 TajoProperties Name Value tajo.driver org.apache.tajo.jdbc.TajoDriver tajo.url jdbc:tajo://localhost:26002/default Dependencies Artifact Excludes org.apache.tajo:tajo-jdbc:0.11.0 How to useReference in paragraphStart the paragraphs with the %jdbc, this will use the default prefix for connection. If you want to use other connection you should specify the prefix of it as follows %jdbc(prefix):%jdbcSELECT * FROM db_name;or%jdbc(prefix)SELECT * FROM db_name;Apply Zeppelin Dynamic FormsYou can leverage Zeppelin Dynamic Form inside your queries. You can use both the text input and select form parametrization features%jdbc(prefix)SELECT name, country, performerFROM demo.performersWHERE name=&#39;&#39;Bugs &amp; ReportingIf you find a bug for this interpreter, please create a JIRA ticket.",
+ "content" : "<!--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 athttp://www.apache.org/licenses/LICENSE-2.0Unless required by applicable law or agreed to in writing, softwaredistributed 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 andlimitations under the License.-->Generic JDBC Interpreter for Apache ZeppelinOverviewThis interpreter lets you create a JDBC connection to any data source, by now it has been tested with:PostgresMySqlMariaDBRedshiftApache HiveApache PhoenixApache Drill (Details on using Drill JDBC Driver)Apache TajoIf someone else used another database please report how it works to improve functionality.Create InterpreterWhen you create a interpreter by default use PostgreSQL with
the next properties: name value common.max_count 1000 default.driver org.postgresql.Driver default.password ******** default.url jdbc:postgresql://localhost:5432/ default.user gpadmin It is not necessary to add driver jar to the classpath for PostgreSQL as it is included in Zeppelin.Simple connectionPrior to creating the interpreter it is necessary to add maven coordinate or path of the JDBC driver to the Zeppelin classpath. To do this you must edit dependencies artifact(ex. mysql:mysql-connector-java:5.1.38) in interpreter menu as shown: To create the interpreter you need to specify connection parameters as shown in the table. name value common.max_count 1000 default.driver driver name default.password ******** default.url jdbc url default.user user name Multiple connectionsJDBC interpreter also allows connections to multiple data sources. It is
necessary to set a prefix for each connection to reference it in the paragraph in the form of %jdbc(prefix). Before you create the interpreter it is necessary to add each driver&#39;s maven coordinates or JDBC driver&#39;s jar file path to the Zeppelin classpath. To do this you must edit the dependencies of JDBC interpreter in interpreter menu as following: You can add all the jars you need to make multiple connections into the same JDBC interpreter. To create the interpreter you must specify the parameters. For example we will create two connections to MySQL and Redshift, the respective prefixes are default and redshift: name value common.max_count 1000 default.driver com.mysql.jdbc.Driver default.password ******** default.url jdbc:mysql://localhost:3306/ default.user mysql-user redshift.driver com.amazon.redshift.jdbc4.Driver redshift.password ******** redshift.url jdbc:redshift:
//examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439 redshift.user redshift-user Bind to NotebookIn the Notebook click on the settings icon at the top-right corner. Use select/deselect to specify the interpreters to be used in the Notebook.More PropertiesYou can modify the interpreter configuration in the Interpreter section. The most common properties are as follows, but you can specify other properties that need to be connected. Property Name Description {prefix}.url JDBC URL to connect, the URL must include the name of the database {prefix}.user JDBC user name {prefix}.password JDBC password {prefix}.driver JDBC driver name. common.max_result Max number of SQL result to display to prevent the browser overload. This is common properties for all connections zeppelin.jdbc.auth.type Types of authentications&#39; methods supported are SIMPLE, and KERBERO
S zeppelin.jdbc.principal The principal name to load from the keytab zeppelin.jdbc.keytab.location The path to the keytab file To develop this functionality use this method. For example if a connection needs a schema parameter, it would have to add the property as follows: name value {prefix}.schema schema_name ExamplesHiveProperties Name Value hive.driver org.apache.hive.jdbc.HiveDriver hive.url jdbc:hive2://localhost:10000 hive.user hiveuser hive.password hivepassword Dependencies Artifact Excludes org.apache.hive:hive-jdbc:0.14.0 org.apache.hadoop:hadoop-common:2.6.0 PhoenixPhoenix supports thick and thin connection types:Thick client is faster, but must connect directly to ZooKeeper and HBase RegionServers.Thin client has fewer dependencies and connects through a Phoenix Query Server instance.Use the appropriate phoen
ix.driver and phoenix.url for your connection type.Properties: Name Value Description phoenix.driver org.apache.phoenix.jdbc.PhoenixDriver &#39;Thick Client&#39;, connects directly to Phoenix phoenix.driver org.apache.phoenix.queryserver.client.Driver &#39;Thin Client&#39;, connects via Phoenix Query Server phoenix.url jdbc:phoenix:localhost:2181:/hbase-unsecure &#39;Thick Client&#39;, connects directly to Phoenix phoenix.url jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF &#39;Thin Client&#39;, connects via Phoenix Query Server phoenix.user phoenixuser phoenix.password phoenixpassword Dependencies:Include the dependency for your connection type (it should be only one of the following). Artifact Excludes Description org.apache.phoenix:phoenix-core:4.4.0-HBase-1.0 &#39;T
hick Client&#39;, connects directly to Phoenix org.apache.phoenix:phoenix-server-client:4.7.0-HBase-1.1 &#39;Thin Client&#39; for Phoenix 4.7, connects via Phoenix Query Server org.apache.phoenix:phoenix-queryserver-client:4.8.0-HBase-1.2 &#39;Thin Client&#39; for Phoenix 4.8+, connects via Phoenix Query Server TajoProperties Name Value tajo.driver org.apache.tajo.jdbc.TajoDriver tajo.url jdbc:tajo://localhost:26002/default Dependencies Artifact Excludes org.apache.tajo:tajo-jdbc:0.11.0 How to useReference in paragraphStart the paragraphs with the %jdbc, this will use the default prefix for connection. If you want to use other connection you should specify the prefix of it as follows %jdbc(prefix):%jdbcSELECT * FROM db_name;or%jdbc(prefix)SELECT * FROM db_name;Apply Zeppelin Dynamic FormsYou can leverage Zeppelin Dynamic Form inside your queries. You ca
n use both the text input and select form parametrization features%jdbc(prefix)SELECT name, country, performerFROM demo.performersWHERE name=&#39;&#39;Bugs &amp; ReportingIf you find a bug for this interpreter, please create a JIRA ticket.",
"url": " /interpreter/jdbc.html",
"group": "interpreter",
"excerpt": "Generic JDBC Interpreter lets you create a JDBC connection to any data source. You can use Postgres, MySql, MariaDB, Redshift, Apache Hive, Apache Phoenix, Apache Drill and Apache Tajo using JDBC interpreter."
@@ -523,7 +523,7 @@
"/rss.xml": {
"title": "RSS Feed",
- "content" : " Apache Zeppelin Apache Zeppelin - The Apache Software Foundation http://zeppelin.apache.org http://zeppelin.apache.org 2016-09-27T12:46:46+09:00 2016-09-27T12:46:46+09:00 1800",
+ "content" : " Apache Zeppelin Apache Zeppelin - The Apache Software Foundation http://zeppelin.apache.org http://zeppelin.apache.org 2016-09-28T12:58:09+09:00 2016-09-28T12:58:09+09:00 1800",
"url": " /rss.xml",
"group": "",
"excerpt": ""