Pivot is a web-based exploratory visualization UI for Druid built on top of Plywood.

The project is currently in the alpha stage and is undergoing rapid development. Internal and external APIs may change with little notice.

Drag-and-drop UI

Time series exploration

Make sure you have node (4.x.x) installed. On MacOS with homebrew you can do:

brew update
brew install node

Next simply run:

npm i -g imply-pivot

That's it. You are ready to Pivot.

Start of by running an example (static) dataset:

pivot --example wiki

Next connect Pivot to your broker by simply pointing it to your broker host

pivot --druid your.druid.broker.host:8082

Pivot will automatically introspect your Druid cluster and figure out your dimensions and measures.

Note: if Pivot starts up and gives you a query error it is most likely because it could not determine your schema. You probably have some hyperUnique column that Pivot is trying to SUM over. You will have to provide Pivot with a config your choice is ether to write a full config or to make a tiny config that simply tells Pivot about the hyperUnique measures.

In general Pivot will never know your schema as well as you do so to get a better experience you might want to define a config file and pass it along. Have a look at a the sample config file included in this repo to learn what properties are supported.

pivot --druid your.druid.broker.host:8082 --config /path/to/your/config/file.yaml

Firstly make sure you have gulp installed globally:

npm i -g gulp

Clone the project

git clone [email protected]:implydata/pivot.git
cd pivot

Also make sure you have the SASS lint gem:

gem install scss_lint

Next, inside the pivot folder run:

npm install
gulp

Finally you have to create a config.yaml file. (or use the sample)

For information on what goes into the config please read the comments in the sample config file

cp config.yaml.sample config.yaml

Then you are ready to

./bin/pivot --config config.yaml

We will be working on:

• Better time selection
• Time comparison visualization
• Additional visualizations
• Exclusion filters
• Being able to easily embed Pivot in your app
• Various additions, improvements and fixes to make the app more complete

Please direct all questions to our user groups.