SYSHADOOP.BIGSQL_PROPERTIES view

The SYSHADOOP.BIGSQL_PROPERTIES view returns the set of properties that are currently set for the session of the current user by using the SET HADOOP PROPERTY command.

The SYSHADOOP.BIGSQL_PROPERTIES view returns the following result set:

Table 1. SYSHADOOP.BIGSQL_PROPERTIES view
Column	Type	Description
Name	VARCHAR(128)	The name of the property.
Value	VARCHAR(4096)	The value of the property.

Examples

To change the default setting for ORC stripe size in this session by using the SET HADOOP PROPERTY command, run the following command:

SET HADOOP PROPERTY dfsio.orc_rr_size=128

Find all of the properties that the current user has set by running the following SELECT statement:

SELECT varchar(name,30) as name, varchar(value, 25) as value from syshadoop.bigsql_properties

An example of the returned output:


+---------------------+----------+
| NAME                | VALUE    |
+---------------------+----------+
| dfsio.orc_rr_size   |  128     |
+---------------------+----------+

The returned output is blank if the user did not set any properties.