Problem Description:

The cube build process fails with the below error in the job log.

java.lang.IllegalStateException: Table snapshot should be no greater than 300 MB.

Root cause:

This issue occurs if there is a huge dimension table with more than 300 MB of data that it used as a look table in the cube design.


Perform the below steps to increase the snapshot size for the dimension table.

a) Set the property value kylin.table.snapshot.max_mb in /opt/Infoworks/cube-engine/conf/ to a higher value based on the dimension table size let' say 3024 (3GB).The default value for this property is 300 MB.

b) Restart the cube-engine service.

c) Run the cube build job.

Applicable Infoworks Versions:

IWX v2.3.x,2.4.x,2.5.x,2.6.x,2.7.x,2.8.x,2.9.x