Step 1: Use Scale to Create Table of Scaled Data - Aster Analytics

CREATE TABLE housing_normalized DISTRIBUTE BY HASH(id) AS
  SELECT * FROM Scale (
    ON computers_train1 AS INPUT PARTITION BY ANY
    ON (SELECT * FROM ScaleMap (
      ON computers_train1
      InputColumns ('[1:5]')
      MissValue ('omit'))
    ) AS statistic DIMENSION
    Method ('maxabs')
    Accumulate ('id')
  ) ORDER BY id;