CC_HIVE_ADD_COLNAMES_TO_STATEMENT

Set this environment variable to use column name binding in the INSERT query.

The default value is FALSE. For example, consider the Hive connector in target context with Generate SQL property set to No , and consider a table HTABLE with columns C1 integer, C2 var char, C3 integer. In this scenario, the following statement can be used in the Insert statement property:

INSERT into HTABLE (C1, C2) VALUES (ORCHESTRATE.C1, ORCHESTRATE.C2)