记一次 Centos7.x 安装、部署 Zeppelin v0.9.0 并配置 PostgreSql 数据库

Love The Way You Lie 2023-01-01 03:48 250阅读 0赞

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70]

# 一、基本信息 #

官网 [http://zeppelin.apache.org/][http_zeppelin.apache.org]  
官方下载 [http://zeppelin.apache.org/download.html][http_zeppelin.apache.org_download.html]  
[https://mirror.bit.edu.cn/apache/zeppelin/zeppelin-0.9.0/zeppelin-0.9.0-bin-all.tgz][https_mirror.bit.edu.cn_apache_zeppelin_zeppelin-0.9.0_zeppelin-0.9.0-bin-all.tgz]  
[https://mirrors.bfsu.edu.cn/apache/zeppelin/zeppelin-0.9.0/zeppelin-0.9.0-bin-all.tgz][https_mirrors.bfsu.edu.cn_apache_zeppelin_zeppelin-0.9.0_zeppelin-0.9.0-bin-all.tgz]  
[https://mirrors.tuna.tsinghua.edu.cn/apache/zeppelin/zeppelin-0.9.0/zeppelin-0.9.0-bin-all.tgz][https_mirrors.tuna.tsinghua.edu.cn_apache_zeppelin_zeppelin-0.9.0_zeppelin-0.9.0-bin-all.tgz]  
官方教程 [http://zeppelin.apache.org/docs/0.8.0/quickstart/install.html][http_zeppelin.apache.org_docs_0.8.0_quickstart_install.html]  
开源中国 [https://www.oschina.net/p/zeppelin-qihoo360?hmsr=aladdin1e1][https_www.oschina.net_p_zeppelin-qihoo360_hmsr_aladdin1e1]  
安装 [https://my.oschina.net/u/2000675/blog/1941664][https_my.oschina.net_u_2000675_blog_1941664]  
gitee [https://gitee.com/mirrors/Zeppelin][https_gitee.com_mirrors_Zeppelin]

# 二、与其他组件的兼容性 #

<table> 
 <thead> 
  <tr> 
   <th>Zeppelin</th> 
   <th>0.8.1</th> 
   <th>0.8.0</th> 
   <th>0.7.3</th> 
   <th>0.7.1 - 0.7.2</th> 
   <th>0.7.0</th> 
   <th>0.6.2 - 0.6.1</th> 
   <th>0.6.0</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>Spark</td> 
   <td>1.5.x, 1.6.x, 2.0.x, 2.1.x, 2.2.x, 2.3.x, 2.4.0</td> 
   <td>1.5.x, 1.6.x, 2.0.x, 2.1.x, 2.2.x, 2.3.1</td> 
   <td>1.4.x, 1.5.x, 1.6.x, 2.0.x, 2.1.x, 2.2.0</td> 
   <td>1.4.x, 1.5.x, 1.6.x, 2.0.x 2.1.0</td> 
   <td>1.4.x, 1.5.x, 1.6.x, 2.0.x 2.1.0</td> 
   <td>1.1.x, 1.2.x, 1.3.x, 1.4.x, 1.5.x, 1.6.x, 2.0.0 Support Scala 2.11</td> 
   <td>1.1.x, 1.2.x, 1.3.x, 1.4.x, 1.5.x, 1.6.x SparkR is available</td> 
  </tr> 
  <tr> 
   <td>JDBC</td> 
   <td>PostgreSQL, MySQL, MariaDB, Redshift,Hive, Phoenix, Drill, Tajo are available</td> 
   <td>PostgreSQL, MySQL, MariaDB, Redshift,Hive, Phoenix, Drill, Tajo are available</td> 
   <td>PostgreSQL, MySQL, MariaDB, Redshift,Hive, Phoenix, Drill, Tajo are available</td> 
   <td>PostgreSQL, MySQL, MariaDB, Redshift,Hive, Phoenix, Drill, Tajo are available</td> 
   <td>PostgreSQL, MySQL, MariaDB, Redshift,Hive, Phoenix, Drill, Tajo are available</td> 
   <td>PostgreSQL, MySQL, MariaDB, Redshift,Hive, Phoenix, Drill, Tajo are available</td> 
   <td>PostgreSQL, MySQL, MariaDB, Redshift,Hive, Phoenix, Drill, Tajo are available</td> 
  </tr> 
  <tr> 
   <td>Pig</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>N/A</td> 
   <td>N/A</td> 
  </tr> 
  <tr> 
   <td>Beam</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>N/A</td> 
   <td>N/A</td> 
  </tr> 
  <tr> 
   <td>Scio</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>N/A</td> 
   <td>N/A</td> 
  </tr> 
  <tr> 
   <td>BigQuery</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>N/A</td> 
  </tr> 
  <tr> 
   <td>Python</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Livy</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>HDFS</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Alluxio</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Hbase</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Scalding</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Elasticsearch</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Angular</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Markdown</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Shell</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Flink</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Cassandra</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Geode</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Ignite</td> 
   <td>1.9.0</td> 
   <td>1.9.0</td> 
   <td>1.9.0</td> 
   <td>1.9.0</td> 
   <td>1.7.0</td> 
   <td>1.7.0</td> 
   <td>1.6.0</td> 
  </tr> 
  <tr> 
   <td>Kylin</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>Lens</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
  <tr> 
   <td>PostgreSQL</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
   <td>O</td> 
  </tr> 
 </tbody> 
</table>

# 三、安装、部署 #

1、安装OpenJDK1.8 并查看安装位置  
参考：[https://blog.csdn.net/llwy1428/article/details/111144659][https_blog.csdn.net_llwy1428_article_details_111144659]  
2、下载文件

[root@loaclhost ~]# yum install -y wget vim
    [root@loaclhost ~]# wget -P /usr/bigdata/ https://mirror.bit.edu.cn/apache/zeppelin/zeppelin-0.9.0/zeppelin-0.9.0-bin-all.tgz

3、进入目录

[root@loaclhost ~]# mkdir -p /usr/bigdata/
    [root@loaclhost ~]# cd /usr/bigdata/

4、查看目录

[root@loaclhost bigdata]# ll zeppelin-0.9.0-bin-all

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 1]  
5、进入配置文件目录

[root@loaclhost zeppelin-0.9.0-bin-all]# cd conf/

查看目录  
![在这里插入图片描述][20201231111701831.png]  
6、复制、重命名 配置文件 zeppelin-env.sh

[root@loaclhost conf]# cp zeppelin-env.sh.template zeppelin-env.sh

7、编辑配置文件 zeppelin-env.sh

[root@loaclhost conf]# vim zeppelin-env.sh

8、编辑以下内容  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 2]  
9、编辑配置文件 zeppelin-site.xml.template

[root@loaclhost conf]# vim zeppelin-site.xml.template

10、编辑内容

<property>
      <name>zeppelin.server.addr</name>
      <value>0.0.0.0</value> 
      <description>Server binding address</description>
    </property>
    <property>
      <name>zeppelin.server.port</name>
      <value>8080</value>
      <description>Server port.</description>
    </property>

11、进入 bin 目录

[root@loaclhost ~]# cd /usr/bigdata/zeppelin-0.9.0-bin-all/bin

12、启动服务

[root@loaclhost bin]# ./zeppelin-daemon.sh start

13、启动效果  
Please specify HADOOP\_CONF\_DIR if USE\_HADOOP is true  
Log dir doesn’t exist, create /usr/bigdata/zeppelin-0.9.0-bin-all/logs  
Pid dir doesn’t exist, create /usr/bigdata/zeppelin-0.9.0-bin-all/run  
Zeppelin start \[ OK \]  
14、查看服务启动后的进程情况

[root@loaclhost bin]# netstat -lntp
    tcp        0      0 0.0.0.0:8080            0.0.0.0:*               LISTEN      14121/java
    
    [root@loaclhost bin]# jps -l
    14121 org.apache.zeppelin.server.ZeppelinServer

15、停止服务

[root@loaclhost bin]# ./zeppelin-daemon.sh stop

16、重启服务

[root@loaclhost bin]# ./zeppelin-daemon.sh restart

# 四、浏览器查看 #

1、在地址栏录入 zeppelin 服务所在节点的 IP 及服务端口 8080 http://192.168.11.21:8080/  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 3]  
2、新增解释器，分组为jdbc  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 4]  
3、已经创建成功的解释器  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 5]  
4、配置 JDBC 相关参数  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 6]

jdbc:postgresql://数【据库IP或主机名】:5432/【数据库名称】?useUnicode=true&characterEncoding=utf8

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 7]  
5、把 postgresql jdbc 的驱动包放在 /usr/bigdata/zeppelin-0.9.0-bin-all/lib/ 路径下  
填写驱动包配置信息

/usr/bigdata/zeppelin-0.9.0-bin-all/lib/postgresql-42.2.5.jar

![在这里插入图片描述][20201231115144854.png]  
6、编写统计查询sql，查看分析结果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 8]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 9]

其他操作参考官方文档：[http://zeppelin.apache.org/docs/0.8.0/quickstart/install.html][http_zeppelin.apache.org_docs_0.8.0_quickstart_install.html]

至此，Centos7.x 安装、部署 Zeppelin 0.9.0 并配置 PostgreSql 数据库操作完毕，希望能够对您有所帮助！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70]: /images/20221120/b12db7860dcd428aaaf8f214a9fc590a.png
[http_zeppelin.apache.org]: http://zeppelin.apache.org/
[http_zeppelin.apache.org_download.html]: http://zeppelin.apache.org/download.html
[https_mirror.bit.edu.cn_apache_zeppelin_zeppelin-0.9.0_zeppelin-0.9.0-bin-all.tgz]: https://mirror.bit.edu.cn/apache/zeppelin/zeppelin-0.9.0/zeppelin-0.9.0-bin-all.tgz
[https_mirrors.bfsu.edu.cn_apache_zeppelin_zeppelin-0.9.0_zeppelin-0.9.0-bin-all.tgz]: https://mirrors.bfsu.edu.cn/apache/zeppelin/zeppelin-0.9.0/zeppelin-0.9.0-bin-all.tgz
[https_mirrors.tuna.tsinghua.edu.cn_apache_zeppelin_zeppelin-0.9.0_zeppelin-0.9.0-bin-all.tgz]: https://mirrors.tuna.tsinghua.edu.cn/apache/zeppelin/zeppelin-0.9.0/zeppelin-0.9.0-bin-all.tgz
[http_zeppelin.apache.org_docs_0.8.0_quickstart_install.html]: http://zeppelin.apache.org/docs/0.8.0/quickstart/install.html
[https_www.oschina.net_p_zeppelin-qihoo360_hmsr_aladdin1e1]: https://www.oschina.net/p/zeppelin-qihoo360?hmsr=aladdin1e1
[https_my.oschina.net_u_2000675_blog_1941664]: https://my.oschina.net/u/2000675/blog/1941664
[https_gitee.com_mirrors_Zeppelin]: https://gitee.com/mirrors/Zeppelin
[https_blog.csdn.net_llwy1428_article_details_111144659]: https://blog.csdn.net/llwy1428/article/details/111144659
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 1]: /images/20221120/ff527192a4ef455abd3f5c216b6082a6.png
[20201231111701831.png]: https://img-blog.csdnimg.cn/20201231111701831.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201231113446169.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201231113658131.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201231113730643.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20201231123303108.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20201231123348985.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20201231123221635.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4,size_16,color_FFFFFF,t_70
[20201231115144854.png]: https://img-blog.csdnimg.cn/20201231115144854.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20201231123600728.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20201231122912791.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4,size_16,color_FFFFFF,t_70