16.20 - StringSimilarity Input - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)
The table can have additional columns, but the function ignores them.
Column Data Type Description
column1 CHARACTER or VARCHAR [Column appears once for each specified column1.] String to compare to string in column2.
column2 CHARACTER or VARCHAR [Column appears once for each specified column2.] String to compare to string in column1.
accumulate_column Any [Column appears once for each specified accumulate_column.] Column to copy to output table.
If any column1 or column2 in the input table schema supports more than 200 characters, you must cast it to VARCHAR(200). See example in StringSimilarity Syntax Elements.