remote

Executes queries on the remote federation node. If the node fails to connect, the query fails.

Syntax

remote NODE [ SUBQUERY ]
Required Parameter
NODE
The name of the target node on which to execute the query. Provide a federation node identifier after confirming its name from the query results of system nodes.
[ SUBQUERY ]
Subquery command enclosed in a pair of square brackets ([ ]).

Usage

Execute the system tables query on the n1 node

remote n1 [ system tables ]