SYSHADOOP.HCAT_SCHEMAPROPS view

The SYSHADOOP.HCAT_SCHEMAPROPS view shows schema properties for all Db2 schemas that are also defined by the Hive catalogs. The contents of this view might not be available if the Hive metastore is unavailable.

When you access the SYSHADOOP.HCAT_SCHEMAPROPS view, you are querying the Hive metastore for each table that is returned. If you filter the set of tables that you want to view by SCHEMANAME, you can improve the access time to this view.

Table 1. SYSHADOOP.HCAT_SCHEMAPROPS view
Column	Type	Description
SCHEMANAME	VARCHAR(128)	The Db2 name of the schema.
HIVESCHEMA	VARCHAR(128)	The name of the schema as defined in the Hive metastore.
PROPNAME	VARCHAR(256)	The name of the schema property.
PROPVALUE	VARCHAR(4000)	The value of the schema property..

Examples

Find the properties of the schemas:

SELECT * FROM SYSHADOOP.HCAT_SCHEMAPROPS;

The result of the query produces three schemas:


+--------------+--------------+--------------------------+-------------------------------------------+
| SCHEMANAME   | HIVESCHEMA   | PROPNAME                 | PROPVALUE                                 |
+--------------+--------------+--------------------------+-------------------------------------------+
| GOSALESDW    | gosalesdw    | biginsights.sql.metadata | {"v":1,"source":"BIGSQL","version":"4.0"} |
| MY_SCHEMA    | my_schema    | biginsights.sql.metadata | {"v":1,"source":"BIGSQL","version":"4.0"} |
| OTHER_SCHEMA | other_schema | biginsights.sql.metadata | {"v":1,"source":"BIGSQL","version":"4.0"} |
+--------------+--------------+--------------------------+-------------------------------------------+