The gc_jvm function prompts the JVMs on each node to start garbage collection. Though the function does not guarantee garbage collection, it might be helpful in a long-running session.
Syntax
SELECT * FROM gc_jvm (input);
Input
Ignored. Use the empty table NC_SYSTEM.NC_DUMMY (or any other table).
Schema of Output
| Column Name | Description |
|---|---|
| Key | This column is empty. |
Example
SQL-MapReduce call:
SELECT * FROM gc_jvm (ON NC_SYSTEM.NC_DUMMY);
Output:
key ----- (0 rows)