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 | If data type is char or varchar, count of blank values (values with all space characters) in target_column; otherwise NULL. |
ZeroCount | BIGINT | If DataType is numeric, count of zero values in target_column; otherwise NULL. |
PositiveCount | BIGINT | If DataType is numeric, count of positive values in target_column; otherwise NULL. |
NegativeCount | BIGINT | If DataType is numeric, count of negative values in target_column; otherwise NULL. |
NullPercentage | DOUBLE PRECISION | Percentage of NULL values in target_column. |
NonNullPercentage | DOUBLE PRECISION | Percentage of non-NULL values in target_column. |