Size Limit on Constant String - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

If you provide a constant string without a datatype in the ON clause of a SQL-MapReduce function, you will see an error message like:

ERROR: row is too big: size 34080, maximum size 32736

You can avoid this error by doing one of these workarounds:

  • Cast the content string to the VARCHAR datatype.
  • Put the constant string into a table, and use a SELECT statement to retrieve it.