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

Julian Hyde julianhyde at gmail.com
Thu Apr 13 15:37:30 EDT 2017

Can you log a JIRA case? Also supply a PR if you have a fix.

> On Apr 13, 2017, at 12:32 AM, Kaushik Chandrashekar <kaushik at zedo.com> wrote:
> 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: 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
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

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

More information about the Mondrian mailing list