question Impala data model in Archives of Support Questions (Read Only)

Impala data model

Suresh12 — Fri, 16 Sep 2022 10:08:04 GMT

What's the best approach to follow to structure data files for Impala tables either flat file fully denormalised into a single file vs star schema model? This use case for integration with BI tools like Microstrategy with Impala.

Re: Impala data model

alex.behm — Wed, 09 Mar 2016 23:57:41 GMT

Unless you have a very strong reason to try a different approach I'd recommend the star schema model. The benefit is mostly that this model is so prevalent that I'd expect the integration with third party tools to be more smooth than with other "fancier" approaches.

Re: Impala data model

Suresh12 — Thu, 10 Mar 2016 23:24:20 GMT

I agree - just that some references were made to say flat file structures are efficient for Hadoop compare to start scheme structure interms of efficient for IO performance. But as you said it's very important to model it in a way it can work with BI tools.