[Mondrian] Mondrian | Fact table with rows more than 2Billion

Ravi Prakash ravi.prakash.shahi at gmail.com
Thu Apr 13 06:58:52 EDT 2017

Hi, My fact table has rows more than 2Billion, Mondrian gives error while
making the row count request because 2 Billion is more than Integer.MAX

*Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException:
'1.9486679643E10' in column '1' is outside valid range for the datatype

Below piece of code from here
the error.

try {
    ResultSet resultSet = stmt.getResultSet();
    if (resultSet.next()) {
       * return resultSet.getInt(1);*
    return -1;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20170413/a3b028e6/attachment.html 

More information about the Mondrian mailing list