The available_memory_on_jvm function returns the memory statistics of the JVM on each node.
Syntax
SELECT * FROM available_memory_on_jvm (input);
Input
Ignored. Use the empty table NC_SYSTEM.NC_DUMMY (or any other table).
Schema of Output
Column Name | Description |
---|---|
NodeIp | IP address of the node that hosts the data. |
Total_Memory_Bytes | Total memory available to a JVM. |
Available_Memory_Bytes | Free memory available for each JVM across the node. |
Example
SQL-MapReduce call:
SELECT * FROM available_memory_on_jvm (ON NC_SYSTEM.NC_DUMMY);
Output:
NodeIp | Total_Memory_Bytes | Available_Memory_Bytes |
---|---|---|
10.80.165.81 | 30408704 | 24972272 |
10.80.165.82 | 30408704 | 24971560 |