DEPOT_FETCH_QUEUE
Eon Mode only
Lists all pending depot requests for queried file data to fetch from communal storage.
| Column Name | Data Type | Description |
|---|---|---|
| NODE_NAME |
VARCHAR |
Name of the node that requested the fetch. |
| SAL_STORAGE_ID |
VARCHAR |
Unique hexadecimal numeric ID assigned by the Vertica catalog, which identifies the storage. |
| TRANSACTION_ID |
INTEGER |
Identifies the transaction that contains the fetch-triggering query. |
| SOURCE_FILE_NAME |
VARCHAR |
Full path in communal storage of the file to fetch. |
| DESTINATION_FILE_NAME |
VARCHAR |
Destination path of the file to fetch. |
Example
=> \x
Expanded display is on.
=> SELECT * FROM depot_fetch_queue;
-[ RECORD 1 ]----------+-------------------------------------------------------------
node_name | v_example_db_node0002
sal_storage_id | 029b6fac864e1982531dcde47d00edc500d000000001d5e7
transaction_id | 45035996273705983
source_file_name | s3://mydata/mydb/14a/029b6fac864e1982531dcde47d00edc500d000
000001d5e7_0.gt
destination_file_name | /vertica/example_db/v_example_db_node0002_depot/747/029b6fac
864e1982531dcde47d00edc500d000000001d5eb_0.gt
-[ RECORD 2 ]----------+-------------------------------------------------------------
node_name | v_example_db_node0003
sal_storage_id | 026635d69719c45e8d2d86f5a4d62c7b00b000000001d5e7
transaction_id | 45035996273705983
source_file_name | s3://mydata/mydb/4a5/029b6fac864e1982531dcde47d00edc500d0000
00001d5eb_0.gt
destination_file_name | /vertica/example_db/v_example_db_node0002_depot/751/026635d6
9719c45e8d2d86f5a4d62c7b00b000000001d5e7_0.gt