Author: moon
Date: Sat Feb 20 16:52:38 2016
New Revision: 1731424
URL: http://svn.apache.org/viewvc?rev=1731424&view=rev
Log:
Guide user to add jdbc driver jar file via GUI interpreter menu
https://github.com/apache/incubator-zeppelin/pull/717
Added:
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/assets/themes/zeppelin/img/docs-img/jdbc-multi-connection-setting.png
(with props)
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/assets/themes/zeppelin/img/docs-img/jdbc-simple-connection-setting.png
(with props)
Modified:
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/atom.xml
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/install/install.html
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/interpreter/jdbc.html
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/rss.xml
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/sitemap.txt
Added:
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/assets/themes/zeppelin/img/docs-img/jdbc-multi-connection-setting.png
URL:
http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/assets/themes/zeppelin/img/docs-img/jdbc-multi-connection-setting.png?rev=1731424&view=auto
==============================================================================
Binary file - no diff available.
Propchange:
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/assets/themes/zeppelin/img/docs-img/jdbc-multi-connection-setting.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added:
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/assets/themes/zeppelin/img/docs-img/jdbc-simple-connection-setting.png
URL:
http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/assets/themes/zeppelin/img/docs-img/jdbc-simple-connection-setting.png?rev=1731424&view=auto
==============================================================================
Binary file - no diff available.
Propchange:
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/assets/themes/zeppelin/img/docs-img/jdbc-simple-connection-setting.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Modified: incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/atom.xml
URL:
http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/atom.xml?rev=1731424&r1=1731423&r2=1731424&view=diff
==============================================================================
--- incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/atom.xml (original)
+++ incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/atom.xml Sat Feb 20
16:52:38 2016
@@ -4,7 +4,7 @@
<title>Apache Zeppelin (incubating)</title>
<link href="http://zeppelin.incubator.apache.org/"; rel="self"/>
<link href="http://zeppelin.incubator.apache.org"/>
- <updated>2016-02-16T14:52:44+09:00</updated>
+ <updated>2016-02-20T08:54:53-08:00</updated>
<id>http://zeppelin.incubator.apache.org</id>
<author>
<name>The Apache Software Foundation</name>
Modified:
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/install/install.html
URL:
http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/install/install.html?rev=1731424&r1=1731423&r2=1731424&view=diff
==============================================================================
--- incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/install/install.html
(original)
+++ incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/install/install.html
Sat Feb 20 16:52:38 2016
@@ -322,6 +322,24 @@ limitations under the License.
<td>A user name of S3 bucket<br />i.e.
<code>bucket/user/notebook/2A94M5J1Z/note.json</code></td>
</tr>
<tr>
+ <td>ZEPPELIN_NOTEBOOK_AZURE_CONNECTION_STRING</td>
+ <td>zeppelin.notebook.azure.connectionString</td>
+ <td></td>
+ <td>The Azure storage account connection string<br />i.e.
<code>DefaultEndpointsProtocol=https;AccountName=<accountName>;AccountKey=<accountKey></code></td>
+ </tr>
+ <tr>
+ <td>ZEPPELIN_NOTEBOOK_AZURE_SHARE</td>
+ <td>zeppelin.notebook.azure.share</td>
+ <td>zeppelin</td>
+ <td>Share where the Zeppelin notebook files will be saved</td>
+ </tr>
+ <tr>
+ <td>ZEPPELIN_NOTEBOOK_AZURE_USER</td>
+ <td>zeppelin.notebook.azure.user</td>
+ <td>user</td>
+ <td>An optional user name of Azure file share<br />i.e.
<code>share/user/notebook/2A94M5J1Z/note.json</code></td>
+ </tr>
+ <tr>
<td>ZEPPELIN_NOTEBOOK_STORAGE</td>
<td>zeppelin.notebook.storage</td>
<td>org.apache.zeppelin.notebook.repo.VFSNotebookRepo</td>
Modified:
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/interpreter/jdbc.html
URL:
http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/interpreter/jdbc.html?rev=1731424&r1=1731423&r2=1731424&view=diff
==============================================================================
---
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/interpreter/jdbc.html
(original)
+++
incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/interpreter/jdbc.html
Sat Feb 20 16:52:38 2016
@@ -160,6 +160,11 @@
<li>MariaDB</li>
<li>Redshift</li>
<li>Hive</li>
+<li>Apache Drill
+
+<ul>
+<li>Details on using <a
href="https://drill.apache.org/docs/using-the-jdbc-driver";>Drill JDBC
Driver</a></li>
+</ul></li>
</ul>
<p>If someone else used another database please report how it works to improve
functionality.</p>
@@ -199,11 +204,15 @@
<h4>Simple connection</h4>
-<p>Before creating the interpreter it is necessary to add to the Zeppelin
classpath the path of the JDBC you want to use, to do it you must edit the file
<code>zeppelin-daemon.sh</code> as shown:</p>
-<div class="highlight"><pre><code class="text language-text"
data-lang="text"># Add jdbc connector jar
-ZEPPELIN_CLASSPATH+=":${ZEPPELIN_HOME}/jdbc/jars/mysql-connector-java-5.1.6.jar"
-</code></pre></div>
-<p>For create the interpreter you need to specify connection parameters as
shown in the table.</p>
+<p>Prior 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. <code>mysql:mysql-connector-java:5.1.38</code>) in
interpreter menu as shown:</p>
+
+<div class="row">
+ <div class="col-md-11">
+ <img
src="../assets/themes/zeppelin/img/docs-img/jdbc-simple-connection-setting.png"
/>
+ </div>
+</div>
+
+<p>To create the interpreter you need to specify connection parameters as
shown in the table.</p>
<table class="table-configuration">
<tr>
@@ -234,12 +243,15 @@ ZEPPELIN_CLASSPATH+=":${ZEPPELIN_HO
<h4>Multiple connections</h4>
-<p>This JDBC interpreter also allows connections to multiple data sources. For
every connection is necessary a prefix for reference in the paragraph this way
<code>%jdbc(prefix)</code>. Before creating the interpreter it is necessary to
add to the Zeppelin classpath all paths to access to each driver's jar file
you want to use, to do it you must edit the file
<code>zeppelin-daemon.sh</code> as following:</p>
-<div class="highlight"><pre><code class="text language-text"
data-lang="text"># Add jdbc connector jar
-ZEPPELIN_CLASSPATH+=":${ZEPPELIN_HOME}/jdbc/jars/RedshiftJDBC41-1.1.10.1010.jar"
-ZEPPELIN_CLASSPATH+=":${ZEPPELIN_HOME}/jdbc/jars/mysql-connector-java-5.1.6.jar"
-</code></pre></div>
-<p>You can add all the jars you need to make multiple connections into the
same interpreter. To create the interpreter you must specify the parameters,
for example we will create two connections to PostgreSQL and Redshift, the
respective prefixes are <code>default</code> and <code>redshift</code>:</p>
+<p>JDBC 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 <code>%jdbc(prefix)</code>. Before you create the interpreter it
is necessary to add each driver's maven coordinates or JDBC driver's
jar file path to the Zeppelin classpath. To do this you must edit the
dependencies of JDBC interpreter in interpreter menu as following:</p>
+
+<div class="row">
+ <div class="col-md-11">
+ <img
src="../assets/themes/zeppelin/img/docs-img/jdbc-multi-connection-setting.png"
/>
+ </div>
+</div>
+
+<p>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 <code>default</code> and <code>redshift</code>:</p>
<table class="table-configuration">
<tr>
@@ -252,7 +264,7 @@ ZEPPELIN_CLASSPATH+=":${ZEPPELIN_HO
</tr>
<tr>
<td>default.driver</td>
- <td>org.postgresql.Driver</td>
+ <td>com.mysql.jdbc.Driver</td>
</tr>
<tr>
<td>default.password</td>
@@ -260,11 +272,11 @@ ZEPPELIN_CLASSPATH+=":${ZEPPELIN_HO
</tr>
<tr>
<td>default.url</td>
- <td>jdbc:postgresql://localhost:5432/</td>
+ <td>jdbc:mysql://localhost:3306/</td>
</tr>
<tr>
<td>default.user</td>
- <td>gpadmin</td>
+ <td>mysql-user</td>
</tr>
<tr>
<td>redshift.driver</td>
Modified: incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/rss.xml
URL:
http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/rss.xml?rev=1731424&r1=1731423&r2=1731424&view=diff
==============================================================================
--- incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/rss.xml (original)
+++ incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/rss.xml Sat Feb 20
16:52:38 2016
@@ -5,8 +5,8 @@
<description>Apache Zeppelin (incubating) - The Apache Software
Foundation</description>
<link>http://zeppelin.incubator.apache.org</link>
<link>http://zeppelin.incubator.apache.org</link>
- <lastBuildDate>2016-02-16T14:52:44+09:00</lastBuildDate>
- <pubDate>2016-02-16T14:52:44+09:00</pubDate>
+ <lastBuildDate>2016-02-20T08:54:53-08:00</lastBuildDate>
+ <pubDate>2016-02-20T08:54:53-08:00</pubDate>
<ttl>1800</ttl>
Modified: incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/sitemap.txt
URL:
http://svn.apache.org/viewvc/incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/sitemap.txt?rev=1731424&r1=1731423&r2=1731424&view=diff
==============================================================================
--- incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/sitemap.txt
(original)
+++ incubator/zeppelin/site/docs/0.6.0-incubating-SNAPSHOT/sitemap.txt Sat Feb
20 16:52:38 2016
@@ -1,9 +1,7 @@
http://zeppelin.incubator.apache.org/atom.xml
-http://zeppelin.incubator.apache.org/development/datavalidation.html
http://zeppelin.incubator.apache.org/development/howtocontribute.html
http://zeppelin.incubator.apache.org/development/howtocontributewebsite.html
-http://zeppelin.incubator.apache.org/development/introducingchartlibrary.html
http://zeppelin.incubator.apache.org/development/writingzeppelininterpreter.html
http://zeppelin.incubator.apache.org/displaysystem/angular.html
http://zeppelin.incubator.apache.org/displaysystem/display.html
@@ -34,7 +32,6 @@ http://zeppelin.incubator.apache.org/man
http://zeppelin.incubator.apache.org/manual/publish.html
http://zeppelin.incubator.apache.org/manual/shiroauthentication.html
http://zeppelin.incubator.apache.org/pleasecontribute.html
-http://zeppelin.incubator.apache.org/releases/zeppelin-release-0.5.0-incubating.html
http://zeppelin.incubator.apache.org/rest-api/rest-configuration.html
http://zeppelin.incubator.apache.org/rest-api/rest-interpreter.html
http://zeppelin.incubator.apache.org/rest-api/rest-notebook.html
@@ -43,4 +40,3 @@ http://zeppelin.incubator.apache.org/scr
http://zeppelin.incubator.apache.org/sitemap.txt
http://zeppelin.incubator.apache.org/storage/storage.html
http://zeppelin.incubator.apache.org/tutorial/tutorial.html
-http://zeppelin.incubator.apache.org/tutorial/tutorialonmapvisualization.html
