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