Estimate number: %2 exceed the DEFAULT_MAX_CUBE_RESULT of GROUP BY CUBE or ROLLUP %1
Item |
Value |
|---|---|
SQLCode |
-1005024L |
Constant |
EMSG_EXCEED_MAX_CUBE_RESULT |
SQLState |
QTA24 |
ODBC State |
ERROR |
Parameter 1 |
location of the exception |
Parameter 2 |
the estimated total result of the hash base cube or rollup |
The actual number of rows the IQ optimizer estimated for the GROUP BY CUBE hash operation has exceeded the MAX_CUBE_RESULT option value. Increase the value of the MAX_CUBE_RESULT option and run the query again. Note that the new MAX_CUBE_RESULT value does not take effect until the server is restarted.
