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

Example

To disable the cumulative stats collection on DATALAKE tables in a session when running ANALYZE TABLE, run the following statement:
SET HADOOP PROPERTY 'biginsights.stats.cumulative'='false'
Use the SYSHADOOP.BIGSQL_PROPERTIES view to show the current setting of all of the properties:
SELECT varchar(name,30) as name, varchar(value, 25) as value from syshadoop.bigsql_properties
with the following resulting return:

NAME                           VALUE
------------------------------ -------------------------
biginsights.stats.cumulative   false

1 record(s) selected.