HCAT_TABLEPARTS
The HCAT_TABLEPARTS view shows the partitions for all Db2 Big SQL Hadoop 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 HCAT_TABLEPARTS 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 Big SQL schema in which the table resides. |
| TABNAME | VARCHAR(128) | The name of the Db2 Big SQL 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. |
| CRTIME | INT | The creation time in number of seconds since 1970 UTC. |
| LOCATION | VARCHAR(4000) | The path at which the partition is stored. |
Examples
Find all of the partitions:
SELECT * FROM SYSHADOOP.HCAT_TABLEPARTS;