2.2.3.4 Memory Estimation for String Column Encoding

The auto_enc option is run in check mode by default to ensure that there is enough memory for string column encoding.

The following example uses the auto_enc option in check mode, if you want to ensure that there is sufficient memory for string column encoding before attempting a load operation. Insufficient memory can cause a load failure.

mysql> CALL sys.heatwave_load(JSON_ARRAY("tpch"), 
          JSON_OBJECT("mode","dryrun","auto_enc",JSON_OBJECT("mode","check")));

Note

The auto_enc option runs in check mode regardless of whether it is specified explicitly in the Auto Parallel Load call statement.

Look for capacity estimation data in the Auto Parallel Load output. The results indicate whether there is sufficient memory to load all tables.