These restrictions also apply to an INSERT ... SELECT statement included in a CREATE TRIGGER, REPLACE TRIGGER, CREATE MACRO or REPLACE MACRO statement.
LOCAL ORDER BY and NORMALIZE
You cannot specify the NORMALIZE option as part of SELECT in an INSERT ... SELECT statement that includes the LOCAL ORDER BY option.
NOPI Target Table and NORMALIZE
You cannot specify the NORMALIZE option as part of SELECT in an INSERT ... SELECT statement where the target table is defined with NO PRIMARY INDEX.
NORMALIZE in Target Table Definition
You cannot specify the LOCAL ORDER BY option in an INSERT ... SELECT statement where the target table definition includes the NORMALIZE option.
You cannot specify the HASH BY option in an INSERT ... SELECT statement where target table definition includes the NORMALIZE option.