Initiates a major compaction cycle for a table that is configured with HDFS read/write
IN FQTN VARCHAR(128),
IN MAX_WAIT_TIME INTEGER
- The fully-qualified name of the table (schemaname.tablename) to compact.
The table that you specify must use HDFS read/write persistence in order to
compact the persisted data.
- The maximum amount of time, in seconds, to wait for the compaction cycle to
complete. Specify zero (0) to block indefinitely until compaction
Perform major compaction for persisted HDFS data for the FLIGHTS table in the APP schema. The
procedure does not return control until the compaction completes:
gfxd> call sys.hdfs_force_compaction('APP.FLIGHTS', 0);