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.
SYS.HDFS_FLUSH_QUEUE ( IN FQTN VARCHAR(128), IN MAX_WAIT_TIME INTEGER )
- The fully-qualified name of the table (schemaname.tablename) to flush to HDFS.
- 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.
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.