On occasion there is a requirement to change data within a table. This can be for compliance or regulatory reasons and may require the alteration or deletion of rows or columns. This can be achieved through the use of Alter.
Alter: Configure it!
To configure the Alter service for your platform information can be found here - Alter Service
The alter process use some of the Query infrastructure to do work. More information on this can be found here Query
|Component||Description||Scale to 0|
|App. Load-balancer||An application load-balancer used to route traffic to the Query Heads.||Yes|
|Query Head||The Query Head servers receive the requested queries and farm them out to the Query peers for execution.||Yes|
|Alter Job Queues||Contain a list of Alter jobs to be completed.||No|
|Alter Head||Retrieves jobs from the job queue and splits this into tasks (individual partition jobs) to be placed onto the Alter Task Queue.||No|
|Alter Task Queue||Contain a list of tasks by partition that need to be satisfied to complete a job.||No|
|Alter-Peer||A deployed server running a number of micro-services.||Yes|
|HDX DB Storage Bucket||Contains the database (including partitions), configuration and other state information concerning the platform. Forms part of the core infrastructure.||No|
|Catalog||Contains metadata on the database, partitions and job tasks. Forms part of the core infrastructure.||No|
|Alter Job State Tracker||A database table that contains the state of all alter tasks.||No|
Updated about 2 months ago