Procedures

GemFire XD provides built-in system procedures to help you manage the distributed system. For example, you can use system procedures to export or import data, install required JAR files, and install listener implementations.

Note: If you enable SQL authorization, you must use the GRANT command to grant normal users permission to use these procedures.
GemFire XD procedures are available for the following categories of distributed system operations:
Table 1. GemFire XD built-in procedures
Category Procedures
Callback configuration

ADD_LISTENER

ATTACH_LOADER

ATTACH_WRITER

REMOVE_LISTENER

REMOVE_LOADER

REMOVE_WRITER

START_ASYNC_EVENT_LISTENER

STOP_ASYNC_EVENT_LISTENER

WAIT_FOR_SENDER_QUEUE_FLUSH

Data export and import

EXPORT_QUERY

EXPORT_TABLE

IMPORT_DATA

IMPORT_DATA_EX

IMPORT_DATA_LOBS_FROM_EXTFILE

IMPORT_TABLE

IMPORT_TABLE_EX

IMPORT_TABLE_LOBS_FROM_EXTFILE

Disk store and HDFS store management

DISKSTORE_FSYNC

HDFS_FLUSH_QUEUE

HDFS_FORCE_COMPACTION

HDFS_FORCE_WRITEONLY_FILEROLLOVER

Heap and off-heap configuration

SET_CRITICIAL_HEAP_PERCENTAGE

SET_CRITICIAL_HEAP_PERCENTAGE_SG

SET_CRITICIAL_OFFHEAP_PERCENTAGE

SET_CRITICIAL_OFFHEAP_PERCENTAGE_SG

SET_EVICTION_HEAP_PERCENTAGE

SET_EVICTION_HEAP_PERCENTAGE_SG

SET_EVICTION_OFFHEAP_PERCENTAGE

SET_EVICTION_OFFHEAP_PERCENTAGE_SG

JAR installation and management

INSTALL_JAR

REMOVE_JAR

REPLACE_JAR

Partitioned table bucket management

CREATE_ALL_BUCKETS

REBALANCE_ALL_BUCKETS

Statement and statistics management

CANCEL_STATEMENT

EMPTY_STATEMENT_CACHE

SET_EXPLAIN_CONNECTION

SET_STATISTICS_TIMING

SET_GLOBAL_STATEMENT_STATISTICS

SET_QUERYSTATS

Troubleshooting

DUMP_STACKS

SET_TRACE_FLAG

User credentials

CHANGE_PASSWORD

CREATE_USER

SHOW_USERS

WAN configuration

ATTACH_GATEWAY_EVENT_ERROR_HANDLER

INCREMENT_TABLE_VERSION

REMOVE_GATEWAY_EVENT_ERROR_HANDLER

START_GATEWAYSENDER

STOP_GATEWAYSENDER

WAIT_FOR_SENDER_QUEUE_FLUSH

See also the function: GET_TABLE_VERSION.