SYSHADOOP.HCAT_TABLEPROPS view
The SYSHADOOP.HCAT_TABLEPROPS view shows the table configuration properties for all DATALAKE tables as 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_TABLEPROPS 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 TABSCHEMA and TABNAME, you can improve the access time to this view.
| Column | Type | Description |
|---|---|---|
| TABSCHEMA | VARCHAR(128) | The Db2 schema in which the table resides. |
| TABNAME | VARCHAR(128) | The name of the Db2 table. |
| HIVESCHEMA | VARCHAR(128) | The name of the Hive schema in which the table resides as defined in the Hive metastore. |
| HIVETAB | VARCHAR(128) | The name of the table as defined in the Hive metastore. |
| PROP_NAME | VARCHAR(256) | The name of a property. |
| PROP_VALUE | VARCHAR(4000) | The value of a property. |
Examples
Find the table properties of the first two rows of tables in the GOSALESDW
schema:
SELECT * FROM SYSHADOOP.HCAT_TABLEPROPS WHERE TABSCHEMA='GOSALESDW' FETCH FIRST 2 ROWS ONLY;
+-----------+------------+------------+------------+------------+--------------------+
| TABSCHEMA | TABNAME | HIVESCHEMA | HIVETAB | PROP_NAME | PROP_VALUE |
+-----------+------------+------------+------------+------------+--------------------+
| GOSALESDW | BURST_TABL | gosalesdw | burst_tabl | bigsql.sql.| {"v":1,"source": |
| | E | | e | metadata | "BIGSQL","version" |
| | | | | | :"4.0"} |
| | | | | | |
| GOSALESDW | BURST_TABL | gosalesdw | burst_tabl | transient_ | 1685024374 |
| | E | | e | lastDdlTim | |
| | | | | e | |
+-----------+------------+------------+------------+------------+--------------------+