SET HADOOP PROPERTY command

Use the SET HADOOP PROPERTY command to set Hadoop job properties for the current session.

Read syntax diagramSkip visual syntax diagram SET HADOOP PROPERTY name=value

Setting a HADOOP property

The following example shows how to set a job property:
SET HADOOP PROPERTY mapred.child.java.opts=-Xmx800m;
Important: Any Hadoop property that affects DDL (such as bigsql.string.size or bigsql.binary.size) has an effect that lasts only as long as the session within which it is set. Because of this, if you have not disabled the automatic syncing of the Db2 Big SQL catalog and the Hive metastore, such effects are reverted almost immediately. To avoid this issue, be sure to set such properties at the product level, either from the Ambari web interface (on HDP) or in the bigsql-conf.xml file.To avoid this issue, be sure to set such properties at the product level in the bigsql-conf.xml file.

Listing settings

Use the SYSHADOOP.BIGSQL_PROPERTIES view to list the Hadoop properties that are set for the current session.
SELECT * from SYSHADOOP.BIGSQL_PROPERTIES;

Example

Change the default behavior of the STRING data type. By default, the STRING data type maps to the SQL data type of VARCHAR(32762), which might use more storage than you need. The following example changes the size to VARCHAR(4096):
SET HADOOP PROPERTY 'bigsql.string.size'=4096;