question Re: how to create OLAP Cubes on HADOOP data - Impala Database in Archives of Support Questions (Read Only)

how to create OLAP Cubes on HADOOP data - Impala Database

AnisurRehman — Fri, 16 Sep 2022 11:01:07 GMT

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-professionals-dr-ralph-kimball-answers-your-questions/

Question number 10

Regards

Anis

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

mbigelow — Sat, 04 Feb 2017 22:24:13 GMT

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/

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

cjervis — Mon, 06 Feb 2017 13:53:56 GMT

Hi @AnisurRehman,

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