[Feature Request]: Support compression and real time building for Secondary index

[yangzq50]

Is there an existing issue for the same feature request?

• [X] I have checked the existing issues.

Is your feature request related to a problem?

No response

Describe the feature you'd like

Subtask #476 Both columnar value as well as row_ids are required to be compressed. Subtask #477 The secondary index should be able to be built together with data ingestion.

Describe implementation you've considered

No response

Documentation, adoption, use case

No response

Additional information

No response