SKIP_STRUCTURE_CHECKING

You are looking at an older version of the documentation. The latest version is found here.

This option controls validation of materialized tables structure. It can have the following possible values:

Structure validation algorithm checks correspondence of the materialized table to its source table(s) and whether the materialized table is applicable for further usage. It does this by detecting the following:

• Changes in the structure (one or more columns could be added, removed, or renamed);
• Data type mismatch (the type of one or more columns could be changed).

Example

CALL SYSADMIN.setDefaultOptionValue('SKIP_STRUCTURE_CHECKING', 'FALSE');