- ON Clause
- Accept the InputTable and ModelTable clause.
InputTable must be a DIMENSION table with an optional ORDER BY clause. Because InputTable is a DIMENSION input, it is copied to the spool for each AMP before running the query. The user spool limits the size and scalability of the input.
ModelTable can have no partition at all or have the following combinations of PARTITION BY ANY/ORDER BY clauses:- PARTITION BY ANY ORDER BY
- PARTITION BY ANY
- IdColumn
- Specifies the column name containing unique identifier of input rows.
- VectorColumn
- Specifies the column containing the vector embeddings.