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

[Ravi Prakash]

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
value.

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

Below piece of code from here
<http://mondrian.pentaho.com/api/src-html/mondrian/spi/impl/SqlStatisticsProvider.html>
gives
the error.

try {
    ResultSet resultSet = stmt.getResultSet();
    if (resultSet.next()) {
        ++stmt.rowCount;
       * 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