This message was deleted.

SQL-based ( MSQE) dialect is used for ingestion only. Compaction is done after data is ingestion. This article is a good primer

Also SQL based ingestion generates fully compacted segments in replace mode. You can always do a replace on that interval and no further compaction would be needed on that interval unless new data arrives.