Example: Multiple Input Matrixes, One SQL Statement - Teradata Vantage

In the following example, table T has the same weather data as table T in Example: One Input Matrix, Single SQL Statement and Example: One Input Matrix, Multiple SQL Statements. There is an additional VARCHAR column for continent, which is the matrix id. The aim is to produce 7 SSCP matrixes, one for the data of each continent.

Use an SQL statement that invokes CALCMATRIX twice, once for the LOCAL phase and once for the COMBINE phase.

select * from calcmatrix( ON (
   select * from calcmatrix( ON (select continent, temperature,    air_pressure, rainfall from T) LOCAL ORDER BY continent USING    PHASE('LOCAL') )X )
   HASH BY continent
   LOCAL ORDER BY continent
   USING PHASE('COMBINE')
   )Y
   order by continent, rownum;

The result set in the following tables is the SSCP matrix for weather data by continent.