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

[Julian Hyde]

Looks as if the error is coming from the MySQL JDBC driver. It can’t handle row count larger than Integer.MAX_VALUE (2^31).

What version are you using? Did you try a more recent version?

(Recent versions of JDBC have been adding support for 64 bit counts, e.g. Statement.getLargeMaxRows() is a 64-bit variant of Statement.getMaxRows().)


> On Apr 13, 2017, at 3:58 AM, Ravi Prakash <ravi.prakash.shahi at gmail.com> wrote:
> 
> 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; 
> }
> 
> _______________________________________________
> 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/a54c472f/attachment.html