1.1 - Teradata NewSQL Engine - Teradata Vantage

Teradata Vantage™ Release Summary

Teradata Vantage
Release Number
Release Date
July 2019
Content Type
Release Notes
Publication ID
English (United States)
The following is a partial list of known issues for NewSQL Engine.
Issue/JIRA Description Workaround
DBSF-2235 CREATE USER fails when user is assigned password that contains numbers or special characters. Default behavior is to disallow passwords with numbers and special characters.
To allow passwords with numbers and special characters, do the following:
  1. Enable capability in DBC.SysSecDefaults by setting specialcharacters to T.
  2. Restart database.
DBSQ-3078 NewSQL Engine functions do not support aliases; therefore, aliases cannot provide backward compatibility for function names.
Only one function name changed. RandomForestPredict is now DecisionForestPredict.
None. You must change the old function name.
DBSQ-3762 Error messages show old, nonstandardized argument and table names. For old names that appear in error messages and their corresponding new names, see Teradata Vantage™ Machine Learning Engine Analytic Function Reference, B700-4003.
TDAF-287 Function arguments that specify multiple columns accept only lists of column names, not column ranges or a combination of column names and column ranges. None.
TDAF-368 NewSQL Engine analytic functions can be memory- and compute-intensive, depending on function parameters and input table sizes. This is a partial list of functions. For more information, see Teradata Vantage™ NewSQL Engine Analytic Functions, B035-1206. Teradata strongly recommends that DBA use Workload Management to create a throttle on how many analytic functions can run simultaneously, to avoid impacting other workloads.

The throttle can be applied post NewSQL Engine release

The throttle enables the DBA to control the number of Amp Worker Tasks (AWTs) used by potentially long- running analytical queries and provides control over memory consumed by these analytical queries.

Teradata recommends placing the following analytic functions under throttle control:
  • NaiveBayesPredict
  • DecisionTreePredict
  • DecisionForestPredict
  • GLMPredict
  • SVMSparsePredict
  • NaiveBayesTextClassifierPredict
  • MovingAverage
  • NGramSplitter
  • Pack
  • Unpack
  • Antiselect
  • StringSimilarity
  • Attribution
  • Sessionize
  • nPath

For information about: