Allowed Multiple-Input Structures - 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

A multiple-input SQL-MapReduce function operates on at least two input data sets. There are two alternatives for organizing the inputs:

  • For the first input, specify PARTITION BY ANY; for the others, specify DIMENSION.
  • For the first input, specify PARTITION BY p_attribute_set; for the others, specify either PARTITION BY p_attribute_set or DIMENSION.