ONNXSeq2Seq Example: OutputLength VARCHAR (10000) with Constants - Teradata Vantage

Teradata Vantage™ - Bring Your Own Model User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Vantage
Release Number
20.00
Published
February 2026
ft:locale
en-US
ft:lastEdition
2026-02-18
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274
The following examples use .set width 175, unless overridden in the query:
SELECT * FROM td_mldb.ONNXSeq2Seq(
  ON (SELECT id,
     10 AS min_length,
     84 AS max_length,
      4 AS num_beams,
    1.2 AS repetition_penalty,
    2.0 AS length_penalty,
      1 AS num_return_sequences,
    content as txt, headline, category FROM JulesBelvezeDummyData WHERE id <= 5) as InputTable
  ON (SELECT * FROM onnx_models WHERE model_id='t5-small-headline-generator') AS ModelTable DIMENSION
  ON (SELECT tokenizer FROM sequence_tokenizers WHERE model_id='t5-small-headline-generator') AS TokenizerTable DIMENSION
USING
  Accumulate('id')
  ModelOutputTensor('sequences')
  OutputLength(10000)
) AS td
ORDER BY id;
 
*** Query completed. 5 rows found. 2 columns returned.
*** Total elapsed time was 5 seconds.
id sequences
----------- ---------------------------------------------------------
1 Facebook releases a report that shows what content was most widely viewed by Americans between April and June
2 'Quantum Battery': The Bigger the Battery, The Faster It Charged, demonstrating Superabsorption at Work
3 Founder Elon Musk laughed off the incident, saying it was fine
4 Scalene is a high-performance CPU and memory profiler for Python
5 'Cube Satellites' are taking photos and infrared images of factories, retail parking lots, oil tankers, and more and selling them to hedge funds and banks looking