TD_ColumnSummary Output - 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ā„¢

Output Table Schema

Column Data Type Description
ColumnName VARCHAR

(CHARACTER SET UNICODE)

Name of target column.
DataType VARCHAR

(CHARACTER SET LATIN)

Data type of target column.
NonNullCount BIGINT Count of non-NULL values in target column.
NullCount BIGINT Count of NULL values in target column.
BlankCount BIGINT Count of blank values (values with all space characters) in target column when data type is CHAR or VARCHAR; otherwise NULL.
ZeroCount BIGINT Count of zero values in target column when data type is NUMERIC; otherwise NULL.
PositiveCount BIGINT Count of positive values in target column when data type is NUMERIC; otherwise NULL.
NegativeCount BIGINT Count of negative values in target column when data type is NUMERIC; otherwise NULL.
NullPercentage DOUBLE PRECISION Percentage of NULL values in target column.
NonNullPercentage DOUBLE PRECISION Percentage of non-NULL values in target column.