Installing and Running Lens

Before running Lens, you have to set HIVEHOME and HADOOPHOME. If you want to get more information about this, please refer to here. Lens also provides Pseudo Distributed mode. Lens pseudo-distributed setup is done by using docker. Hive server and hadoop daemons are run as separate processes in lens pseudo-distributed setup.

Now, you can start lens server (or stop).

./bin/lens-ctl start (or stop)

Configuring Lens Interpreter

At the "Interpreters" menu, you can edit Lens interpreter or create new one. Zeppelin provides these properties for Lens.

Property Name

value

Description

lens.client.dbname

default

The database schema name

lens.query.enable.persistent.resultset

false

Whether to enable persistent resultset for queries. When enabled, server will fetch results from driver, custom format them if any and store in a configured location. The file name of query output is queryhandle-id, with configured extensions

lens.server.base.url

http://hostname:port/lensapi

The base url for the lens server. you have to edit "hostname" and "port" that you may use(ex. http://0.0.0.0:9999/lensapi)

Interpreter Binding for Zeppelin Notebook

How to use

You can analyze your data by using OLAP CubeQL which is a high level SQL like language to query and describe data sets organized in data cubes.
You may experience OLAP Cube like this Video tutorial.
As you can see in this video, they are using Lens Client Shell(./bin/lens-cli.sh). All of these functions also can be used on Zeppelin by using Lens interpreter.

These are just examples that provided in advance by Lens. If you want to explore whole tutorials of Lens, see the tutorial video.

Lens UI Service

Lens also provides web UI service. Once the server starts up, you can open the service on http://serverhost:19999/index.html and browse. You may also check the structure that you made and use query easily here.