7.00.02 - SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
SELECT * FROM JSONParser (
  ON json_parser_data_2
  TextColumn ('data')
  Nodes ('GlossEntry/ID', 'GlossEntry/SortAs', 'GlossEntry/GlossTerm',
         'GlossEntry/Acronym', '/email')
  SearchPath ('/glossary/GlossDiv/GlossList')
  Delimiter (' | ')
  Accumulate ('id')
  MaxItemNum (10)
) ORDER BY 1, 2;