Datatype Change in Accumulated Columns | Teradata Vantage - Datatype Change in Accumulated Columns - 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ā„¢
The following functions change the data type of a column in the input table to a different data type in the output table:
  • TD_NumApply

    If you set the Inplace argument as false and specify the target columns in the Accumulate argument, then the data type of target columns in the output can be REAL or FLOAT.

  • TD_StrApply

    If you set the Inplace argument as false and specify the target columns in the Accumulate argument, then for the following StringOperation argument values, the data type of target columns is VARCHAR (UNICODE) in the output:

    STRINGCON, STRINGLIKE, STRINGPAD, STRINGTRIM, STRINGINDEX ]

  • TD_NonLinearCombineTransform

    If you specify the target columns in the Accumulate argument, then the data type of the target columns in the output can be REAL or FLOAT.

  • TD_KMeansPredict

    If you specify the target columns in the Accumulate argument, then the data type of the target columns in the output can be REAL or FLOAT.

  • TD_Silhouette

    If you specify the target columns in the Accumulate argument, then the data type of the target columns in the output can be REAL or FLOAT.

  • TD_RandomProjectionTransform

    If you specify the target columns in the Accumulate argument, then the data type of the target columns in the output can be REAL or FLOAT.

  • TD_SentimentExtractor

    If you specify the Text column in the Accumulate argument, then the data type of the Text column in the output is VARCHAR (UNICODE).

  • TD_FunctionTransform

    If a numeric column is not specified in the IDColumns argument, then the data type of the numeric column in the output can be REAL or FLOAT.

  • Pack

    If you set the Colcast argument as True and specify the target columns in the Accumulate argument, then the data type of target columns in the output can be VARCHAR.

  • TD_Qqnorm and TD_PolynomialFeaturesTransform

    The target columns are by default included in the output. The data type of the target columns included in the output can change to Double Precision or FLOAT.

  • TD_NBTCT

    If you specify the datatype for the token or doccategory columns as Char or VARCHAR, then the data type of token or category in the output can be VARCHAR Unicode.

  • TD_Histogram

    If you specify the datatype for label from minmaxtable table schema as BYTEINT, SMALLINT, INTEGER, or BIGINT, then the data type of the label in the output can be BIGINT. If you specify CHAR or VARCHAR as the datatype for the label, then the data type of the label in the output can be VARCHAR Unicode.