SYS.HDFS_FLUSH_QUEUE

Immediately flushes all entries in a table's HDFS queue to the configured HDFS store.

See Understanding When Data is Available in HDFS for more information.

Syntax

SYS.HDFS_FLUSH_QUEUE (
  IN FQTN VARCHAR(128),
  IN MAX_WAIT_TIME INTEGER
)
FQTN
The fully-qualified name of the table (schemaname.tablename) to flush to HDFS.
MAX_WAIT_TIME
The maximum length of time, in seconds, to wait for the the flush operation to complete before returning control. Specify zero (0) to block indefinitely until until the queue flushing completes.

Example

Flush the HDFS queue for all buckets of the FLIGHTS table in the APP schema. The procedure does not return control until the flush operation completes, or until 5 minutes have passed:
gfxd> call sys.hdfs_flush_queue('APP.FLIGHTS', 300);
Statement executed.