# SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary System pre-emptive loading partitions How far fetching ahead has got, one row per candidate and partition: the state, the rows and calls spent so far, and why it last waited or stopped. Read while a session is idle it shows the loading move. Live session state rather than a log. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `plp` - Label: System pre-emptive loading partitions This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `SYSTEMPREEMPTIVELOADINGPARTITIONS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BYTES_WRITTEN` | `int64` | Bytes Written | ☑ | Number of bytes received and written to the local caches on its behalf. | | `CALLS_SPENT` | `int64` | Calls Spent | ☑ | Number of calls to the platform spent on it so far. | | `CANDIDATE_ID` | `int64` | Candidate | ☑ | Identity of the candidate this work belongs to, as reported by SystemPreemptiveLoadCandidates. | | `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Data Container Alias | ☐ | Alias of the data container. | | `ESTIMATED_NUMBER_OF_ROWS` | `int64` | Estimated Number Of Rows | ☐ | Number of rows expected in total, against which the rows loaded read as progress. | | `FAILURE_COUNT` | `int32` | Number Of Failures | ☑ | Number of times fetching it failed. | | `FINISHED_DATE_UTC` | `datetime` | Finished Date | ☐ | Moment the work reached an end (UTC), or empty while it may still run. | | `LAST_REASON` | `varchar2(1024)` | Reason | ☐ | Why it last waited, was dropped or was given up. | | `PARTITION_CODE` | `varchar2(240)` | Partition | ☐ | Partition being fetched, or empty for an object which has no partitions. | | `PAUSE_COUNT` | `int32` | Number Of Pauses | ☑ | Number of times it stopped to leave the connection to the user. | | `ROWS_LOADED` | `int64` | Rows Loaded | ☑ | Number of rows brought in so far. | | `STARTED_DATE_UTC` | `datetime` | Started Date | ☐ | Moment the work started for the first time (UTC), or empty when it never ran. | | `STATE` | `varchar2(32)` | State | ☑ | Where it stands: 'Offered', 'Scheduled', 'Running', 'Paused', 'Deferred', 'Done', 'Dropped' or 'Abandoned'. | | `TABLE_NAME` | `varchar2(240)` | Table | ☑ | Name of the table, table function or view. |