1 Star 0 Fork 0

feitianmao2008 / kylin-mondrian-interaction

Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.
Clone or Download
contribute
Sync branch
Cancel
Notice: Creating folder will generate an empty file .keep, because not support in Git
Loading...
README

Kylin und Mondrain Interaction

Includes patches and jars for Kylin interaction with Mondrian and Saiku.

Pre-installation Requirements

You should be able to run Kylin, to build and create a Kylin Cube successfully. Also you will need a Mondrian 4 Schema, which describes your OLAP Cube in Kylin. In our case we use Cloudera 5.4 Quickstart VM [Download].

Kylin, Mondrian and Saiku Interaction

  1. Download Kylins JDBC or download Kylin Binaries and extract the archive to get the current Kylin JDBC.
  2. Download current Saiku Community Edition.
  3. Download compiled Mondrian 4.4 (Lagunitas) jar with Kylin dialect added (see Mondrian folder) or apply our patch to Mondrian and compile your own Mondrian 4.4 Snapshot.
  4. Download newer Commons HTTPClient.
  5. Extract Saiku (path is now called saiku_root_path).
  6. Go to folder saiku_path/tomcat/webapps/saiku/WEB-INF/lib/
  • add Kylins JDBC jar
  • add the compiled Mondrian 4.4 jar with Kylin dialect
  • add newer Commons HTTPClient jar
  • remove old Mondrian jar
  • remove old Commons HTTPClient jar
  1. Start Saiku (sh start-saiku.sh)
  2. Go to http://localhost:8080/
  • User: admin
  • Password: admin
  1. Click on Admin Console (big A in navigation bar)
  2. Upload your Mondrian Schema
  3. Add a new Data Source:
  • Name: Kylin Data Source
  • Connection Type: Mondrian
  • URL: jdbc:kylin://{your_kylin_url}:7070/{your_project_name}
  • Schema: {your_mondrian_schema}
  • JDBC Driver: org.apache.kylin.jdbc.Driver
  • Username: {your_kylin_username} (Standard: admin)
  • Password: {your_kylin_password} (Standard: KYLIN)

Have fun!

Kylin and Mondrian with Java Application

Take a look into Example Folder.

Empty file

About

No description expand collapse
Cancel

Releases

No release

Contributors

All

Activities

Load More
can not load any more
1
https://gitee.com/feitianmao2008/kylin-mondrian-interaction.git
git@gitee.com:feitianmao2008/kylin-mondrian-interaction.git
feitianmao2008
kylin-mondrian-interaction
kylin-mondrian-interaction
master

Search