Increase code coverage for pinot-spi

[jackjlli]

This is a sub-issue of #5150.

The goal is to increase the code coverage of pinot-spi to at least 75%.

[xiangfu0]

Closing — no longer actionable. This was a generic coverage tracking issue from 2020. Code coverage for pinot-spi has increased organically over time.