[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 (4.6.0.0-25) 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:
*mondrian.spi.impl.SqlStatisticsProvider.getTableCardinality(SqlStatisticsProvider.java:52)*

I get the following failure as a consequence:
*com.mysql.jdbc.exceptions.jdbc4.MySQLDataException:
'1.9001263577E10' in column '1' is outside valid range for the datatype
INTEGER*

How do I go about this issue?

Thanks
-------------- 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