Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

how to create OLAP Cubes on HADOOP data - Impala Database

SOLVED Go to solution

how to create OLAP Cubes on HADOOP data - Impala Database

New Contributor

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

2 ACCEPTED SOLUTIONS

Accepted Solutions

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

Champion
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

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

Community Manager

Hi @AnisurRehman,

 

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

 

 



Cy Jervis, Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:
Community Guidelines
How to use the forum
2 REPLIES 2

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

Champion
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

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

Community Manager

Hi @AnisurRehman,

 

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

 

 



Cy Jervis, Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:
Community Guidelines
How to use the forum