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;