[Mondrian] Failure to get table cardinality for large fact table
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 (22.214.171.124-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?
> Mondrian mailing list
> Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian