Add a table API to compute partition stats.

[ajantha-bhat]

Feature Request / Improvement

Based on the experiments from #9437, spark action is not effective as the serialization cost of each partition stats entry is expensive.

Need a table API in the core module to compute stats in a distributed way.
Local algorithm will be similar to the POC from #9437

Query engine

None

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'