5.8 The rpd_tables Table

The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in HeatWave.

The rpd_tables table has these columns:

• ID

  A unique identifier for the table.

• SNAPSHOT_SCN

  The system change number (SCN) of the table snapshot. The SCN is an internal number that represents a point in time according to the system logical clock that the table snapshot was transactionally consistent with the source table.

• PERSISTED_SCN

  The SCN up to which changes are persisted.

• POOL_TYPE

  The load pool type of the table. Possible values are RAPID_LOAD_POOL_SNAPSHOT and RAPID_LOAD_POOL_TRANSACTIONAL.

• DATA_PLACEMENT_TYPE

  The data placement type.

• NROWS

  The number of rows that are loaded for the table. The value is set initially when the table is loaded, and updated as changes are propagated.

• LOAD_STATUS

  The load status of the table. Statuses include:

  • NOLOAD_RPDGSTABSTATE

    The table is not yet loaded.

  • LOADING_RPDGSTABSTATE

    The table is being loaded.

  • AVAIL_RPDGSTABSTATE

    The table is loaded and available for queries.

  • UNLOADING_RPDGSTABSTATE

    The table is being unloaded.

  • INRECOVERY_RPDGSTABSTATE

    The table is being recovered. After completion of the recovery operation, the table is placed back in the UNAVAIL_RPDGSTABSTATE state if there are pending recoveries.

  • UNAVAIL_RPDGSTABSTATE

    The table is unavailable.

• LOAD_PROGRESS

  The load progress of the table expressed as a percentage value.

• SIZE_BYTES

  The amount of data loaded for the table, in bytes.

• QUERY_COUNT

  The number of queries that referenced the table.

• LAST_QUERIED

  The timestamp of the last query that referenced the table.

• LOAD_START_TIMESTAMP

  The load start timestamp for the table.

• LOAD_END_TIMESTAMP

  The load completion timestamp for the table.

The rpd_tables table is read-only.