Hi, I did some updates/delete on a native table stored on s3. Now number of files is growing after each update/delete operation. How to compact the table ? is there any sql command, or is this done by the engine automatically ?
it’s done in the backgroundc. you can use show proc '/compactions' ; to check the current compaction tasks. show proc '/dbs/<db>/<table>/partitions'; to check the specific table’s compaction score, have a gut feeling on how far to reach the final compaction status.