Reply
New Contributor
Posts: 6
Registered: ‎01-29-2017
Accepted Solution

how to create OLAP Cubes on HADOOP data - Impala Database

Dear Cloudera Community,

 

I am looking for advice on how to create  OLAP Cubes on HADOOP data - Impala Database with  Fact and DIMENSIONS tables.

 

Reference:

 

https://vision.cloudera.com/building-a-hadoop-data-warehouse-hadoop-101-for-enterprise-data-professi...

 

Question number 10

 

Regards

Anis

Posts: 335
Topics: 0
Kudos: 35
Solutions: 26
Registered: ‎08-16-2016

Re: how to create OLAP Cubes on HADOOP data - Impala Database

Depending on your budget and feelings on opensource there are two options to push the accelerator. I haven't dug into either one to talk to how they do it.

If you wanted to just roll your own I'd imagine it would be following the star schema methodology the Kimball is known for in Impala and then just leveraging Impala/HDFS caching to make it as fast as possible.

http://kylin.apache.org/

or

http://www.atscale.com/
Highlighted
Posts: 480
Kudos: 53
Solutions: 26
Registered: ‎04-06-2015

Re: how to create OLAP Cubes on HADOOP data - Impala Database

Hi @AnisurRehman,

 

Did you check out the follow up posts from the series including:

 

 

 




Cy Jervis, Community Moderator - I'm not an expert but will supply relevant content from time to time. :)

Learn more about the Cloudera Community:


Terms of Service


Community Guidelines


How to use the forum

Announcements