7.00.02 - SQL-MapReduce Call - 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)
SELECT * FROM Multi_Case (
  ON (SELECT *,
    (age < 1) AS case1,
    (age >= 1 AND age <= 2) AS case2,
    (age >= 2 AND age <=12) AS case3,
    (age >=13 AND age <=19) AS case4,
    (age >=16 AND age <=25) AS case5,
    (age >=21 AND age <=40) AS case6,
    (age >=35 AND age <=60) AS case7,
    (age >=60) AS case8
    FROM people_age
  )
  Labels (
    'case1 AS "infant"',
    'case2 AS "toddler"',
    'case3 AS "kid"',
    'case4 AS "teenager"',
    'case5 AS "young adult"',
    'case6 AS "adult"',
    'case7 AS "middle aged person"',
    'case8 AS "senior citizen"'
  )
) ORDER BY id;