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 |