Updatable metrics feature only supports sum aggregation function

[mayankshriv]

We can enhance this feature to support other aggregation functions in future. But until then, we should consider whether to flag when queries other than sum() aggregation function are queried.

[Jackie-Jiang]

Solved with #8611