{"id":4933,"date":"2019-07-15T11:23:22","date_gmt":"2019-07-15T09:23:22","guid":{"rendered":"http:\/\/blog.via-internet.de\/?p=4933"},"modified":"2019-07-15T11:23:22","modified_gmt":"2019-07-15T09:23:22","slug":"apache-zeppelin-getting-started","status":"publish","type":"post","link":"https:\/\/via-internet.de\/blog\/2019\/07\/15\/apache-zeppelin-getting-started\/","title":{"rendered":"Apache Zeppelin | Getting Started"},"content":{"rendered":"\n

First Steps with Zeppelin<\/h2>\n\n\n\n

Zeppelin and MySQL<\/h2>\n\n\n\n

Create a new Interpreter<\/h3>\n\n\n\n

Create a new interpreter<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

or confgure existing mysql interpreter<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Configure Mysql Interpreter<\/h3>\n\n\n\n

Under artifact, add absoulte path of mysql-connector-java-8.0.19.jar<\/code>. <\/p>\n\n\n\n

Add\/modify properties for<\/p>\n\n\n\n

default.user<\/p>\n\n\n\n

default.password<\/p>\n\n\n\n

Prepare MySQL Database<\/h3>\n\n\n\n

Create a database user spark with password spark<\/p>\n\n\n\n

<\/p>\n\n\n\n

Create a database spark wirth all permissions to user spark<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Add demo values<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Test Mysql Conection<\/h3>\n\n\n\n

Create a new notebook with mysql interpreter<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Write sample code<\/p>\n\n\n\n

select * from spark.demo;<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Installation<\/h2>\n\n\n\n
Install with Docker<\/h3>\n\n\n\n
docker run -p 8080:8080 \u2014 rm \u2014 name zeppelin apache\/zeppelin:0.8.1<\/pre>\n\n\n\n
Set docker volume options to persist notebooks and logs like<\/p>\n\n\n\n
docker run -p 8080:8080 \u2014 rm -v $PWD\/logs:\/logs -v $PWD\/notebook:\/notebook -e ZEPPELIN_LOG_DIR=\u2019\/logs\u2019 -e ZEPPELIN_NOTEBOOK_DIR=\u2019\/notebook\u2019 \u2014 name zeppelin apache\/zeppelin:0.8.1<\/pre>\n\n\n\n
Install in a vagrant box<\/h3>\n\n\n\n
Setup base Vagrant Box<\/h4>\n\n\n\n
vagrant init ubuntu\/trusty64\nvagrant up\nvagrant ssh<\/pre>\n\n\n\n
Update Operating System<\/h4>\n\n\n\n
sudo apt-get update -y\nsudo apt-get upgrade -y<\/pre>\n\n\n\n
Install the Vagrant Key<\/h4>\n\n\n\n
The only way that all the vagrant commands will be able to communicate over ssh from the host machine to the guest server is if the guest server has this \u201cinsecure vagrant key\u201d installed. It\u2019s called \u201cinsecure\u201d because essentially everyone has this same key and anyone can hack into everyone\u2019s vagrant box if you use it.<\/p>\n\n\n\n
mkdir -p \/home\/vagrant\/.ssh\nchmod 0700 \/home\/vagrant\/.ssh\nwget --no-check-certificate \\\n    https:\/\/raw.github.com\/mitchellh\/vagrant\/master\/keys\/vagrant.pub \\\n    -O \/home\/vagrant\/.ssh\/authorized_keys\nchmod 0600 \/home\/vagrant\/.ssh\/authorized_keys\nchown -R vagrant \/home\/vagrant\/.ssh<\/pre>\n\n\n\n
Install Zeppelin and required Software<\/h4>\n\n\n\n
Detailed description can be found here<\/a>.<\/p>\n\n\n\n
sudo apt-get install -y gcc build-essential linux-headers-server\nsudo apt-get install git\nsudo apt-get install openjdk-7-jdk\nsudo apt-get install npm\nsudo apt-get install libfontconfig\nsudo apt-get install r-base-dev\nsudo apt-get install r-cran-evaluate<\/pre>\n\n\n\n
git clone https:\/\/github.com\/apache\/zeppelin.git\nsudo apt-get -y install maven\nmvn clean package -DskipTests -Pspark-2.0 -Phadoop-2.4 -Pr -Pscala-2.11<\/pre>\n\n\n\n
Configure Zeppelin<\/h2>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
First Steps with Zeppelin Zeppelin and MySQL Create a new Interpreter Create a new interpreter or confgure existing mysql interpreter Configure Mysql Interpreter Under artifact, add absoulte path of mysql-connector-java-8.0.19.jar. Add\/modify properties for default.user default.password Prepare MySQL Database Create a database user spark with password spark Create a database spark wirth all permissions to user spark Add demo values Test Mysql Conection Create a new notebook with mysql interpreter Write sample code Installation Install with Docker Set docker volume options to persist notebooks and logs like Install in a vagrant box Setup base Vagrant Box Update Operating System Install the Vagrant […]<\/p>\n","protected":false},"author":1,"featured_media":4937,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[],"class_list":["post-4933","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apache","category-apache-zeppelin"],"jetpack_featured_media_url":"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2019\/07\/Bildschirmfoto-2019-07-15-um-11.22.19.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/4933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/comments?post=4933"}],"version-history":[{"count":0,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/4933\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media\/4937"}],"wp:attachment":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media?parent=4933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/categories?post=4933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/tags?post=4933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}