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.


Solution:


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/kylin.properties 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