BIGSQL_PROPERTIES

The 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 statement.

The BIGSQL_PROPERTIES view returns the following result set:

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

Examples

Find all of the properties that the current user has set by using the SET HADOOP PROPERTY:


SET HADOOP PROPERTY bigsql.string.size=4096;
SELECT * FROM SYSHADOOP.BIGSQL_PROPERTIES;


+---------------------+----------+
| NAME                | VALUE    |
+---------------------+----------+
| bigsql.string.size  | 4096     |
+---------------------+----------+

The output is blank if the user has set no properties.