How do I save the output of a SQL-MapReduce function? - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

Use a CREATE TABLE AS SELECT statement:

CREATE FACT TABLE output DISTRIBUTE BY HASH (word) AS
SELECT word, sum(count) FROM tokenize(ON documents) GROUP BY word;