[Mondrian] Failure to get table cardinality for large fact table

Kaushik Chandrashekar kaushik at zedo.com
Thu Apr 13 03:32:09 EDT 2017

Hi all,

I am developing an application using mondrian 4 ( with olap4j.
Out datasource has a few fact tables having row counts in the range of 19
billion rows.

The function to get table cardinality uses int and not long. This puts a
constraint on max row size of any table to be lesser than 2,147,483,647 (a
little over 2 billion). Class/method ref:

I get the following failure as a consequence:
'1.9001263577E10' in column '1' is outside valid range for the datatype

How do I go about this issue?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20170413/1800a317/attachment.html 

More information about the Mondrian mailing list