Recommendations for Using Analytic Functions - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

Use ASCII client collation when executing analytic functions. If your data has UNICODE characters, set the UTF8 client character set and Collation set to ASCII for the user session.

See Knowledge Article KB0052472, available at https://docs.teradata.com/. You must log in before you can search for it.

Multinational Collation

If the user session collation is set to Multinational, analytic functions may report an error in certain situations. Best practice is to do the following:

  • Reduce the size or number of input and output fields.
  • Remove ORDER BY from larger output data fields.
  • Run the query with the user session collation set to ASCII.