Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

how to create OLAP Cubes on HADOOP data - Impala Database

avatar

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

avatar
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/

View solution in original post

avatar
Community Manager

Hi @AnisurRehman,

 

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

 

 


Cy Jervis, Manager, Community Program
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.

View solution in original post

2 REPLIES 2

avatar
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/

avatar
Community Manager

Hi @AnisurRehman,

 

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

 

 


Cy Jervis, Manager, Community Program
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.