zeppelin-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ahyoung...@apache.org
Subject zeppelin git commit: [ZEPPELIN-1650] Add mariadb, redshift configs and useful links to JDBC doc
Date Mon, 14 Nov 2016 22:30:13 GMT
Repository: zeppelin
Updated Branches:
  refs/heads/master 6069a083a -> 9bf56d9f6


[ZEPPELIN-1650] Add mariadb, redshift configs and useful links to JDBC doc

### What is this PR for?

Add 2 JDBC configs and useful links to JDBC doc so that users can connect those backends easily
:)

### What type of PR is it?

Documentation

### Todos
* [ ] - Task

### What is the Jira issue?

[ZEPPELIN-1650](https://issues.apache.org/jira/browse/ZEPPELIN-1650)

### How should this be tested?

See screenshots.

### Screenshots (if appropriate)

<img width="706" alt="example_redshift" src="https://cloud.githubusercontent.com/assets/4968473/20208653/01b1e468-a833-11e6-9166-b05d15e9a5fe.png">
<img width="577" alt="example_mariadb" src="https://cloud.githubusercontent.com/assets/4968473/20208654/02b49a22-a833-11e6-9b29-5a61f2b6a4bb.png">

### Questions:
* Does the licenses files need update? - NO
* Is there breaking changes for older versions? - NO
* Does this needs documentation? - NO

Author: 1ambda <1amb4a@gmail.com>
Author: AhyoungRyu <fbdkdud93@hanmail.net>

Closes #1621 from 1ambda/jdbc-doc-improve and squashes the following commits:

0aab878 [1ambda] docs: Update postgres img ;)
6009eb9 [1ambda] docs: Add postgres section, hive2 doc link
ce24af1 [AhyoungRyu] Make mariadb and redshift screenshots same with others
2fb5db1 [1ambda] docs: Add mariadb, redshift configs


Project: http://git-wip-us.apache.org/repos/asf/zeppelin/repo
Commit: http://git-wip-us.apache.org/repos/asf/zeppelin/commit/9bf56d9f
Tree: http://git-wip-us.apache.org/repos/asf/zeppelin/tree/9bf56d9f
Diff: http://git-wip-us.apache.org/repos/asf/zeppelin/diff/9bf56d9f

Branch: refs/heads/master
Commit: 9bf56d9f64fa439bfb394a21da0b43009cfb8eaa
Parents: 6069a08
Author: 1ambda <1amb4a@gmail.com>
Authored: Mon Nov 14 19:35:17 2016 +0900
Committer: ahyoungryu <ahyoungryu@apache.org>
Committed: Mon Nov 14 23:29:53 2016 +0100

----------------------------------------------------------------------
 .../zeppelin/img/docs-img/mariadb_setting.png   | Bin 0 -> 148550 bytes
 .../zeppelin/img/docs-img/postgres_setting.png  | Bin 0 -> 147883 bytes
 .../zeppelin/img/docs-img/redshift_setting.png  | Bin 0 -> 170219 bytes
 docs/interpreter/jdbc.md                        | 153 ++++++++++++++++++-
 4 files changed, 151 insertions(+), 2 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/zeppelin/blob/9bf56d9f/docs/assets/themes/zeppelin/img/docs-img/mariadb_setting.png
----------------------------------------------------------------------
diff --git a/docs/assets/themes/zeppelin/img/docs-img/mariadb_setting.png b/docs/assets/themes/zeppelin/img/docs-img/mariadb_setting.png
new file mode 100644
index 0000000..da32528
Binary files /dev/null and b/docs/assets/themes/zeppelin/img/docs-img/mariadb_setting.png
differ

http://git-wip-us.apache.org/repos/asf/zeppelin/blob/9bf56d9f/docs/assets/themes/zeppelin/img/docs-img/postgres_setting.png
----------------------------------------------------------------------
diff --git a/docs/assets/themes/zeppelin/img/docs-img/postgres_setting.png b/docs/assets/themes/zeppelin/img/docs-img/postgres_setting.png
new file mode 100644
index 0000000..7eb7a9b
Binary files /dev/null and b/docs/assets/themes/zeppelin/img/docs-img/postgres_setting.png
differ

http://git-wip-us.apache.org/repos/asf/zeppelin/blob/9bf56d9f/docs/assets/themes/zeppelin/img/docs-img/redshift_setting.png
----------------------------------------------------------------------
diff --git a/docs/assets/themes/zeppelin/img/docs-img/redshift_setting.png b/docs/assets/themes/zeppelin/img/docs-img/redshift_setting.png
new file mode 100644
index 0000000..54a5f71
Binary files /dev/null and b/docs/assets/themes/zeppelin/img/docs-img/redshift_setting.png
differ

http://git-wip-us.apache.org/repos/asf/zeppelin/blob/9bf56d9f/docs/interpreter/jdbc.md
----------------------------------------------------------------------
diff --git a/docs/interpreter/jdbc.md b/docs/interpreter/jdbc.md
index 2523094..a10ea0b 100644
--- a/docs/interpreter/jdbc.md
+++ b/docs/interpreter/jdbc.md
@@ -50,7 +50,7 @@ JDBC interpreter lets you create a JDBC connection to any data sources seamlessl
     </li>
     <li style="padding-bottom: 5px; list-style: circle">
       <a href="https://hive.apache.org/" target="_blank">Apache Hive</a> - 
-      <a href="https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-JDBC"
target="_blank">JDBC Driver</a>
+      <a href="https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBC"
target="_blank">JDBC Driver</a>
     </li>
     <li style="padding-bottom: 5px; list-style: circle">
       <a href="https://phoenix.apache.org/" target="_blank">Apache Phoenix</a>
itself is a JDBC driver
@@ -125,7 +125,7 @@ The last step is **Dependency Setting**. Since Zeppelin only includes
`PostgreSQ
 
 <img src="../assets/themes/zeppelin/img/docs-img/edit_dependencies.png" width="600px"
/>
 
-That's it. You can find more JDBC connection setting examples([Mysql](#mysql), [Apache Hive](#apache-hive),
[Apache Phoenix](#apache-phoenix), and [Apache Tajo](#apache-tajo)) in [this section](#examples).
+That's it. You can find more JDBC connection setting examples([Mysql](#mysql), [MariaDB](#mariadb),
[Redshift](#redshift), [Apache Hive](#apache-hive), [Apache Phoenix](#apache-phoenix), and
[Apache Tajo](#apache-tajo)) in [this section](#examples).
 
 ## More properties
 There are more JDBC interpreter properties you can specify like below.
@@ -205,6 +205,50 @@ WHERE name='{{"{{performer=Sheryl Crow|Doof|Fanfarlo|Los Paranoia"}}}}'
 ## Examples
 Here are some examples you can refer to. Including the below connectors, you can connect
every databases as long as it can be configured with it's JDBC driver.
 
+### Postgres
+
+<img src="../assets/themes/zeppelin/img/docs-img/postgres_setting.png" width="600px" />
+
+##### Properties
+<table class="table-configuration">
+  <tr>
+    <th>Name</th>
+    <th>Value</th>
+  </tr>
+  <tr>
+    <td>default.driver</td>
+    <td>org.postgresql.Driver</td>
+  </tr>
+  <tr>
+    <td>default.url</td>
+    <td>jdbc:postgresql://localhost:5432/</td>
+  </tr>
+  <tr>
+    <td>default.user</td>
+    <td>mysql_user</td>
+  </tr>
+  <tr>
+    <td>default.password</td>
+    <td>mysql_password</td>
+  </tr>
+</table>
+
+[Postgres JDBC Driver Docs](https://jdbc.postgresql.org/documentation/documentation.html)
+
+##### Dependencies
+<table class="table-configuration">
+  <tr>
+    <th>Artifact</th>
+    <th>Excludes</th>
+  </tr>
+  <tr>
+    <td>org.postgresql:postgresql:9.4.1211</td>
+    <td></td>
+  </tr>
+</table>
+
+[Maven Repository: org.postgresql:postgresql](https://mvnrepository.com/artifact/org.postgresql/postgresql)
+
 ### Mysql
 
 <img src="../assets/themes/zeppelin/img/docs-img/mysql_setting.png" width="600px" />
@@ -233,6 +277,8 @@ Here are some examples you can refer to. Including the below connectors,
you can
   </tr>
 </table>
 
+[Mysql JDBC Driver Docs](https://dev.mysql.com/downloads/connector/j/)
+
 ##### Dependencies
 <table class="table-configuration">
   <tr>
@@ -245,6 +291,96 @@ Here are some examples you can refer to. Including the below connectors,
you can
   </tr>
 </table>
 
+[Maven Repository: mysql:mysql-connector-java](https://mvnrepository.com/artifact/mysql/mysql-connector-java)
+
+### MariaDB
+
+<img src="../assets/themes/zeppelin/img/docs-img/mariadb_setting.png" width="600px" />
+
+##### Properties
+<table class="table-configuration">
+  <tr>
+    <th>Name</th>
+    <th>Value</th>
+  </tr>
+  <tr>
+    <td>default.driver</td>
+    <td>org.mariadb.jdbc.Driver</td>
+  </tr>
+  <tr>
+    <td>default.url</td>
+    <td>jdbc:mariadb://localhost:3306</td>
+  </tr>
+  <tr>
+    <td>default.user</td>
+    <td>mariadb_user</td>
+  </tr>
+  <tr>
+    <td>default.password</td>
+    <td>mariadb_password</td>
+  </tr>
+</table>
+
+[MariaDB JDBC Driver Docs](https://mariadb.com/kb/en/mariadb/about-mariadb-connector-j/)
+
+##### Dependencies
+<table class="table-configuration">
+  <tr>
+    <th>Artifact</th>
+    <th>Excludes</th>
+  </tr>
+  <tr>
+    <td>org.mariadb.jdbc:mariadb-java-client:1.5.4</td>
+    <td></td>
+  </tr>
+</table>
+
+[Maven Repository: org.mariadb.jdbc:mariadb-java-client](https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client)
+
+### Redshift
+
+<img src="../assets/themes/zeppelin/img/docs-img/redshift_setting.png" width="600px" />
+
+##### Properties
+<table class="table-configuration">
+  <tr>
+    <th>Name</th>
+    <th>Value</th>
+  </tr>
+  <tr>
+    <td>default.driver</td>
+    <td>com.amazon.redshift.jdbc42.Driver</td>
+  </tr>
+  <tr>
+    <td>default.url</td>
+    <td>jdbc:redshift://your-redshift-instance-address.redshift.amazonaws.com:5439/your-database</td>
+  </tr>
+  <tr>
+    <td>default.user</td>
+    <td>redshift_user</td>
+  </tr>
+  <tr>
+    <td>default.password</td>
+    <td>redshift_password</td>
+  </tr>
+</table>
+
+[AWS Redshift JDBC Driver Docs](http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html)
+
+##### Dependencies
+<table class="table-configuration">
+  <tr>
+    <th>Artifact</th>
+    <th>Excludes</th>
+  </tr>
+  <tr>
+    <td>com.amazonaws:aws-java-sdk-redshift:1.11.51</td>
+    <td></td>
+  </tr>
+</table>
+
+[Maven Repository: com.amazonaws:aws-java-sdk-redshift](https://mvnrepository.com/artifact/com.amazonaws/aws-java-sdk-redshift)
+
 ### Apache Hive 
 
 <img src="../assets/themes/zeppelin/img/docs-img/hive_setting.png" width="600px" />
@@ -273,6 +409,9 @@ Here are some examples you can refer to. Including the below connectors,
you can
   </tr>
 </table>
 
+[Apache Hive 1 JDBC Driver Docs](https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBC)
+[Apache Hive 2 JDBC Driver Docs](https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBC)
+
 ##### Dependencies
 <table class="table-configuration">
   <tr>
@@ -289,6 +428,8 @@ Here are some examples you can refer to. Including the below connectors,
you can
   </tr>
 </table>
 
+[Maven Repository : org.apache.hive:hive-jdbc](https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc)
+
 ### Apache Phoenix
 
 Phoenix supports `thick` and `thin` connection types:
@@ -338,6 +479,8 @@ Use the appropriate `default.driver`, `default.url`, and the dependency
artifact
   </tr>
 </table>
 
+[Maven Repository: org.apache.phoenix:phoenix-core](https://mvnrepository.com/artifact/org.apache.phoenix/phoenix-core)
+
 #### Thin client connection
 
 <img src="../assets/themes/zeppelin/img/docs-img/phoenix_thin_setting.png" width="600px"
/>
@@ -388,6 +531,8 @@ Before Adding one of the below dependencies, check the Phoenix version
first.
   </tr>
 </table>
 
+[Maven Repository: org.apache.phoenix:phoenix-queryserver-client](https://mvnrepository.com/artifact/org.apache.phoenix/phoenix-queryserver-client)
+
 ### Apache Tajo
 
 <img src="../assets/themes/zeppelin/img/docs-img/tajo_setting.png" width="600px" />
@@ -408,6 +553,8 @@ Before Adding one of the below dependencies, check the Phoenix version
first.
   </tr>
 </table>
 
+[Apache Tajo JDBC Driver Docs](https://tajo.apache.org/docs/current/jdbc_driver.html)
+
 ##### Dependencies
 <table class="table-configuration">
   <tr>
@@ -420,5 +567,7 @@ Before Adding one of the below dependencies, check the Phoenix version
first.
   </tr>
 </table>
 
+[Maven Repository: org.apache.tajo:tajo-jdbc](https://mvnrepository.com/artifact/org.apache.tajo/tajo-jdbc)
+
 ## Bug reporting
 If you find a bug using JDBC interpreter, please create a [JIRA](https://issues.apache.org/jira/browse/ZEPPELIN)
ticket.


Mime
View raw message