Zeppelin 安装部署

内存3G

下载 zeppelin-0.8.2-bin-all.tgz

解压：

tar xzvf zeppelin-0.8.2-bin-all.tgz -C /opt/

进入到/opt/zeppelin-0.8.2/conf目录下：

cp zeppelin-env.sh.template zeppelin-env.sh
cp zeppelin-site.xml.template zeppelin-site.xml

然后编辑zeppelin-env.sh

vi zeppelin-env.sh 

export JAVA_HOME=/opt/jdk1.8.0_171
export SPARK_HOME=/opt/spark-2.2.0

vi zeppelin-site.xml

<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>8088</value>
  <description>Server port.</description>
</property>

vi  conf/helium.json

{
  "status": "OK",
  "message": "",
  "body": {
    "zeppelin.clock": [
      {
        "registry": "local",
        "pkg": {
          "type": "APPLICATION",
          "name": "zeppelin.clock",
          "description": "Clock (example)",
          "artifact": "zeppelin-examples\/zeppelin-example-clock\/target\/zeppelin-example-clock-0.7.0-SNAPSHOT.jar",
          "className": "org.apache.zeppelin.example.app.clock.Clock",
          "resources": [
            [
              ":java.util.Date"
            ]
          ],
          "icon": "icon"
        },
        "enabled": false
      }
    ],
    "zeppelin-bubblechart": [
      {
        "registry": "local",
        "pkg": {
          "type": "VISUALIZATION",
          "name": "zeppelin-bubblechart",
          "description": "Animated bubble chart",
          "artifact": ".\/..\/helium\/zeppelin-bubble",
          "icon": "icon"
        },
        "enabled": true
      },
      {
        "registry": "local",
        "pkg": {
          "type": "VISUALIZATION",
          "name": "zeppelin-bubblechart",
          "description": "Animated bubble chart",
          "artifact": "zeppelin-bubblechart@0.0.2",
          "icon": "icon"
        },
        "enabled": false
      }
    ],
    "zeppelinhorizontalbar": [
      {
        "registry": "local",
        "pkg": {
          "type": "VISUALIZATION",
          "name": "zeppelinhorizontalbar",
          "description": "Horizontal Bar chart (example)",
          "artifact": ".\/zeppelin-examples\/zeppelin-example-horizontalbar",
          "icon": "icon"
        },
        "enabled": true
      }
    ]
  }
}

启动zeppelin

bin/zeppelin-daemon.sh start

启动成功后,访问http://192.168.1.120:8088

zeppelin_01.png

建立Hive Server2 的jdbc连接

002.png

Name	Value
default.driver	org.apache.hive.jdbc.HiveDriver
default.url	jdbc:hive2://localhost:10000
default.user	hive_user
default.password	hive_password
default.proxy.user.property	Example value: hive.server2.proxy.user

添加依赖：

006.png

/opt/hive-2.2.0/lib/hive-jdbc-2.2.0.jar
/opt/hive-2.2.0/lib/hive-service-2.2.0.jar
/opt/hive-2.2.0/lib/hive-cli-2.2.0.jar
/opt/hive-2.2.0/lib/hive-service-rpc-2.2.0.jar
/opt/hive-2.2.0/lib/hive-common-2.2.0.jar
/opt/hive-2.2.0/lib/hive-serde-2.2.0.jar
/opt/hive-2.2.0/lib/guava-14.0.1.jar```