SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
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;