MOVE_STATEMENT_TO_RESOURCE_POOL
Attempts to move the specified query to the specified target pool.
Syntax
MOVE_STATEMENT_TO_RESOURCE_POOL (session_id , transaction_id, statement_id, target_resource_pool_name)
Parameters
session_id
|
Identifier for the session where the query you want to move is currently executing. |
transaction_id
|
Identifier for the transaction within the session. |
statement_id
|
Unique numeric ID for the statement you want to move. |
target_resource_pool_name
|
Name of the existing resource pool to which you want to move the specified query. |
Outputs
The function may return the following results:
| MOV_REPLAN: Target pool does not have sufficient resources. See v_monitor.resource_pool_move for details. Vertica will attempt to replan the statement on target pool. |
| MOV_REPLAN: Target pool has priority HOLD. Vertica will attempt to replan the statement on target pool. |
| MOV_FAILED: Statement not found. |
| MOV_NO_OP: Statement already on target pool. |
| MOV_REPLAN: Statement is in queue. Vertica will attempt to replan the statement on target pool. |
| MOV_SUCC: Statement successfully moved to target pool. |
Privileges
Superuser
Examples
The following example shows how you can move a specific statement to a resource pool called my_target_pool:
=> SELECT MOVE_STATEMENT_TO_RESOURCE_POOL ('v_vmart_node0001.example.-31427:0x82fbm', 45035996273711993, 1, 'my_target_pool');