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
Publication Date
May 2026
Content Type
User Guide
Publication ID
B700-1111-051K
ft:locale
en-US
ft:lastEdition
2026-06-18
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
ft:sourceId
dita
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