It depends on how many nodes you have and their specs. You could do ROLAP with hive-on-tez for one bilion rows. I personally tried it using the ORC fromat, and vectroization, and queries took like 20s with just 3 nodes.
On Mon, Jun 8, 2015 at 6:47 PM, Vineet Mishra <[email protected]> wrote: > Hi, > > I am looking out for the best way to query my aggregated data from Tableau > using any connectivity measure, persisting the data in Hadoop(HDFS) and > retrieving it through any connector/query engine possible. > > For the MOLAP cube of a Billion of records with just 10 or 20 aggregates > what will be the suitable storage and query engine for my use case. > > Urgent Call. Need experts advise! > > Thanks! > -- Med vänlig hälsning (Best Regards) *Jakob Stengård*
