Syntax - 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
SELECT ... FROM STREAM (ON input_relation SCRIPT 'script_name');
SELECT ...
FROM STREAM
   (ON {table_name | view_name | (query)}
     [PARTITION BY expression [, ...]]
     [ORDER BY expression [ASC | DESC] [, ...]]
     [SCRIPT ('[runtime_name] scriptname')]
     [MEM_LIMIT_MB ('int' | 'unlimited')]
     [OUTPUTS ('column_name column_type' [, ...])]
     [NULLSTRING ('null_string')]
     [DELIMITER ('delimiter_character')]
[TYPEFORMAT ('boolean', 'TRUE', 'FALSE')])
   ) [[AS] alias]
  [, ...]
  [WHERE ...]
  [GROUP BY ...]
  [HAVING ...]
  [ORDER BY ...]
  [LIMIT ...]
  [OFFSET ...]
);