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

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
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;