<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Can you log a JIRA case? Also supply a PR if you have a fix.<div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Apr 13, 2017, at 12:32 AM, Kaushik Chandrashekar <<a href="mailto:kaushik@zedo.com" class="">kaushik@zedo.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi all,<div class=""><br class=""></div><div class="">I am developing an application using mondrian 4 (4.6.0.0-25) with olap4j.</div><div class="">Out datasource has a few fact tables having row counts in the range of 19 billion rows.</div><div class=""><br class=""></div><div class="">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: <b class="">mondrian.spi.impl.SqlStatisticsProvider.getTableCardinality(SqlStatisticsProvider.java:52)</b></div><div class=""><br class=""></div><div class="">I get the following failure as a consequence: <span style="color:rgb(38,50,56);font-family:roboto,arial,sans-serif;font-size:13px" class=""><b class="">com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.9001263577E10' in column '1' is outside valid range for the datatype INTEGER</b></span></div><div class=""><span style="color:rgb(38,50,56);font-family:roboto,arial,sans-serif;font-size:13px" class=""><b class=""><br class=""></b></span></div><div class=""><span style="color:rgb(38,50,56);font-family:roboto,arial,sans-serif;font-size:13px" class="">How do I go about this issue?<br class=""><br class="">Thanks</span></div></div>
_______________________________________________<br class="">Mondrian mailing list<br class=""><a href="mailto:Mondrian@pentaho.org" class="">Mondrian@pentaho.org</a><br class="">http://lists.pentaho.org/mailman/listinfo/mondrian<br class=""></div></blockquote></div><br class=""></div></body></html>