SQL commands to set the Hadoop environment. The Data Integration Service executes the environment SQL at the beginning of each Hive script generated in a Hive execution plan.

The following rules and guidelines apply to the usage of environment SQL:

Use the environment SQL to specify Hive queries.
Use the environment SQL to set the classpath for Hive user-defined functions and then use environment SQL or PreSQL to specify the Hive user-defined functions. You cannot use PreSQL in the data object properties to specify the classpath. If you use Hive user-defined functions, you must copy the .jar files to the following directory:
<Informatica installation directory>/services/shared/hadoop/<Hadoop distribution name>/extras/hive-auxjars
You can use environment SQL to define Hadoop or Hive parameters that you want to use in the PreSQL commands or in custom queries.
If you use multiple values for the environment SQL, ensure that there is no space between the values.

Optional. The absolute HDFS file path of the default database for the warehouse that is local to the cluster.

If you do not configure the Hive warehouse directory, the Hive engine first tries to write to the directory specified in the cluster configuration property

hive.metastore.warehouse.dir

. If the cluster configuration does not have the property, the Hive engine writes to the default directory

/user/hive/warehouse

.

List of advanced properties that are unique to the Hive engine. The advanced properties include a list of default properties.

You can configure run-time properties for the Hadoop environment in the Data Integration Service, the Hadoop connection, and in the mapping. You can override a property configured at a high level by setting the value at a lower level. For example, if you configure a property in the Data Integration Service custom properties, you can override it in the Hadoop connection or in the mapping. The Data Integration Service processes property overrides based on the following priorities:

Mapping custom properties set using
infacmd ms runMapping
with the
-cp
option
Mapping run-time properties for the Hadoop environment
Hadoop connection advanced properties for run-time engines
Hadoop connection advanced general properties, environment variables, and classpaths
Data Integration Service custom properties