SYS.HDFS_LAST_MAJOR_COMPACTION

Returns the start time of the last completed major compaction cycle for an HDFS read/write table.

See How GemFire XD Manages HDFS Data for more information about GemFire XD compaction for HDFS read/write tables.

See also SYS.HDFS_FORCE_COMPACTION and CREATE HDFSSTORE.

Syntax

SYS.HDFS_LAST_MAJOR_COMPACTION (
)

The returned data type is TIMESTAMP.

Example

This command returns the time of the last major compaction for the HDFS read/write table, FLIGHTAVAILABILITY:
gfxd> values sys.hdfs_last_major_compaction('app.flightavailability');
1                         
--------------------------
2014-11-13 03:45:37.71    

1 row selected