[AMBARI-20773] AMS: Schema changes for nextGen feature support

• Type: Epic
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: metrics-3.0.0
• Fix Version/s: metrics-3.0.0
• Component/s: ambari-metrics
• Epic Name: AMS: Schema changes for nextGen feature support
• Assignee: Aravindan Vijayan
• Reporter: Aravindan Vijayan
• Created: 17/Apr/17 17:53
• Updated: 13/Mar/23 16:28
• Resolved: 01/Apr/18 19:52

Description

Presently, AMS stores (metricName, 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.

This epic is used to track the investigation and implementation of 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

• relates to: AMBARI-23212 AMS Perf enhancements required for 1000+ nodes