[AMBARI-21214] Use a uuid vs long row key for metrics in AMS schema

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: metrics-3.0.0
• Component/s: ambari-metrics
• Epic Link: AMS: Schema changes for nextGen feature support
• Assignee: Aravindan Vijayan
• Reporter: Aravindan Vijayan
• Created: 09/Jun/17 17:29
• Updated: 13/Mar/23 16:28
• Resolved: 22/Jun/17 22:44

Description

Presently we store (metircName, hostname, serverTime, appId, instanceId) for every row.
Although this makes SQL query easy to write, it adds duplication when storing it in the Regions memory.
We should have a unique integer ID for an application-instance metric on a host and use that as a lookup table with a write through cache when inserting or reading data in the METRIC_RECORD table.

Issue Links

• links to: Review Board