Function Mapping and the ON Clause - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

For information on how to create a function mapping, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

The correlation_name must correspond to a name IN TABLE parameter in the function mapping definition. The correlation_name can be any name if the function mapping definition specifies ANY IN TABLE.

The following statement defines the function mapping Attribution.

CREATE FUNCTION MAPPING appl_view_db.Attribution
   FOR attribution SERVER coprocessor 
   MAP JSON ( '{ "function_version": "1.0" }') 
   USING
      ANY IN TABLE,
      conversion IN TABLE,
      excluding IN TABLE,
      optional IN TABLE,
      model1 IN TABLE,
      model2 IN TABLE,
      EventColumn, TimestampColumn, WindowSize;

The following SELECT statement executes the function mapping Attribution.

SELECT * FROM appl_view_db.Attribution ( 
         ON appl_view_db.input_table PARTITION BY 1
         ON appl_view_db.model1 AS model1 DIMENSION
         USING
            TimestampColumn('tscol')
            EventColumn('eventcol')
            WindowSize('rows:10')
) AS dt;